I need to copy only the numerical value and paste it in a new column using the field calculator NameNew_value('tienda la samaritana', 100)100('tienda ferco', 64)64

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; } } }

extract a numeric value from a text string, with the field calculator

Operativo_GISRTM_GIS

I need to copy only the numerical value and paste it in a new column

using the field calculator

Name	New_value
('tienda la samaritana', 100)	100
('tienda ferco', 64)	64

Najděte více příspěvků označených jako

Analysis

Accepted answers

JohannesLindner

import re

def extract_number(txt):
    numbers = re.findall(r"\d+", txt)
    if not numbers:
        return None
    return numbers[0]

All comments

bixb0012

The Name column looks like a string representation of a Python tuple containing a str and int., so using Python eval built-in should work:

>>> a = "('tienda la samaritana', 100)"
>>> eval(a)[1]
100
>>>

JohannesLindner

import re

def extract_number(txt):
    numbers = re.findall(r"\d+", txt)
    if not numbers:
        return None
    return numbers[0]

Operativo_GISRTM_GIS

Does it matter which coding language you use? Python

Is the "Name" column consistently formatted? string

Will there ever be numbers in the first part of the string? it´s Possible

danretired

If there are no other numbers as in the examples you have shown...

a = "('tienda la samaritana', 100)"

b = int("".join([i for i in a if i.isnumeric()]))

b
100

as a field calculator expression replace 'a' with !YourFieldName! and don't assign it to b,

jcarlson

Does it matter which coding language you use?

Is the "Name" column consistently formatted?

Will there ever be numbers in the first part of the string?

If the number is always at the end of the string like that, you could use Split, Left, and Count to accomplish this in Arcade.

var test_string = "('tienda la samaritana', 100)"

var split_string = Split(test_string, ',')
Console(split_string)

var number_portion = split_string[-1]
Console(number_portion)

var the_number = Left(number_portion, Count(number_portion) - 1)
Console(the_number)

return Number(the_number)

Here's the console:

["('tienda la samaritana'"," 100)"]
 100)
 100

And here's the output:

If you prefer to use Python, you could probably get this done with a regular expression.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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