Inserting Leading Zeros into a CSV file using Regular Expres
Posted: Mon Jan 31, 2005 5:32 pm
Hi all,
I love this program as it has been very helpful with my work.
Can anyone share with me on how to use AFR to do the following:
Original file:
"2002",20041206,36,1,"2","03111684254", 30,"99"," ","8010","9058"," "
"2002",20041206,37,1,"2","531780103P0", 24,"99"," ","8010","9058"," "
I need to replace the bolded regions, which is a counter with a counter that has leading zeros. This field should have 6 numbers altogether. Which means that my result file should be:
"2002",20041206,000036,1,"2","03111684254", 30,"99"," ","8010","9058"," "
"2002",20041206,000037,1,"2","531780103P0", 24,"99"," ","8010","9058"," "
Thanks and I appreciate any help here.
I love this program as it has been very helpful with my work.
Can anyone share with me on how to use AFR to do the following:
Original file:
"2002",20041206,36,1,"2","03111684254", 30,"99"," ","8010","9058"," "
"2002",20041206,37,1,"2","531780103P0", 24,"99"," ","8010","9058"," "
I need to replace the bolded regions, which is a counter with a counter that has leading zeros. This field should have 6 numbers altogether. Which means that my result file should be:
"2002",20041206,000036,1,"2","03111684254", 30,"99"," ","8010","9058"," "
"2002",20041206,000037,1,"2","531780103P0", 24,"99"," ","8010","9058"," "
Thanks and I appreciate any help here.