Problem while uploading .prn file

[Former Member]

Hi All,

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.

Thanks,

Sreedevi

[Former Member]

CHECK LAST COLUMN IS THERE IS ANY SPACE

HOW ARE U UPLOADING THE FILE THROUGH PROGRAM AND FROM WHERE ARE U UPLOADING

PLEASE GIVE SOME MORE DETAILS

[Former Member]

I am saving the prn file in UNIX directory and uploading using opendataset.

There is no space at the end of column.