Hi, Im newbie in Alteryx. I don't have any idea how to clean rows, from databaes exported from wordpress (csv file). Example. idcontent1vc_rowvc_columSome text, which I don't want to delete. vc_column_text2vc_column_textvc_rovc_colum another one text. vc_rowvc_colum I have 11k records to clean. I looking for solving this problem.

Removing junk from columns

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.

Preparation

Try this.

Hope this helps : )

Hello @noded ,

You could use a find&replace.

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

For example:

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

Here is my take on it.

Workflow:

Hope this helps : )

**deleted reply

i interpreted the question backwards! the other replies look correct