Parse the text into different columns

[sriniprad08]

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

[ShankerV · Accepted solution]

Hi @sriniprad08 

One way of doing this.

Many thanks

Shanker V

[binuacs · Accepted solution]

@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)

[sriniprad08]

 Hi @binuacs ,

Thank you so much. Really appreciate this. Very helpful.

Cheers,

Sri