Txt File Format

[Benazeer]

Hi all,

I am Using Microsoft Excel 2010
I am working on a report containing fields with specific lengths. I have to save the report as a text file (.txt) and I am having the following issue when saving the excel sheet in the format "Text (Tab Delimited)". I had a formula in the field for the specific length and its fine. But when saving the files as text (Tab Delimited), some fields have a tab in between.

Please treat as urgent.

Thanks in Advance

Benazeer

[arlu1201]

Your issue is not very clear. To expedite a response, why dont you attach your file here?

[Benazeer]

Hi arlu1201

Thanks for your response.
Please find in the attachment the Excel file and text file.

[arlu1201]

Maybe before saving the excel file, you can have a small macro to delete those extra columns that are getting created.
If the columns are not always in the same place, you can have the code look for them and then delete.

[Benazeer]

Hi

Thanks for the reply.

But the blanks column that you see in the file (Previous mail - MNS Testing.xls) are for the addresses field. Anyway, can you help me with the macros to find and delete the columns that are causing this tab in the notepad.


Benazeer

[shaukat]

hi Benazeer

record a macro delete the address columns, these coulmns are creating tabs. save the file as text. then insert the number of lines again which you deleted. stop the macro.
hope it helps
shaukat

[Benazeer]

hi Shaukat

Thanks for the reply.
I tried what you told me but still the problems remain. I do not know what is causing the since as you can notice (MNS.txt), some of the fields are in the correct order but some are not.

Awaiting a reply form you.
Benazeer

[shaukat]

hi , sorry I did not see the post. if you want any body to be notified about your post, then reply as qoute.please run the macro in your file it will create test file you desire

Please Login or Register  to view this content.