TRIM string , begins with " OR ends with " OR ends with ,

[wonka1234]

Hi all, do you know how to make a formula that trims a string in this way: TRIM string , begins with " OR ends with " OR ends with ,

ie

"JOHN SMITH to JOHN SMITH

JOHN SMITH" to JOHN SMITH

JOHN SMITH, to JOHN SMITH

I want to eliminate punctuation.

Thanks

[atcodedog05 · Accepted solution]

Hi @wonka1234 

You can use data cleanse tool and remove puctuations

Workflow:

Hope this helps : )

[binu_acs]

@wonka1234  another option to use the Trim function

[atcodedog05]

Hi @binu_acs 

That makes sense the string value is not 

"JOHN SMITH to JOHN SMITH

JOHN SMITH" to JOHN SMITH

JOHN SMITH, to JOHN SMITH

by itself 😅 its a sentence.

[atcodedog05]

Happy to help : ) @wonka1234 

Cheers and have a nice day!