Alteryx Designer Discussions

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

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

Elena_B1
6 - Meteoroid

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
10 - Fireball

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

Elena_B1
6 - Meteoroid

I've got the error 

Elena_B1_0-1664915594098.png

 

Elena_B1
6 - Meteoroid

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

 

Elena_B1
6 - Meteoroid

Thank you for the help

Labels