Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Regex Practic

jpatel3868
7 - Meteor

Screen Shot 2021-11-10 at 10.31.44 AM.png

 

Need to turn the data in DATA into three columns Ticker Bid Ask with the conditions given using regex. Having some trouble with the punctuation

 
2 REPLIES 2
DanM
Alteryx Community Team
Alteryx Community Team

@jpatel3868 

 

You don't have a good pattern in the data to make the REGEX expression without multiple expressions. You may need to use 1 or more the tools. You also could remove the punctuation by using the Find and Replace tool and replace the punctuation with '' nothing. Then use the spaces and dash to create an expression. Either way, due to the lack of consistent pattern you'll need to use several tools to correctly parse it out.

jpatel3868
7 - Meteor

Makes sense. Any help you can give on using Regex for the first row?

Labels
Top Solution Authors