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

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

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 ,

"JOHN SMITH to JOHN SMITH

JOHN SMITH" to JOHN SMITH

JOHN SMITH, to JOHN SMITH

I want to eliminate punctuation.

Thanks

Custom Tools

You can use data cleanse tool and remove puctuations

Workflow:

Hope this helps : )

You can use data cleanse tool and remove puctuations

Workflow:

Hope this helps : )

@wonka1234 another option to use the Trim function

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.