I have a csv file that gets loaded into a database, but because someone entered a carriage return in the last text field it screws up the import.
I have tried to strip the carriage return of the last field $field[8] =~ s/\015//g; but that does not do the job. It occurred to me that every line should end in a carriage return. By looking at the file in excel, the it appears correct. However, when I select the field in question I still see a rectangle in the middle of the text. I am doing this in an Windows 2000 environment with Access as the database frontend. I did not write the database, but I've had to come up with several scripts to handle the file input (since these files come from many individuals and it is next to impossible to impose restrictions on them). Does anyone have a suggestion on how to handle this? mgolini -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
