I have a dataset with a text field that contains long free flowing text values , I need to identify and extract all the 16 digit account number from that text field and create a column from those extracted account number
Data that I have
input acct_num txt_field ;
DATALINES;
3435436 Payment issue reported 3456123789065322 to 0909876789432123 dated 9 mar 2024
7789976 Data declined and assigned to 7890512323454545
Data that I need
acct_num txt_field acct1 acct2
3435436 Payment issue reported 3456123789065322 to 0909876789432123 dated 9 mar 2024 3456123789065322 0909876789432123
7789976 Data declined and assigned to 7890512323454545 7890512323454545
As of now I have used Prxparse and prxmatch functions but those work when you know what exactly to look for in the text field, here I am just looking for any 16 digit values