RegEx Replace

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

Regex

Expression

Accepted answers

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

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

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

TRIM([Field], '/')

Jimmy
Teknion Data Solutions

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

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

Perfect, thx.