Parsing a large free text field

[Kmassey]

Hi - 

I have a free-text entry field in my application into which my clients list vendor technologies they use. I'd like to parse the field to ID each technology and frequency of occurrence. The largest entry is 5,033 characters. I started with text to columns using comma as the delimiter, but with this large list, I would have to split it up to 100 or so columns. This would work this time, but next time the max could be even larger.

Is there a way to parse the field and dynamically create the columns?

FYI, the field uses different delimiters as well - some entries use comma, some use semicolon, some use new line, etc.

Thanks!

[gawa · Accepted solution]

@Kmassey 

In your case, "Split to rows" option should be selected.

Also, you can specify multiple delimiters like this.

[Kmassey]

thank you!