removing '$' sign while reading source amount column

sridharvis · Post by **sridharvis** » Fri Jul 10, 2009 7:40 am

Hi,

I have a scenario where my source file has a amount column CLAIM_AMT.
The amount column comes as $100.00 in my source file, The source file is a csv file.

I need to multiply the CLAIM_AMT by 20 and load it to the target, so is there any way i can remove $ symbol when i read my source , instead of handling it in a transformer ?

Regards,
Sridhar V

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Jul 10, 2009 7:56 am

You can treat $ as a delimiter and rest as decimal.

Can you provide one sample record.

What happens in case of negative, zero or null values ?

ray.wurlod · Post by **ray.wurlod** » Sat Jul 11, 2009 5:29 pm

Assuming that CLAIM_AMT is a string, and that the "$" you wish to remove is in the first character position:

Code: Select all

Right(InLink.CLAIM_AMT, Len(CLAIM_AMT)-1)