nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Separate Numeric Part of Record into Separate Field

MeKohler

@ $2,246/ac = 2,253.29" and would like to separate out the bold portion into a separate field. Can I do this in field calculator?

Thanks,

Michael Kohler

Vind meer berichten getagd met

Accepted answers

danretired

@ $2,246/ac = 2,253.29"

float(s.split(" ")[-1].replace(",",""))

s = "1.03 ac @@ $2,246/ac = 2,253.29"
float(s.split(" ")[-1].replace(",",""))
2253.29
#
# shorter number
s = "1.03 ac @@ $2,246/ac = 253.29"
float(s.split(" ")[-1].replace(",",""))
253.29

assuming the number is always the last and the number is comma delimited.

's' is your field name of course

danretired

destination field needs to be "double" aka float

source field is text see attached since I can't insert the image here for some reason

x.png

All comments

danretired

@ $2,246/ac = 2,253.29"

float(s.split(" ")[-1].replace(",",""))

s = "1.03 ac @@ $2,246/ac = 2,253.29"
float(s.split(" ")[-1].replace(",",""))
2253.29
#
# shorter number
s = "1.03 ac @@ $2,246/ac = 253.29"
float(s.split(" ")[-1].replace(",",""))
253.29

assuming the number is always the last and the number is comma delimited.

's' is your field name of course

MeKohler

Thanks!

JoshuaBixby

The following is possibly overkill for your situation, but regular expression is the hammer I like to use on everything like a nail. 🙂

The following uses regex to extract all three numerical values in the text string, and then return one of them based on how the custom function is called. If the string field is NULL then NULL is returned.

Expression Type:

PYTHON3

Expression:

extract_value(!text_field!, "total")

Code Block:

import re

pattern = re.compile(
    r"(?P<acre>[\d,.]+)\s*ac\s*@@\s*\$"
    r"(?P<price>[\d,.]+)/ac\s*=\s*"
    r"(?P<total>[\d,.]+)"
)

def extract_value(field, value):
    if field is not None:
        match = re.search(pattern, field)
        return match.groupdict()[value]

MeKohler

Hi Dan, when I entered the code as you wrote it, it works. But when I enter the field name, I get and error. If my field name is "Notes" do I enter the expression as:

float(!Notes!.split("$")[-1].replace(",",""))

danretired

destination field needs to be "double" aka float

source field is text see attached since I can't insert the image here for some reason

x.png

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Inloggen
Registreren

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.