Thank you for your suggestions. I like the Dictionary solution, as this will continue to happen in the future & others might not remember to adjust the CSV file. I'm getting stuck on the iterations...any help would be appreciated!
The first one I entered works; I changed ^\d{4}(-\d{4})?$ to ^\d{3}(-\d{3})?$ because that’s the number of digits without the leading zeros (total of 8 digits). But when I apply the same principles to the 2nd one, it goes haywire? I only need one zero added to 7 existing digits (for a total of 8 digits). What am I doing wrong? Please see attached screenshot.
Thanks for your reply, Allison! Unfortunately, it didn't work...see attached for a screenshot of what I got.
0$& | ^\d{7}$ | TRUE |
00$& | ^\d{6}$ | TRUE |
000$& | ^\d{5}$ | TRUE |
0000$& | ^\d{4}$ | TRUE |
00000$& | ^\d{3}$ | TRUE |
000000$& | ^\d{2}$ | TRUE |
0000000$& | ^\d{1}$ | TRUE |
Tracie Cassidy
I have a few old RE records that have leading zeros in the donor ID. They are throwing excpetions when I try to import. Is there a way for me to retain the leading zeros on my data sheet so they will import in IOM?