- Posts: 76
- Thank you received: 2
Excel column currency
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
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
Please Log in or Create an account to join the conversation.
2 years 11 months ago - 2 years 11 months ago #20244
by admin
Mike
ETL Architect
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
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.
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.