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