5 Replies Latest reply: Feb 11, 2018 1:08 PM by Michal Szulborski RSS

    How to get multiple values between 'pipe' from a substring

    alessandro trinca

      Hello everyone,


      could anyone help me in this?


      I've to get multiple values from a .dat file in which any record has a filed containing 4 values (sub-fields), separated by a pipe ('|'); any value can have 1, 2 or more characters; for example:


      record 1, field 1  -      xxxxx|0|12|2|453|xxxxxxx

      record 2, field 1  -      xxxxx|23|401|2|121|xxxxxx


      Any value between pipes have to become a field in Qlik (value1, value2, value3, value4).


      Which is the best way to solve this?


      Thanks in advance,