Hello

I want to import a Txt file with the command"
IMPORT TABLE VTempImport FROM "WorkFile.txt"
IN STORE ImportFile DELIMITER CHAR #124

If the txt file include a Quote mark "  
it's cause an error.

How can I avoid it?
Thanks Sorin

Hershcu


Looking at the manual I'm guessing you'd specify [QUOTE CHAR <QuoteChar>]

But then a bit further down it says

If the QUOTE CHAR clause is not included, then the default quote character for character strings is the
double quote '"' character

Just what I'd expect. So I wonder if your text file is not using #34 but is using #147 & #148. Depending on what's produced it you can get the latter which often look the same to the eye depending on font face and size

Roy Lambert

Thanks Roy

I check again.
It's #34

Sorin

Hershcu


In cases like this its almost always the data. What happens if you construct a good file and try and import that. If you get an error what is it.

Roy Lambert

Roy

If it's good file I don't get any error.
On this case the error is: ElevateDB Error #904 Error importing the file....An error occurred with the column Name (The value....would result in truncation))

If I remove the " from file it work ok
Sorin

Hershcu

>If it's good file I don't get any error.
>On this case the error is: ElevateDB Error #904 Error importing the file....An error occurred with the column Name (The value....would result in truncation))

OK, the SQL standard says that if a value is to big to fit in the column then a warning should be issued. With DBISAM string values were truncated, with ElevateDB you get an error. Try increasing the size of the column Name

Roy

Thanks, Roy

I found the solution.
The problem is not the column .size.

All I need was to ignore the double quote with the command:
IMPORT TABLE VTempImport FROM "WorkFile.txt"
IN STORE ImportFile DELIMITER CHAR #124 QUOTE CHAR #0'

Thanks for the support,
Sorin