Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Regex parsing on multiple sheets

sriniprad08
11 - Bolide

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

9 REPLIES 9
ShankerV
17 - Castor

@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
11 - Bolide

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
17 - Castor
17 - Castor

Hey @sriniprad08,

You here is one way to parse this with Regex:

IraWatt_0-1670239072676.png

For parsing the responses, I used this regex:

(\d\|.+?\.)

IraWatt_1-1670239126561.png

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
7 - Meteor

Hello,

 

Here is the regex solution to extract the required information

Lukesmith16
7 - Meteor

Hi, 

 

Below is a reg ex solution. 

sriniprad08
11 - Bolide

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
11 - Bolide

Hi @Lukesmith16 ,

 

Thank you so much for the time and help. 

 

Cheers

Sri

sriniprad08
11 - Bolide

Hi @mennatuallah_ag ,

 

Thank you so much for the help. Its useful.

 

Cheers,

Sri

IraWatt
17 - Castor
17 - Castor

No worries @sriniprad08, glad it helped ! 😄

Labels