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,
Lower case verification in string
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom