Lower case verification in string

snt_ds · Post by **snt_ds** » Thu Apr 30, 2009 3:35 am

Hello All,

My input data coming like:

AA BB
USD 100
USd 101.23
GBP 200
GBp 203.45

Target column is:

CC

The requirement is, If the last charecter in AA column is lower case(EX: 'd' or 'p') then I need to divide the column(BB) with 100 and load into target column i.e. CC

Could you please let me know how to to acheive this.

Thanks,

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Apr 30, 2009 3:59 am

UpCase is your lead.

snt_ds · Post by **snt_ds** » Thu Apr 30, 2009 4:15 am

Yes sainath,

I have acheived this by following logic:

If Right(AA,1) = UpCase(Right(AA,1)) then CC else CC /100

Thanks,