Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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,

Tags:
Former Member
replied

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

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question