I've had a look around the forum and not found anyone with a similar problem.
I'm using input# to import a text file and make each line into anotes document. I declare my own record type and for each line in the file I read its values into an array that uses my defined record type. This all works fine unless the last value of each record is surrounded in double quotes. For example:
First Name 1, Surname 1, House Number 1
First Name 2, Surname 2, House Number 2
First Name 1, Surname 1, "House Number 1"
First Name 2, Surname 2, "House Number 2"
The problem is that if double quotes are used then the newline character is being read. What this means is that I end up with a blank value for a field value and record by record it all goes pear shaped.
It would nice if the file did not use double quotes but I have no control over that. I'm actually getting all the values surrounded in quotes so I need to deal with it.
Has anyone got any ideas what I might be doing wrong?