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
Solved! Go to Solution.
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.