S
ske
Guest
dbeavon said: > ... I don't particularly like the IMPORT format since it is not binary and > doesn't seem standardized (any more than a csv). I'm not eager to see what > happens when my ODBC results have my delimiters within the data itself (or > it may even have line breaks). I find the IMPORT/EXPORT format quite easy to work with. Line breaks within fields are ok, provided that the field is quoted. Put quotes around string fields that may contain the field delimiter character, line breaks or other special characters. Just make sure that if a field contains the quote character as data, double that character ("" for "). Use ? for the unknown value. Use YES or NO for logical fields. Any date fields of course need to be formatted the Progress way, and are susceptible to the Progress session's current date format options. Non-Progress data types may need some kind of conversion, of course. Or use IMPORT UNFORMATTED if you just want to read each line as a single string, with no delimiters. I guess you could choose to read a binary file too, but then you will have to use other commands than IMPORT, and split it up into fields and records yourself, which will probably be slower.
Continue reading...
Continue reading...