topic CSV delimiters in QlikView

CSV delimiters

rafatashiro — Wed, 25 Nov 2020 16:16:04 GMT

Hello Guys

I have a lot os csv files to upload to qlikview but some of then are delimited by comma and other are delimited by semicolon.

They are at the same directory.

How can I deal with this problem to load all of then once?

Thanks in advance.

arvind1494 — Tue, 28 Aug 2018 11:07:00 GMT

For csv use separator ,

and for semicolon use separator ;

arvind1494 — Tue, 28 Aug 2018 11:12:48 GMT

Uder tab Delimiter options for coma,semicolon.tab,space,are available

use which one do you want and then load the files.

rafatashiro — Tue, 28 Aug 2018 11:18:49 GMT

The problem is that in the same directory I have some csv with ';' delimiter and other csv with ',' delimiter.

My doubt is if I can choose both of then to load once in qv.

stigchel — Tue, 28 Aug 2018 12:22:22 GMT

Maybe you can load the first row of each file and determine the separator from that before loading the complete file. Something like

for each vFile in filelist('c:\Test\*.csv')

Header:

First 1

LOAD [@1:n] as Header

FROM

[$(vFile)]

(fix, codepage is 1252);

Let Sep=Left(KeepChar(Peek('Header',0),',;'),1);

LOAD * FROM

[$(vFile)]

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

Drop Table Header;

Next vFile;

rafatashiro — Tue, 28 Aug 2018 13:16:13 GMT

It worked perfectly.

Thanks!!