Posted by Bob A on September 19, 2012 at 08:31:16:
Have a file with information about (what else) satellite dishes and programming. It is not exactly .csv because the delimiter is a tilde: "~" ("@7E@")
program worked fine in production (went to completion) with a file of this sort for the month of June.
unbeknownst to me, there is a programming description of the basic Spanish Language programming as básico (with an accented "a" or "@A0@")
I had to modify the file for testing and used a text editor which somehow stripped off the most-significant bit to get "b@sico" since with the MSB stripped off.... the "@A0@" becomes "@40@"
what is very very strange is that the INQUIRE does not fail on the actual record that has the "@" in it, but on the first record (I had to dump the EXCP and it's E2 on the first INQUIRE)
being skeptical... I made a file with 9 records in it
when I changed the 6th record to "basico" all records are processed.
when I changed the 6th record to "b@sico" the INQUIRE fails on the first record
My first suspect was \' and \" since some dishes have sizes enumerated... and also things like "100%"... but the "at sign" seems to be the only thing that causes this type of E2 failure.
I know that the IB compiler uses "@" as an escape delimiter... but is there any special significance to "@" in the INQUIRE of a text file?
Thanx
Bob "A"
P.S. as Sherlock said: "when you have eliminated the impossible, whatever remains, however improbable, must be the truth"
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.