2 Replies Latest reply on Sep 27, 2018 12:32 AM by Welly Pratama

    get specific value

    Welly Pratama

      Hi Guys,

       

      I have data likes this

       

      i want to get only value after "#" and before ";" i have try to use function custom split from Tableau but i only get a few value not all value, example :

      1;#010;#5;#011;#7;#013;#8;#0140;#9;#015;#10;#016;#13;#019;#16;#024;#17;#0250;#22;#0300;#56;#0320;#55;#0330;#24;#0340;#25;#0350;#26;#0510;#32;#0600;#33;#0601;#34;#0602;#35;#0603;#37;#0777;#38;#0780;#54;#0801;#49;#0887;#50;#0888

      from the example data above i want to get result :

      010

      011

      013

      0140

      015

      016

      019

      024

      0250

      0300

      0320

      0330

      0340

      0350

      0510

      0600

      0601

      0602

      0603

      0777

      0780

      0801

      0887

      0888

       

      when i'm using custom split from tableau it's only showing 010 - 015, the value from 016 - 0888 didn't show up.

      Do you guys have an advice for me? i also attach the workbook.