John,

This doesn’t answer your question, but there are other special cases as well.  
Even if you’re using a carriage return as the end-of-line, you could have it 
inside some of your data, if the text has quotes around it.  Many CSV files are 
like this.  In that case, you need to process character at a time to see if 
you’re inside of quotes or not.  If you are, then the carriage return is just 
more of the data for the field.  If you are not inside quotes, then it acts as 
the record delimiter.  That can cause lines to truncate early if you’re just 
doing:

RECEIVE PACKET($DocRef;$TextValue;Char(13))

Sorry to be a downer, but I’ve run into all sorts of exceptions doing imports.


Randy Kaempen
Intellex Corporation



**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************

Reply via email to