Remove punctuation from rows without using data cleanse

[wonka1234]

Hi,

I am trying to cleanse the puncatuation on its own from rows.

Ie

Name

louis.stevens@hotmail.com;ren.stevens@hotmail.com

;

;

;;;

;;;

I dont think a cleanse on punctuation works here and my first row has a ";" in it. I want to keep the ":' and other characters where there are actual values.

It is the rows with no meaningful data i would like to clear of punctuation.

[ShankerV]

Hi @wonka1234 

Please find the expected output.

If output needed in the same columns, just rename the column name as below.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[Felipe_Ribeir0 · Accepted solution]

Hi @wonka1234 

If your problem is specific with ;, you can use this formula. It will count characters different than ; and if there is none, then null

if REGEX_CountMatches([Name], '[^\;]') = 0 then null() else [Name] endif