Regex parsing on multiple sheets

Hi Team,

Hope you are well. I have regex problem. which i need help,

1) The excel file has two sheets and each has different way of parsing. It also shows the current state and the "new" or the intended output.

I tried doing basic but not sure how to go about it.

Please find attached the excel sheet and alteryx flow,

thanks for the help,

Sri

Copy of Output_2_new.xls

regex_try.yxmd

Regex

Output

Expression

Accepted answers

IraWatt

Hey @sriniprad08,

You here is one way to parse this with Regex:

For parsing the responses, I used this regex:

(\d\|.+?\.)

To break it down:

\d

looks for a digit

\|

This looks for a pipe, it has to be backlashed as it's a special character.

.+?\.

This then collects all the characters before a point, the question mark makes it non greedy.

If you want to learn more about Regex the community has some really quick interactive videos on getting to grips with it here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20Data

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Workflow.yxmd

mennatuallah_ag

Hello,

Here is the regex solution to extract the required information

solution_regex.yxmd

Lukesmith16

Hi,

Below is a reg ex solution.

New Workflow reg ex.yxmd

All comments

ShankerV

@sriniprad08

Please let me know what is the expected output.

Also which column you need to use it for parsing.

Many thanks

Shanker V

sriniprad08

hI @ShankerV ,

Thank you for the reply. Please find attached the file

1) Marked in blue - for parsing

2) Yellow - the intended output,

Thanks again,

Sri

Copy of Output_2_new.xls

IraWatt

Hey @sriniprad08,

You here is one way to parse this with Regex:

For parsing the responses, I used this regex:

(\d\|.+?\.)

To break it down:

\d

looks for a digit

\|

This looks for a pipe, it has to be backlashed as it's a special character.

.+?\.

This then collects all the characters before a point, the question mark makes it non greedy.

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Workflow.yxmd

mennatuallah_ag

Hello,

Here is the regex solution to extract the required information

solution_regex.yxmd

Lukesmith16

Hi,

Below is a reg ex solution.

New Workflow reg ex.yxmd

sriniprad08

Hi @IraWatt ,

Thank you so much for the help and clear explanation and offer to help.

I will go through the regex link and progress.

Cheers,

Sri

sriniprad08

Hi @Lukesmith16 ,

Thank you so much for the time and help.

Cheers

Sri

sriniprad08

Hi @mennatuallah_ag ,

Thank you so much for the help. Its useful.

Cheers,

Sri

IraWatt

No worries @sriniprad08, glad it helped ! 😄

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703