topic Re: Regex data conversion in Alteryx Designer Desktop Discussions

Regex data conversion

Shaaz — Thu, 13 Jun 2024 22:36:48 GMT

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

Re: Regex data conversion

Qiu — Mon, 03 Jan 2022 09:06:14 GMT

@Shaaz
Are the RegEx patterns listed all?

Re: Regex data conversion

Shaaz — Mon, 03 Jan 2022 09:26:45 GMT

We get list of regex Codes.

Re: Regex data conversion

grchavarri — Mon, 03 Jan 2022 09:45:25 GMT

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,

Re: Regex data conversion

atcodedog05 — Mon, 03 Jan 2022 10:41:07 GMT

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 : )

Re: Regex data conversion

Shaaz — Mon, 03 Jan 2022 11:07:56 GMT

Here is the sample data in excel.

Re: Regex data conversion

apathetichell — Mon, 03 Jan 2022 16:40:50 GMT

@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.