Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi every one
i have filed which contains of many codes and codes are stating with an alphabet
and each alphabet represents category
for example if my code is : A1234 it means it bongs to "APPLE" category
so now as bellow i want to rename all of the cods as bellow:
OLD_CODE | NEW_CODE |
A1234 | Apple |
A1235 | Apple |
A1236 | Apple |
A1237 | Apple |
A1238 | Apple |
A1239 | Apple |
A**** | Apple |
B1234 | BIG |
B1235 | BIG |
B1236 | BIG |
B**** | BIG |
C1234 | Cat |
C1235 | Cat |
C1236 | Cat |
C1237 | Cat |
C**** | Cat |
D**** | Doll |
E**** | Egg |
can some one please help me to reach to the "NEW_CODE" ?:
May be like:
Pick(Match( Left(OLD_CODE, 1), 'A', 'B', 'C', 'D', 'E'), 'Apple', 'Big', 'Cat', 'Dog', 'Egg') as NEW_CODE
And if you have many such codes, you may try with Applymap() / MapSubString()
May be like:
Pick(Match( Left(OLD_CODE, 1), 'A', 'B', 'C', 'D', 'E'), 'Apple', 'Big', 'Cat', 'Dog', 'Egg') as NEW_CODE
And if you have many such codes, you may try with Applymap() / MapSubString()
Thanks it works