Regex replace with Conditional loop

EN6924

Hello All,

First 2 columns are my input data as per the attached file. 3rd column mentioned in excel file will be the output.

I can be able to create the output using Regex for a single row -

Also can able to do using if-else+Replace function. Workflow attached.

Need to know how to do this using Regex.

Please help.

Data_Input.xlsx

Test.yxmd

mceleavey

Hi @EN6924 ,

in short, not in any way that would be any more efficient. Is there any reason why you want to specifically use Regex?

I've attached an updated version with a Find and Replace method that removes the need for a huge IF statement.

NOTE: You can remove the "Replace" column and simply replace the entire field with the Data Output column if that's what you want to do. That will remove another step.

This method is much easier to maintain as nobody likes a huge IF statement

M.

Test (1).yxmd