Regex parsing on multiple sheets

[sriniprad08]

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

[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

[IraWatt · Accepted solution]

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%20...

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[mennatuallah_ag · Accepted solution]

Hello,

Here is the regex solution to extract the required information

[Lukesmith16 · Accepted solution]

Hi, 

Below is a reg ex solution. 

[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 ! 😄