I have a esri feature class, and one of the columns (populations) contains values in different formats, all in text (1234 | 1,234 | 123 txt | 12 txt. 34 | <Null>).
I want all the values in a new integer field.
Is there anyone who can help me to get rid of the text and (1234).
Try a StringReplacer in regular expression mode. Text to replace:
^([0-9,]+)Replacement text:
\1This will leave only the first digits + commas at the start of the attribute.
If you want to get rid of the comma you can use a second StringReplacer and leave the Replacement text empty:
+60I think a StringReplacer with this regex:
\(.+\)|\Dshould do the trick. Replace the matches with nothing and you should be left with all digits as long as they're not between ()
Essentially the same as @david_r suggests, but in one go.