Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

String to Number Conversion

Status
Not open for further replies.

sa0309

Programmer
Apr 5, 2010
45
US
I have a csv file that contains a source_field formatted as follows:

source_field string(19)

$193,249.54
$ 37,945.35

Note: $ is always in pos1

Target_Field NUMBER(12,2)

I need an expression to remove the $ and comma from the source_field so it will load as follows to the Target_Field
193249.54
37945.35

Any assistance would be appreicated.

Thank you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top