I'm a bit under the gun here doing a system upgrade tonight.
I have a field (FullRecordKey) that contains a series of numbers (including mandatory leading zeros) that I need to parse into columns as follows:
FullRecordKey Leading Account Record ID
000000933500001 000000 9335 00001
000004088200006 00000 40882 00006