Removing junk from columns

[noded]

Hi, Im newbie in Alteryx. I don't have any idea how to clean rows, from databaes exported from wordpress (csv file).

Example.

id	content
1	vc_rowvc_columSome text, which I don't want to delete. vc_column_text
2	vc_column_textvc_rovc_colum another one text. vc_rowvc_colum

I have 11k records to clean. I looking for solving this problem.

[noded]

I'm looking for method that I can delete everything in square and angle brackets. Cuz in content they're a different variables in brackets.

[atcodedog05]

Hi @noded 

Try this

Hope this helps : )

[noded]

That havent work for me 😕

[atcodedog05]

Hi @noded 

Can you scroll right and show me the extract column.

[noded]

But also i want to delete this angle brackets. This works but not for every square brackets.

[atcodedog05 · Accepted solution]

Hi @noded 

Try this.

Hope this helps : )

[noded]

Big beer for you mate, thank you soo much! 

[atcodedog05]

Happy to help : ) @noded 

Cheers and have a nice day!