Regex data conversion

[Shaaz]

Hi,

I've below the data with code and RegEx expression of it (highlighted in yellow) and I need to convert the code as per RegEx Expression and it should be dynamic.

I need to get output as highlighted in Green

[Qiu]

@Shaaz 
Are the RegEx patterns listed all?

[Shaaz]

We get list of regex Codes.

[grchavarri]

Hi @Shaaz 

I was trying to do it as simple as possible but unfortunately im not getting the result because im missing something in the config. But im leving you here what i was trying just if someone get some ideas or know how to complete that. 

As a solution, the best way to do what you are looking for is with a batch macro where you change the input and the operation dynamicly. 

Please find the image 

Hope it helps, 

Pd, ive tried some of the regex that where in the list, and some of them are not working as you mentioned. At least in regex101

Best,

[atcodedog05]

Hi @Shaaz 

Edit:

This is interestingly a tricky one. Can you please share the above input data (data in screenshot) as an excel file.

We will be happy to help : )

[Shaaz]

Here is the sample data in excel.

[apathetichell]

@Shaaz- your regex is wrong.  You cannot get the output you are looking for from this input with the regex expressions you are using. This cannot work. You cannot throw in 4009 to that  regex expression and magically create 04009-0411.

@grchavarri- good try on your approach. I'd recommend adding a filter tool prior the regex tool.