Parsing Multiple Acronyms from a field

[jenettd]

Hi,

I'm trying to parse multiple acronyms from a field.

For instance, "I want to parse ABC and XYZ from the field" - how do I parse ABC and XYZ from the column and place it in a new column? I'm using the Regex tool, which this expression - ([A-Z]{2,}) ;however, it is only extracting ABC and not XYZ.

Thanks!

[Aaron_Foster · Accepted solution]

Switch your output method to Tokenize.  

[GMG0241 · Accepted solution]

You can do it dynamically by using the following configuration:

where $& means 'everything that matches' and I've added a , to separate the strings. You can also do it the way highlighted by @Aaron_Foster  above, but instead split to rows, and then use the data that way, (e.g. summarize tool + concatenation)

[jenettd]

This worked. Thank you for your responses.