Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Andreas,
use a different delimiter than comma:
Store DTA2 Into Table2.txt (txt, delimiter is ';');
- Rlf
Hi Andreas,
use a different delimiter than comma:
Store DTA2 Into Table2.txt (txt, delimiter is ';');
- Rlf
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 ';' );
Hallo Ralf,
QlikView; that simple.
Beste Grüße
Andreas Warning