3 Replies Latest reply: Apr 17, 2014 9:32 AM by Andreas Warning RSS

    STORE Into txt-file with double quotes

    Andreas Warning

      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