Problem while uploading .prn file
I am saving one excel file with fixed length,
1st column - 16 characters
2nd column - 8 characers
3rd column - 2 characters
4th column - 60 characters. and saving as .prn file.
G1205-00490 10/09/07 OBS PER ECO 43-1010001 EOS OF G1205A
While uploading this the last 4th column is taking '#' value at the end.
When I am exactly counting in saved prn file the last column as 60 then it is saving exactly what ever we are passing.
I think the problem while saving excel file into .prn the last column is not having exactly 60 eventhough I made it as column width 60, in the excel sheet.
For 1 or 2 records counting manually is no problem. But if I am having hundreds of records for uploading, so it is difficult to do.
Please advice on this.