On a text variable in excel..which contains multiple values in text format separated by a comma (similar to a CSV file format), I need to segregate the values into separate columns for each value.
Something like:
text1, text2, text 3 to be converted into Column A for text1, Column B for text2 and Column C for text3....
you can use the Split operator and regular expression for that.
Other alternative is to use the Tokenize operator from text processing extenssion.
Best,
Cesar