Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
chethan_ashoka_
Contributor II
Contributor II

Load delimiter file into Qlikview

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

Delimiter is Ð|Ð

1 Solution

Accepted Solutions
shilpan
Luminary Alumni
Luminary Alumni

See the script attached

View solution in original post

3 Replies
ychaitanya
Creator III
Creator III

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
Luminary Alumni
Luminary Alumni

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