DSXchange

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,

UpCase is your lead.

Yes sainath,

I have acheived this by following logic:

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


Thanks,