# Splitting Values in Webi

Hi,

I want to split Column A's values to Column B's values, Column C's values, Column D's values and Column E's values by using separator "/" sign.

I could get ColumnB like below formula.

ColumnB=Substr([X Query ].[ColumnA];1;Pos([X Query ].[ColumnA];"/")-1)

Can you help me to get other values of other columns, please?

I should see the table like below.

ColumnAColumnBColumnCColumnDColumnE
AB/9.40/01200/KLMNAB9.4001200KLMN
AB/9.40/01200/RSMNAB9.4001200RSMN
AB/11.90/01200/RSMNAB11.9001200RSMN
BC/25.50/0400/TRLMBC25.500400TRML
BC/25.50/0600/PRMSBC25.500600PRMS

Best Regards, ##### Tanveer Ahmed Mohammedreplied

Hi,

Create below formulae to get your Column B, C and D

Column B = = Substr([Column A];1;Pos([Column A];"/")-1)

Column B INPUT = Substr([Column A];Length([Column B])+2;Length([Column A]))

Column C = Substr([Column B INPUT];1;Pos([Column B INPUT] ;"/")-1)

Column D INPUT = Substr([Column A];Length([Column B])+ Length([Column C])+3;Length([Column A]))

Column E = = Substr([Column A];Length([Column B])+ Length([Column C])+ Length([Column D])+4;Length([Column A]))

Use Column B, Column C, Column D in your table along with the Column A to get the result as shown below.

I have included all the columns just to how the workflow Thanks,

Tanveer

1 View this answer in context