This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.