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:231899 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
