Re: String Parsing?

Posted in 2006

Art S. Kagel — Mon, 22 May 2006 18:46:32 -0400 — source: Usenet: comp.databases.informix

donkibbey@gmail.com wrote: > I've recently been given an assignment to create a set of routines that > will be used to import csv and other text files (some nicely formated, > others a hideous mess). I'm experienced with UniVerse (Pick) and C#. > This project is running within an Informix 4gl environment though so > I'm a stranger in a strange land. > > I've looked all through several online documentation sources for > Informix 4gl and I can't find anything other than references to > external c functions and the substring [] operator. Are these the only > choices for string manipulation within Informix? Is the SOP within the > Informix community to write a C function to perform chores like this? > > Thanks for your help. > Take a look at the sqlcmd package by Jonathan Leffler. It includes a load utility, sqlreload, which understands csv files (sqlreload -F csv ....). Art S. Kagel