Alteryx Designer Desktop Discussions

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

Trimming question

bvolles
8 - Asteroid

This is a total newb question but for the life of me am unable to get it to work.  I have a string field that looks like 1020002R I need to remove the 4th and 5th number.  I would appreciate any help.

2 REPLIES 2
binuacs
20 - Arcturus

@bvolles One way of doing this with the substring function

 

https://help.alteryx.com/20221/designer/string-functions

 

binuacs_0-1664395383834.png

 

binuacs_1-1664395437225.png

 

bvolles
8 - Asteroid

that worked perfect!  Thank you

Labels