Load delimiter file into Qlikview

[chethan_ashoka_]

Please help me by loading the attached sample file into qlikview.

Delimiter is Ð|Ð

[ychaitanya]

Can you try replacing the Ð|Ð sequence with ',' and use comma delimited file load, as the above substring is difficult for Qlik to read .

Thanks

CY

[shilpan · Accepted solution]

See the script attached

[MarcoWedel]

maybe like this?

LOAD TextBetween(@1,'Ð','Ð') as ROW_ID,
    TextBetween(@2,'Ð','Ð') as CREATED,
    TextBetween(@3,'Ð','Ð') as CREATED_BY
FROM  (txt, codepage is 1252, no labels, delimiter is '|', msq, filters(Remove(Row, Pos(Top, 1))));

hope this helps

regards

Marco