How to load text as money/currency

[gshockxcc]

I've looked at a number of other posts regarding the same subject, and I can't see to get anything to work.

I need to convert the text in 'Value' field to US dollars ($).

Raw data is in .CSV file format.

[manojkulkarni]

I didn't got your question.

If you want to convert the existing value to US dollar, then would require conversion factor.

[rwunderlich]

Your field has a trailing non-printable char (160). Use the following in your LOAD to clean the field and make it a proper number.

LOAD KeepChar(Value,'.01234567890') as Value

If you want to preassign the $ format to it, just add num().

LOAD num(KeepChar(Value,'.01234567890'),'$#,##0.00') as Value

-Rob

http://masterssummit.com

http://robwunderlich.com