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.

[Garabujo7]

Hello @noded ,

You could use a find&replace.

[MatthewBr]

Best way is to use a formula tool (beginning) or you can use a regex (intermediate)

For example:

[MatthewBr]

If this solves your challenge - Please mark this is complete/solved.

[atcodedog05]

Hi @noded 

Here is my take on it.

Workflow:

Hope this helps : )

[noded]

Hi, also I want to ask, maybe you know how to delete all data like in this this, but everything what i want to delete is in square brackets? 

[atcodedog05]

Hi @noded 

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

[mst3k]

**deleted reply

i interpreted the question backwards! the other replies look correct

[noded]

id	content
1	[some text] this is okay [another text]
2	[some variables] another okay text [another variable]

But in this case I have a lot of different texts/variables in square brackets, and I have something about 11k records, different texts in square brackets and angle brackets. And I'm looking for how I can clean all this brackets from content.

[atcodedog05]

Hi @noded 

Here is how you can do it.

Workflow:

Hope this helps : )