Parse the text into different columns

Question

Hi Team,

hope you are well.

I need help. I have a column with different values. I need to separate them like Currency  and the amount

Please let me know how to go about this,

Thanks

Sri

to_ask_alteryx.xlsx

ShankerV · Accepted Answer

Hi @sriniprad08

One way of doing this.

Many thanks

Shanker V

binu_acs · Accepted Answer

@sriniprad08 Another approach, also I belive if both USD and EUR are on the same string, that should also get parsed into different columns (eg: 10)