Alteryx Designer Desktop Discussions

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

To extract last five letters from a string

dizy_11
7 - Meteor

Hi can anyone please tell how to extract last 5 letters from a string (not in the reverse order).

 

Thanks in advance.

2 REPLIES 2
apathetichell
18 - Pollux

non-regex way is to use a formula tool - new column

right([yourfieldname],5)

dizy_11
7 - Meteor

Thanks alot.

Labels