Parsing Multiple Acronyms from a field

Question

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!

Regex tool.docx

Aaron_Foster · Accepted Answer

Switch your output method to Tokenize.

GMG0241 · Accepted Answer

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)