Excel column currency

More
2 years 11 months ago #20243 by ankita
Excel column currency was created by ankita
Hi,
I use advanced ETL processor for excel data integration
My question is, How to identify currency of numbers if its provided along with number, I tried many ways to achieve this but could not find dynamic way
My input file is
My expected output file is

I know that lookup is useful solution for all possible currencies but how to separate currencies symbol from number?
I also attached input and output file
Attachments:

Please Log in or Create an account to join the conversation.

More
2 years 11 months ago - 2 years 11 months ago #20244 by admin
Replied by admin on topic Excel column currency
We have a function called delete characters.
If you delete 01234567890,. what is left would be your currency symbol.
Then you can use a lookup to get the currency name.
I hope it is useful

Mike
ETL Architect
Last edit: 2 years 11 months ago by admin.

Please Log in or Create an account to join the conversation.

More
2 years 11 months ago #20245 by ankita
Replied by ankita on topic Excel column currency
Yes it works perfectly fine Thank you so much

Please Log in or Create an account to join the conversation.