Ya Nell
asked on
Extract Currency data from a string and put them in a new field
I have the following value in a varchar2 field in an Oracle table
row1: 'Amount $0.00 changed to $123,456.78.'
row2: 'Amount $123,456.78 changed to $0.00.'
There will be only two dollar fields for each row.
Row 1 example: I need to extract $0.00 and create a new field 'changed_from' and extract $123,456.78 into a new field 'changed_to'
same thing with row2 also, here changed_from should have $123,456.78 and changed_to should have $0.00
P.S: I don't mind either having or omitting the $ symbol
row1: 'Amount $0.00 changed to $123,456.78.'
row2: 'Amount $123,456.78 changed to $0.00.'
There will be only two dollar fields for each row.
Row 1 example: I need to extract $0.00 and create a new field 'changed_from' and extract $123,456.78 into a new field 'changed_to'
same thing with row2 also, here changed_from should have $123,456.78 and changed_to should have $0.00
P.S: I don't mind either having or omitting the $ symbol
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you want to show the dollar signs, just add $ inside the square brackets. No points please.
ASKER