Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm sure this is simple but I cannot manage to get the following data to be formatted correctly nor whether to do this in the script or in the UI itself.
Source data values
0000033320
0000000199
0000123123
Target data value
£333.20
£1.99
£1,231.23
Any ideas?
Many thanks,
Natalie
LOAD
*,
Money(LEFT(FieldName,LEN(FieldName)-2) &'.'& RIGHT(FieldName,2),'£#,##0.00') as FieldNameMoneyFormat Inline
[
FieldName
0000033320
0000000199
0000123123
];
LOAD
*,
Money(LEFT(FieldName,LEN(FieldName)-2) &'.'& RIGHT(FieldName,2),'£#,##0.00') as FieldNameMoneyFormat Inline
[
FieldName
0000033320
0000000199
0000123123
];
Thank you so much for your prompt response. This works perfectly!!!