Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

RegEx Replace

Brad1
11 - Bolide

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

3 REPLIES 3
jrgo
14 - Magnetar

@Brad1 

 

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

TRIM([Field], '/')

Jimmy
Teknion Data Solutions

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

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

clipboard_image_0.png

Brad1
11 - Bolide

Perfect, thx.

Labels