parsing out string from a field into multiple field depending on the string it matches

[dreweezy]

Hello all,

I am trying to parse out specific values from a long text depending on what the users input from our GUI/tool. Our data is being stored in one field/column and I hope to parse out specific values/texts from that field and place a "X" or a "1" to denote that those texts have been found in their respective new columns.

Example - 

Column 1 (String) - "Finance, Accounting, Marketing, IST, IT, Dance,  Business"

Now I have 3 columns that will mark a "X" or a "1" to denote that those values were found in column1 where the string resides. In this case, I will have a "X" marked for Finance, Dance, and Accounting columns.

Image attached to ease the confusion. 

Thank you.

[dplr-rn · Accepted solution]

Use index function in your load script
E.g.
If (index(Column1,'Finance')>0, 1,0) as Finance,
If (index(Column1,'Accountin')>0, 1,0) as Accounting