Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qvwarning
Contributor

STORE Into txt-file with double quotes

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.

T17-04-2014-14-41-12.jpg

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

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: STORE Into txt-file with double quotes

Hi Andreas,

use a different delimiter than comma:

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


- Rlf

3 Replies
MVP
MVP

Re: STORE Into txt-file with double quotes

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

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


talk is cheap, supply exceeds demand
qvwarning
Contributor

Re: STORE Into txt-file with double quotes

Hallo Ralf,

QlikView; that simple.

Beste Grüße

Andreas Warning


Community Browser