STORE Into txt-file with double quotes

[qvwarning]

Hi,

I'm trying to get an export job with STORE Into *.txt (tx) without double quotes.

[DTA1]: // F1

Load

Replace(Text([costvalue]), ',' , '.' )& ' þ'  as [F1]

From ....;

Store DTA1 Into Table1.txt (txt);

The export-table 'Table1' are without double quotes.

If i try to export the numeric 'costvalue'

[DTA2]: // F2

Load

Num([costvalue]),'#0,00' )& ' þ'  as [F2]

From ....;

Store DTA2 Into Table2.txt (txt);

The export-table 'Table2' are with double quotes.

How can I can get a txt-file without double quotes, using numeric 'costvalue'.

Any format specifications does't work.

I need the field 'costvalue' in the txt-file with a comma.

Regards

Andreas

[rbecher · Accepted solution]

Hi Andreas,

use a different delimiter than comma:

Store DTA2 Into Table2.txt (txt, delimiter is ';');

- Rlf

[Gysbert_Wassenaar]

Specify another delimiter. If your field values contain a comma and you use a comma as field separator then the field values must be enclosed in quotes.

Store DTA2 Into Table2.txt (txt, delimiter is ';' );

[qvwarning]

Hallo Ralf,

QlikView; that simple.

Beste Grüße

Andreas Warning