topic Re: STORE Into txt-file with double quotes in QlikView

STORE Into txt-file with double quotes

qvwarning — Thu, 17 Apr 2014 13:10:51 GMT

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

Re: STORE Into txt-file with double quotes

rbecher — Thu, 17 Apr 2014 13:22:39 GMT

Hi Andreas,

use a different delimiter than comma:

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

- Rlf

Re: STORE Into txt-file with double quotes

Gysbert_Wassenaar — Thu, 17 Apr 2014 13:24:51 GMT

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 ';' );

Re: STORE Into txt-file with double quotes

qvwarning — Thu, 17 Apr 2014 13:31:57 GMT

Hallo Ralf,

QlikView; that simple.

Beste Grüße

Andreas Warning