Issue with delimiter

[#1]

Hi All,

Please help me out

I have a source text file which have delimiter is broken bar(¦) and I am using this as a Pipeline Delimiter in QlikView but it’s  not working. Below is the sample example

POLICY NO ¦VE¦ YEAR ¦  TYPE ¦LEAD CLIENT ¦Name

  .12345654   ¦01 ¦1980 ¦SPECIALTY  ¦xxxxxx ¦xxxxxxx  

Regards

Jhanaarthanan

[stabben23]

Hi,

try With this, choose another Character set, then change Delimiter

[#3]

can u pls share ur application

[#4]

Thanks Manoj for your help this is a very huge data file so i used the power shell coding and broken bar(¦) symbol converted into another symbol and i have extracted the data.

Regards

Balram

[#5]

Hi,

understood.

if possible can u share few records in xl ..

[MarcoWedel]

Hi,

if your delimiter does not work, then maybe you could try with something like:

tabInput:
LOAD RecNo() as LineNo,
    Replace(@1,'¦',Chr(9)) as Line
Inline [
POLICY NO ¦VE¦ YEAR ¦  TYPE ¦LEAD CLIENT ¦Name
.12345654  ¦01 ¦1980 ¦SPECIALTY1  ¦xxxxxx ¦xxxxxxx
.12345655  ¦02 ¦1981 ¦SPECIALTY2  ¦yyyyyy ¦yyyyyyy
.12345656  ¦03 ¦1982 ¦SPECIALTY3  ¦zzzzzz ¦zzzzzzz
] (no labels);

tabTemp1:
LOAD Line as Header Resident tabInput Where LineNo=1;

tabTemp2:
CrossTable (ColNum, ColNam)
LOAD 1,* FROM_FIELD (tabTemp1, Header) (txt, utf8, no labels, delimiter is '\t', msq);

mapHeader:
Mapping LOAD ColNum, ColNam Resident tabTemp2;

tabTemp3:
LOAD Line as Values Resident tabInput Where LineNo>1;

tabResult:
LOAD * FROM_FIELD (tabTemp3, Values) (txt, utf8, no labels, delimiter is '\t', msq);

DROP Tables tabTemp1, tabTemp2, tabTemp3, tabInput;

RENAME Fields using mapHeader;

hope this helps

regards

Marco

[MarcoWedel]

please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco