Hi,
Can someone help me how to split the column based on the position.
Example: column consists of below data and I want to extract only 5 digits from right hand side of the column.
i.e 12387 in below example
ABCD - 12387
Hi @Naresh
You can use the function Right([string], 5) to retrieve the right 5 characters of the string.
https://help.alteryx.com/designer-cloud/string-functions
Cheers,
TheOC
Hi @Naresh
Here is how you can do it. Method 2 will only work if the number length is always 5 and at the last. Method 1 will work for any length of numbers at the end.
Workflow:
Hope this helps : )
Hi @Naresh ,
One more method 😊.
substring([Field1],FindString([Field1], '-')+1,Length([Field1]))
Thanks.