We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

RegEx Parse

stevenlsj789
8 - Asteroid

Hi all, 

 

I am trying to use RegEx parse this column-  each has various components within the double quotation and sometimes it has 6 components (like this one below), sometimes it has just one. I am struggling with the Regular expression that can summarize it well so I can parse each component to its columns. Could someone please help? Thank you! 

 

["Lateef Investment Management","Polen Capital Management, LLC","Private Capital Management","DUPONT CAPITAL MANAGEMENT CORP","Bank of Hawaii","Gotham Asset Management, LLC"]

2 REPLIES 2
apathetichell
20 - Arcturus

I love regex - but I think text to columns, , delimiter, split to rows, and ignore delimiter in quotes might be faster.

 

([a-zA-Z\,\s]+) is tokenize is fairly close too - but @Qiu 's solution is superior.

Qiu
21 - Polaris
21 - Polaris

@stevenlsj789 
Maybe we use Tokenize function.

Capture2A.PNG

Labels
Top Solution Authors