Data Access Worldwide Knowledge Base
Article ID 2179 Article Title HOWTO: Use READ when the delimiters need to be variable Article URL http://www.dataaccess.com/kbasepublic/KBPrint.asp?ArticleID=2179 KBase Category DATAFLEX (GENERAL) Date Created 10/14/2005 Last Edit Date 11/25/2008
Article Text
PROBLEM:
It can happen that you receive a CSV file that has a different field separator than the comma that DataFlex expects or has a different character set around - usually ASCII - data than the double quote or has a different record separator than the CR/LF. In such cases you need a diffent parser for the files.
The enclosed sample source code has a nice function that shows you how to parse a file with different delimiters.
Contributed By:
Igor van Houttum
Company: Data Access Europe
email: igor.van.houttum@dataaccess.eu
Web Site: http://www.dataaccess.eu
Web Links Related to this Article
File Csv_Ex.Src
URL=http://www.dataaccess.com/KBasePublic/Files/2179.Csv_Ex.Src
Howto: UNIX or Linux convert DOS newlines CR-LF to Unix/Linux format
URL=http://www.cyberciti.biz/faq/howto-unix-linux-convert-dos-newlines-cr-lf-unix-text-format/
Email this Article
Email this Article to a Colleague
Send Feedback on this Article to Data Access Worldwide
Copyright ©2010 Data Access Corporation. All rights reserved.
The information provided in the Data Access Technical Knowledge Base is provided "as is" without warranty of any kind. Data Access Corporation disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. In no event shall Data Access Corporation or its suppliers be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if Data Access Corporation or its suppliers have been advised of the possibility of such damages. Some states do not allow the exclusion or limitation of liability for consequential or incidental damages so the foregoing limitation may not apply.