Extract specific text from a cell - output in another column

[andyb]

Hi All,

Apologies if this has been addressed before but I have a question about extracting out a specific string from cells in a column and outputting to another column. The string type could appear multiple times within the same cell. 

In the attached sample sheet, I'd like to pull out any string that is '[TR.....]' and add to my output column (column D)

Any suggestions/help would be much appreciated. Thanks!

[neilgallen · Accepted solution]

because your text could appear multiple times in the same string, you'd want to use the tokenize capabilities of RegEx. The attached workflow gets you there, based on your example (however I think your proposed output column contains an error).

You are setting you RegEx pattern to be (\[TR_\d+\]).

Essentially, look for a bracket followed by the letters "TR" and an underscore, then at least one (but could be multiple) numbers, then a closing bracket. Because of the notation of RegEx, the "\" needs to proceed each bracket.

[andyb]

that did the trick. Thanks so much!