topic Store CSV file using semicolon instead of colon in QlikView

Store CSV file using semicolon instead of colon

Thu, 09 Dec 2010 14:22:50 GMT

Hi,

I'm trying to store a file as csv file but instead of have a colon as separator, I need a semicolon.

Now I use:

STORE ExportFile into ExportFile.txt (txt);

and I can't find any way to add formatting options there.

Is this a case of US vs EUR settings in windows or can QV do it?

Thanx!

Gjalt

Store CSV file using semicolon instead of colon

Thu, 09 Dec 2010 15:10:53 GMT

Hi Gjalt,

here are on example to provide a delimiter of your choise.

Store Amounts into Amounts.txt (ansi, txt, delimiter is ';');

For the syntax see QV HELP and look at the LOAD function.

Good luck!

Rainer

Store CSV file using semicolon instead of colon

Thu, 09 Dec 2010 15:11:05 GMT

You could use a macro (OnPostReload) and use the API:

set doc=ActiveDocument
set obj = doc.GetSheetObject("CRM")
obj.Export "Cust2010.csv", ";"

Regards,

Gordon

Store CSV file using semicolon instead of colon

Thu, 09 Dec 2010 15:12:07 GMT

Try this script instead:

STORE ExportFile into ExportFile.txt (txt, delimiter is ':' );

STORE ExportFile into ExportFile.txt (txt, delimiter is ';' );

delimiter is 'x' x can be any ascii charachter.

Its similar to the syntax for LOAD.

Store CSV file using semicolon instead of colon

Thu, 09 Dec 2010 15:20:05 GMT

Thanx!

Once again, easier than I thought

Store CSV file using semicolon instead of colon

richnorris — Wed, 19 Jan 2011 12:17:39 GMT

Hey, is this possible in QV 8.5? Only with the above I am getting a text file with a large xml header and various unspecified characters as the delimiters?

Store CSV file using semicolon instead of colon

rwunderlich — Wed, 19 Jan 2011 20:40:46 GMT


RichNorris wrote:Hey, is this possible in QV 8.5?

No. The txt option of STORE became available in V9.

-Rob