Skip to Content
avatar image
Former Member

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.

ColumnA ColumnB ColumnC ColumnD ColumnE AB/9.40/01200/KLMN AB 9.40 01200 KLMN AB/9.40/01200/RSMN AB 9.40 01200 RSMN AB/11.90/01200/RSMN AB 11.90 01200 RSMN BC/25.50/0400/TRLM BC 25.50 0400 TRML BC/25.50/0600/PRMS BC 25.50 0600 PRMS


Best Regards,

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 01, 2015 at 08:11 AM

    Hi ,

    Use length([ColumnB] to find the Columns C's Starting point.

    here length([Column B]) will give you 2.

    So take out string from ending point of Column B and treat it same way as you extracted Column B to get the Column C and so on...

    For Column D use legths of Column B and Column C

    Add comment
    10|10000 characters needed characters exceeded