How to split column values

sgnarkhede2016

Hello,

I have column  'type' and "Attribute" that contain values

1       ?

2        FINANCIAL PRODUCT=REMITTANCE;Travel Card;Foreign Exchange

3        FINANCIAL PRODUCT=REMITTANCE;Travel Card

4         FINANCIAL PRODUCT=REMITTANCE;Travel Card |MESSAGE DIRECTION=I

5         ?

6         ?

how can split this column like
FInancial Product                                                               MessageDirection
REMITTANCE;Travel Card;Foreign Exchange                   I
w.r.t. type

Telcontar120

Try the "Split" operator and designate the "=" as the split character.
You could also split the subsequent list by using the ";" character if you want.