When you replace the tabs, add quote to delineate blocks of text. Otherwise, any commas are treated as list delineators. You could also use a different character other than a comma. The delimiter is able to be specified in the list functions.
Eric -----Original Message----- From: dave [mailto:[EMAIL PROTECTED] Sent: Friday, 10 February 2006 00: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:232025 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
