Well there are several approaches here. 1. Load the file in to a variable and run an <@OMIT STR="<@CHAR 13><@CHAR 10>" and then convert to array. This assumes that the file is not to big.
2. Use the loading capabilities of the database and in invoke the base load from a stored procedure 3. Invoke a process through an external action that calls a bat file which calls a utility that can deal with parsing the data. 4. I have even used the Microsoft Text Driver (*.txt; *.csv) to read text data like a database This is just food for thought Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-witango-talk@;witango.com] On Behalf Of Stefan Gonick Sent: Thursday, October 17, 2002 9:38 AM To: Multiple recipients of list witango-talk Subject: Witango-Talk: CSV File Import Hi All, I have a question, which I have been trying to figure out for a long time. I want to be able to import CSV files where one or more of the fields is a text block. These text blocks can have crlf's in them. I've noticed that programs that can import CSV files handle this with no problem as long as the text block is within double quotes. However, I have no idea how to create this type of parser. It's easy to import CSV records as long as each record is on one line. Does anyone have any ideas? Thanks, Stefan ======================================================== Database WebWorks: Dynamic web sites through database integration http://www.DatabaseWebWorks.com ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
