Data Cleaning

[Hiteshp]

Hello Team,

I need to remove a specific line from a cell. The line is repetitive in a column in all the the cells.   

In the attached example. "With Alteryx, unraveling data's potential becomes a streamlined adventure of discovery and transformation." is a common line in the cells and needs to be taken off.

[ShankerV]

Hi @Hiteshp 

As per the example shared, it is observed that you have 2 lines of data in one cell.

The above is repeated in the entire column.

Could you please use Text to Columns tool and use the delimiter as \n and number of columns 2.

Many thanks

Shanker V

[ShankerV]

Hi @Hiteshp 

By using the above method you will get 2 columns of output where 2nd column should be ignored as it will contain the repeated sentence.

Another way of doing it:

Using Formula tool.

Column name : Output 

Use the below formula, 

REGEX_Replace([Field1], "(.+)\n(.+)", "$1")

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Hiteshp 

Another way of doing it with the help of Regex tool.

Column to Parse: 

Data

Regular Expression:

(.+)\n(.+)

Output Method: Replace

Replacement Text: $1

By using this method, this will replace the existing column data itself.

Many thanks

Shanker V