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,

       

      Alessandro