How to split the column

[Naresh]

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

[TheOC]

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

[atcodedog05]

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 : )

[binuacs]

@Naresh 

REGEX_Replace([Field1], '.+\-\s(.+)', '$1')

[saveeshkumar]

Hi @Naresh ,

One more method 😊.

substring([Field1],FindString([Field1], '-')+1,Length([Field1]))

Thanks.