Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Ian, and thanks for the info. Had a look at the problem. Seems that 3.UK.qvs was using a bad encoding, (UTF-8 without bom) changed to pure UTF-8 and it seems to work fine for me now. Replace with attached and try, this will be updated in next minor QDF release.
Regards Magnus
Hi Ian, and thanks for the info. Had a look at the problem. Seems that 3.UK.qvs was using a bad encoding, (UTF-8 without bom) changed to pure UTF-8 and it seems to work fine for me now. Replace with attached and try, this will be updated in next minor QDF release.
Regards Magnus
Thanks for the quick response Magnus, copied to all containers manually and worked a treat.