We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

Parsing of a Data

DataPirate26
9 - Comet

Hello, 

 

Can anyone guide me to parse this data from the given below:

 

||`General Population 10-12-2021$`          -          I need to parse out General Population 

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @DataPirate26 

 

Use Regex function like below.

 

Formula:

REGEX_Replace([Field1], ".*`(.+)\s\d.+", "$1")

 

Workflow:

atcodedog05_0-1634884580980.png

 

Hope this helps : )

 

messi007
15 - Aurora

@DataPirate26,

 

Data cleansing will do the job as well.

 

messi007_0-1634885715076.png

 

Attached the workflow,

Regards,

 

DataPirate26
9 - Comet

Hello, 

 

This worked perfectly. Thanx a lot for your quick help. 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @DataPirate26 

Cheers and have a nice day!

Labels