Help removing text after specific character and replacing - ALTERYX DESIGNER HELP

[emiafshar]

Hey guys,

I need a way to remove the below text after the _id= and replace it with a ]

The number of characters is not always the same and the text before is also not the same i.e. in some instances you have counterparty_id, or security_id etc. 

I need the text at the end of the field to go from [p_counterparty_id=58M] to [p_counterparty_id] and [p_loan_security_id=P93960AG0] to [p_loan_security_id] etc etc.

Any ideas?! 🙂

[Emil_Kos]

Hi @emiafshar,

I have created a soution for you:

Output:

The old column can be removed I just used it for tests.

[emiafshar]

Thanks Emil, what if I wanted to keep the _ID? So the output would be [p_counterparty_id]

[Emil_Kos]

Hi @emiafshar,

Dang.

Please see corrected version 🙂

[emiafshar]

That workflow seems to be the same as the previous one! 😁

[afv2688]

Hello @emiafshar ,

You can easily achieve this by using regex.

If you need any clarification about the process let me know.

Regards

[Emil_Kos · Accepted solution]

Hi,

The screen was incorrect the workflow was good 😄

[emiafshar]

Thank you so much!