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"]
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.
@stevenlsj789
Maybe we use Tokenize function.