topic Re: Separate Numeric Part of Record into Separate Field in Python Questions

Separate Numeric Part of Record into Separate Field

MeKohler — Fri, 20 Mar 2026 15:38:03 GMT

Hi, I have a text string "1.03 ac @@ $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

Re: Separate Numeric Part of Record into Separate Field

DanPatterson — Fri, 20 Mar 2026 16:18:10 GMT

s = "1.03 ac @@ $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

Re: Separate Numeric Part of Record into Separate Field

MeKohler — Fri, 20 Mar 2026 16:56:23 GMT

Thanks!

Re: Separate Numeric Part of Record into Separate Field

JoshuaBixby — Fri, 20 Mar 2026 19:27:08 GMT

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]

Re: Separate Numeric Part of Record into Separate Field

MeKohler — Mon, 23 Mar 2026 17:54:01 GMT

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(",",""))

Re: Separate Numeric Part of Record into Separate Field

DanPatterson — Mon, 23 Mar 2026 19:18:08 GMT

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