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