Regex Replacement

After parsing and storing components of the dataset into tab-separated values (TSV) files, I proceeded to reorganize these files into a compatible format with Filemaker Pro. By compatibility, I refer not to FileMaker Pro's ability to import or export different file extensions, but rather to its limitation in the following sense: FileMaker Pro doesn't allow a list structure of elements under a single column.

This was an issue for my dataset because in the Garrison Records, there were lists of comma-separated values under certain attributes. Thus, I had to use a Regex replacement to take each of the elements in a single list and create new rows that correspond to the rest of the attributes in the same row. This process was implemented through a three-step Regex replacement in Sublime.

The first step was to replace all the commas with \n.

Sample Text: 
1,col1,col2
2,col1,col2,col3
3,col1
 
Search: , 
Replace: \n

Result:
1
col1
col2
2
col1
col2
col3
3
col1

The second step was then to use the following Regex replacement, whose function was to capture the ID only, and add a comma as well as creating a new line.

Search: (^[0-9]+)\n
Replace: $1,

Result:
1,col1
col2
2,col1
col2
col3
3,col1

Lastly, take all instances of the following format "<number>,<text>", followed by rows of just elements "<text>", then add the most recently visited "<number> in front of the rows of just <text>.

Search: (^[0-9]+,)(.*\n)([^0-9].*\n)
Replace (multiple times): $1$2$1$3
 
Result:
1,col1
1,col2
2,col1
2,col2
2,col3
3,col1