Hi Team,
Hope you are well. I need help.
I have field and i need to split into two and create a new variable with the splitted column.
Please find attached
Acc_key
190007307030002021
190007307130002021
190007307230002021
190007307330002021
190007307430002021
190007307530002021
51058616212019
51058616222019
51058616232019
51058616242019
Output (creating two separate columns and extract the last four digits and place it another column)
Acct
19000730703000
19000730713000
19000730723000
19000730733000
19000730743000
19000730753000
5105861621
5105861622
5105861623
5105861624
Year
2021
2021
2021
2021
2021
2021
2019
2019
2019
2019
The challenge is that the original column has varying length.
Can you please help?
Thanks
Sri
