You could also look into using AWK/GAWK for text file parsing. I have used it with some gigantic text files to convert them into a format that can be used with Oracle SQL Loader. Pretty effecient and neat tool.
HTH On 2/10/06, Bobby Hartsfield <[EMAIL PROTECTED]> wrote: > > Or you could pull it straight into a query structure with a 'csv to query' > custom tag. There are a few out there. There are probably some for reading > a > tab delimited text file into a query structure too. > > ..:.:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > > > > > > > -----Original Message----- > From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] > Sent: Friday, February 10, 2006 7:26 AM > To: CF-Talk > Subject: RE: parsing a list > > I think if you save your text file with the tabbed data as a .csv and then > load it into Exel you'll be able to export the data in all sorts of db > formats. > > Jenny > > >>-----Original Message----- > >>From: dave [mailto:[EMAIL PROTECTED] > >>Sent: 10 February 2006 06:41 > >>To: CF-Talk > >>Subject: parsing a list > >> > >> > >>I'm having trouble parsing a list. > >>Clients exports a TAB file from filemaker pro, which is uploaded > >>and I chang it to a txt file and replace the tabbed spaces with > >>",", so if i do cfloop (list) over it i get an output like this: > >> > >> Emmitt R,Barns, III, tim,Douglas,[EMAIL PROTECTED] > >>Rick,Middletorn, Dennis,Drieml, David,Perky, > >>Brian,Wells,[EMAIL PROTECTED] > >>Now I only want the rows that have an email attached to them. > >>Now I can do a listlen and check if it has something in the 3 > >>position (email) and that the 3rd position is an email (see the > >>first entry where the 3rd position is not an email), then if > >>thats met then delete all the rows that dont have at least an > >>email. and be ready to insert to db. > >> > >>any ideas? > >> > >>~Dave the disruptor~ > >>I forgot what I was gunna put here, Will woulda stole it anyways! > >> > >> > >> > >> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231908 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
