Cleansing data

[Simon88]

Hi there, 

I am trying to clean data and filter data that contains one word "W". Please have a look at sample data. Please help me with that. 

Thanks, Simon 

[ShankerV · Accepted solution]

Hi @Simon88 

One way of doing this.

Output in the T node:

Output in the F node:

Input was:

Logic applied:

REGEX_Match([Words], ".+\sW\s.+")

Many thanks

Shanker V

[Simon88 · Accepted solution]

Thanks and if I wanted to split the text before "W" and after "W". How can i do that. Can you please help me with that? 

[ShankerV · Accepted solution]

Hi @Simon88 

One way of doing the above request, 

(.+)\sW\s(.+)

Many thanks

Shanker V