unable to load in comma delimiter csv file correctly

[jim_chan]

Hi guys,

I have a comma delimiter csv file. after I have loaded in. Some of the data in columns not aligned, some shift 1 column to the left, some shifted 1 column to the right.

I have attached the .csv file.  i have use comma delimiter when loading in. but yet , still not able to get the data. how to solve it?

As I seelcted "2015" which are not suppose to be in column_full field, found out that the data in column_h has apostrophe( ' ) symbol.

But when i viewed in excel program, the rows and columns look fine.

why csv delimiter cannot handle special symbol like apostrophe (‘). ????

Jim

[giakoum]

Sorry I have only QV1120 SR12

[jim_chan]

sunny,

which qv version r u using rite now?

Rgds

Jim

[puttemans]

Tried here as well, everything came out just fine. I'm using Version 11.2 SR12

[sunny_talwar]

QV12 SR5

[jim_chan]

i have tested on qv 1120 as well from my colleague. seems like is version issue   .

its working fine on qlikview 1120, but not on version qlikview 12...... i am using qlikview 12!

[jim_chan]

thanks for testing! now i need someone whois using qv 12 to tell me  !

[robert_mika]

Yes 12.10

[jim_chan]

Hello Robert,

which SR r u using.?? i am using qlikview 12 sr5.

[robert_mika]

Change

(txt, codepage is 932, embedded labels, delimiter is ',', msq);

to

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

[jim_chan]

Hello Mika,

i have downgraded to 11.20 sr15. and i have no problem loading ur qvw file and csv file.. all working fine under qv 11.20sr 15.

Can you let me know which qv 12 sr you are using? i am using SR 5, which i faced the issue.