Alteryx Designer Desktop Discussions

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

Formula tool- remove last four (4) characters from a string

Elena_B1
7 - Meteor

Hello.

 

I have a string 500147666122221. I need to create a new column and remove last four digits.

Appreciate your help.

 

4 REPLIES 4
dYoast
11 - Bolide

Left([YourString], Length[YourString])-4)

Elena_B1
7 - Meteor

I've got the error 

Elena_B1_0-1664915594098.png

 

Elena_B1
7 - Meteor

I was able to correct it Left([Reference],Length([Reference])-4)

 

Elena_B1
7 - Meteor

Thank you for the help

Labels