We need to find a way to convert one excel file to txt ( if possible without editing it afterwards) .
The txt file should have fixed fields.
i.e : i f you display the file, all columns should be aligned.
1rst field should be from position 1, length 7 - NUMERIC
2d from position 8, length 30
3d from position 38, length 20
4th from position 58, length 8
5th from position 66, length 4
6th from position 70, length 32
Most of the fields are text ( ex name, address....) except 2 columns.
I tried to save it as "prn" but do not get expected results.- have one extra blank character on the first field.
Does someone have an "easy" solution ?
Thanks in advance
Originally posted by Smitty
Have you tried saving as Text(Tab Delimited) or as CSV(Comma Delimited)?
Yes, I did.
Unfortunately using Text, Tab delimited, the columns are not aligned.
On the other hand the output file can not have any separator into the file, so I can't use CSV.
Using PRN I managed to create aligned columns but have one extra space on the first one .
I have tried to do this as well using Excel and am not getting a fixed record length.
When I create the file and save it as .PRN, it saves all of my columns to the length that I specified except for the last column. My last column is to be 10bytes long, but the .PRN is adding a control record line feed at the end of each line, instead of padding it to 10. It is also adding one extra line at the end of the file.