MoneyFormat

[#1]

Hi,

Please i want to know how to apply MoneyFormat to a field of LOAD statement?

Thanks for your help.

[#2]

I didn't get your question right! Could you please explain briefly! So that we can help you out...

[Miguel_Angel_Baeyens]

Hello Yimen,

Try with

Money(CurrencyField) AS Field

That will return the number value stored in CurrencyField following the format stored in your MoneyFormat at the beginning of your script.

Regards.

[sunil2288]

HI Yiemn,

You can change the format in the edit script main page Which is by default

'SET MoneyFormat='$#,##0.00;($#,##0.00)';' you can change it as you want and can load the data in the format you want.

Regards

Sunil

[sunil2288]

HI Yiemn,

Rather if you want to change the MoneyFormat for a single field you can Use the MoneyFormat( ) Function avaliable in the Foramttin Function Catagory in the edit script.

Regards

Sunil