Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

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

Parse Tool?

JulesFontaine
6 - Meteoroid

Let me start by saying I'm brand new to Alteryx. I have a column of data that is a series of numbers. The last five digits represent a separate piece of data which I want to show in a separate column. I thought the 'text to column' tool would have been perfect, but it requires a delimiter which I cannot provide since there is not a space or any other symbol between the numbers. How do I grab the last five digits and put it in its own column? Thanks in advance for any suggestions.

5 REPLIES 5
Felipe_Ribeir0
15 - Aurora

Hi @JulesFontaine 

 

You can change the datatype of the column to string (if it is not already) use this formula RIGHT([Column], 5). Take a look at the attached workflow.

 

Felipe_Ribeir0_1-1670452496612.png

 

 

binuacs
17 - Castor

@JulesFontaine One way of doing this with the regex replace function

binuacs_0-1670454678934.png

 

JulesFontaine
6 - Meteoroid

Thanks @binuacs! I couldn't get this one to work like it does in the workflow you attached. It gives me a duplicate copy of the data that I am trying to pull the last five characters from - not the last 5 characters - see below.

JulesFontaine_0-1670535208163.png

 

JulesFontaine
6 - Meteoroid

This worked perfectly! Thank you!! I love how there are multiple ways of getting to the answer using this tool.

JulesFontaine
6 - Meteoroid

@Felipe_Ribeir0, that worked perfectly - thank you!!

Labels