Conversion of text files without change in the original file

Hi,

I need to add a leading zero before month in a text file, but the spacing should same as before after adding the zero also.

I tries using to open with excel and changed the format but after i did the test to columns the spacing of the old format is changed.

Ex:

BUARDC 04294008295 010321 6000 7/17/2010 0000354652 000224

This is the sample data, in this i need to add zero before that "7". but the format should be same like the spacing between the letters and all the numbers also.

Can anyone help me on this i can solve this issue.

Thanks in advance

Vinoth

this not clear! where is your original data. text file or excel? where do you want to put the corrected data when done?

just do it in note pad you'd have to repeat for 1,2,3,4,5,6,7,8,9
find " 7/" replace " 07/" note the leading space in both cases

i doubt if excel could do it as when imported it removes unnecessary spaces
notepad definitely no
but ms word vba might do it.

no idea you'd need an ms word vba code guru!

not going to happen! if you insert something everything moves to the right that how text editors work.
having said that this open source text editor is brilliant it allows column editing (read the help files) so you could Delete the excess spaces in one go
http://notepad-plus-plus.org/release/5.7

works fine for me try the home page
http://notepad-plus-plus.org/home

sorry mate but you seem to be a little lost! yes it is software its an open source advanced text editor.

tough! then go through them manually!