Excel: How to extract data using Regex and paste the results to a different column?

[Tana20]

Hi,

I would like to extract the data that is in parentheses from the “OFS” column and paste it into the “PT” column.

Expected Results:

I tested the Regex pattern and it works as expected:

However, this is the result I’m getting:

This is what I have so far:

RegexTest.zip (42.7 KB)

Any help would be greatly appreciated!

[ppr (Peter Preuss)]

@Tana20
Have a look on following regex:

Change the flow like:

• add data column PT if it is not already present

• inside the for each row block do following

row("PT") = System.Text.RegularExpressions.Regex.Match(row("OFS").toString,"(?<=\().*(?=\))").toString

After the for each row write updated data back to Excel

[Tana20]

Thank you! It works!

RegexTest.zip (42.0 KB)