Store CSV file using semicolon instead of colon

[#1]

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

[#2 · Accepted solution]

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

[#3]

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

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

Regards,

Gordon

[#4]

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.

[#5]

Thanx!

Once again, easier than I thought

G

[richnorris]

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?

[rwunderlich]

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

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

-Rob