Splitting the column in to two parts

Question

Hi Team,

Hope you are well. I need a help.

acc_key

190007307030002021
190007307130002021
190007307230002021
190007307330002021
190007307430002021
190007307530002021
51058616212019
51058616222019
51058616232019
51058616242019

I would like to create two new columns and split the above column into two by extracting the last 4 digits

For e.g

Acct

1900073070

5105861621

year

2021

2019

Please let me know your thoughts,

thanks,

Sri

rkapoor · Accepted Answer

@sriniprad08 have a look at the attached. I used the Right function in the formula tool to take the year from the end.

You can use the substring function to get the Acct.

Have a look at this link on string functions in Alteryx:

https://help.alteryx.com/20212/designer/string-functions#:~:text=A%20string%20function%20performs%20operations,used%20with%20String%20data%20types.

atcodedog05 · Accepted Answer

Hi @sriniprad08

Here is a Regex method.

(.+)(\d{4})

Last 4 in the second column and rest in first column.

Workflow:

Hope this helps : )