DosTips.com

Thanks for all your help. Now I just have to figure out how to code a batch file to rearrange the columns in my comma delimited file for my import. Any suggestions?

Thanks for your reply!! First Task - Here's what I have: 6,0112530,05022012,,GIFT SHOP,0.05 I need to get the "system time" to populate 4th column. Is this possible? Second Task - In the second column, I have id numbers that start and end with zeros. I need to remove first and last zero/ch...

this worked for me too.
But also wondering how can an existing empty column be populated with data?
or how do I add data to column 4?
I also need to strip the beginning and ending zeros from a field. example: 0123450, it's always 7 char long with zero at beginning and end.