2 Replies Latest reply: Dec 23, 2014 3:58 AM by Ian Tsang RSS

    Currency issue using local - Â

    Ian Tsang

      Hi

       

      I am bringing in some currency data during a QVD load and noticed an  character appearing in the columns.

       

      Example:

       

      SET ThousandSep

      =',';
      SET DecimalSep
      ='.';
      SET MoneyThousandSep
      =',';
      SET MoneyDecimalSep
      ='.';
      SET MoneyFormat='£#,##0.00;-£#,##0.00';
      SET TimeFormat='hh:mm:ss';
      SET DateFormat='DD/MM/YYYY';
      SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
      SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
      SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

      let vG.BasePath=;
      // Basic search for 1.Init.qvs
      $(Include=..\..\..\..\3.include\1.basevariable\1.init.qvs);
      $(Include=..\..\..\3.include\1.basevariable\1.init.qvs);
      $(Include=..\..\3.include\1.basevariable\1.init.qvs);
      $(Include=..\3.include\1.basevariable\1.init.qvs);
      Exit script when '$(vG.BasePath)'= '';

      // Locale example for UK English
      //$(Include=$(vG.LocalePath)\3.UK.qvs);

      LOAD
      Money(F1) as F1;
      LOAD * INLINE [
      F1
      3.15
      2.50
      3.83
      210.3
      2326.2
      ]
      ;

       

      Results in this:

      F1

      £2.50
      £3.15
      £3.83
      £210.30
      £2326.20

       

      However, if I remove the standard local and uncomment the QDF to include the UK file I get this output instead:

      £2.50
      £3.15
      £3.83
      £210.30
      £2326.20

       

      Anyone have the same issue?

       

      Thanks

       

      Ian