Remove all text but set phrase?

Kim · July 14, 2022, 4:20pm

Hi, in a column can I remove all text but set phrases?

Example: the cell in that column says The dog barked at the cat. I want it all removed but “the cat”. I can’t do a replace because all the cells have different text. I only need a few phrase let in the columns.

Thanks
Kim

Anonymous · July 14, 2022, 7:08pm

Hi,

You can use Extract transform and use regex

Admin · July 14, 2022, 8:38pm

Alternatively you could use an If transform.

Kim · July 15, 2022, 4:05pm

This would great. Now is there any codes I can get to make it keep the date that follows? The dates that I need after contract signed could be any date. In this case it’s 3/5/2018 but in another case it could be 6/15/2020. Thanks

Kim · July 15, 2022, 4:12pm

Actually this better because I can pull several phrases into different columns however the same issue is how to get the date.

Thank you

Admin · July 15, 2022, 5:48pm

I don’t see any dates in your example.

You should be able to use a regex to keep the date.

Kim · July 15, 2022, 6:11pm

Hi, I made an example sheet. I have the first column as how it is now and the second as how it should be. Thank you

Example.csv (437 Bytes)

Anonymous · July 15, 2022, 9:03pm

Hi,

Try this in your regex expression, to get the desire result

(Contact [SE].*[/-][0-9]{4})