Thread: 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

Hai,

the input file should be in text and also the output also in text format only.

I will attach the file for your reference.

I need to know , if there is any macro available for this issue to solve.

Kindly let me know you can help me in this....

I think that a quick search and replace from Excel or Word would do the trick. If you search for " 7/" and replace it with " 07/" it might work. (Note - the space in front of both things in quote.

If there is any macro we can use it in word for this process.