RegEx Replace

[Brad1]

I want to drop the first or last character only if it is '/' or any special character. 

Example:

Tom/Bob

/Bob

/

goes to:

Tom/Bob

Bob

Thanks

[jrgo]

@Brad1 

May not need regex for this. The expression below should work.

TRIM([Field], '/')

Jimmy
Teknion Data Solutions

[OllieClarke · Accepted solution]

REGEX_REPLACE([field1],'^\W?(.*)\W?$','$1')

This will trim any non alpha-numeric's at the beginning or end of your string

[Brad1]

Perfect, thx.