No sweat. It can be tweaked to grab names as well but it seems like you have a solution. If you need it I can tweak it to grab names w/ or w/out emails and plop them in a query or array.
On 2/10/06, dave <[EMAIL PROTECTED]> wrote: > > The emails I coud get out as well, however I like yours better than the > way I was doing it. I was hoping to also get the names to go with the emails > if I could since the db table they are going in has first name, last name > and email. While the names "can" be empty I wanted to see if I could get > them in before just going to emails. > Thanks for your efforts! > > ~Dave the disruptor~ > I forgot what I was gunna put here, Will woulda stole it anyways! > > ---------------------------------------- > From: "John C. Bland II" <[EMAIL PROTECTED]> > Sent: Friday, February 10, 2006 4:08 AM > To: CF-Talk <[email protected]> > Subject: Re: parsing a list > > In that case, > > #ListGetAt(i, emailPosition, "|")# > > outputs: > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > > On 2/10/06, dave wrote: > > > > Yeah I know that worked to get that output, my problem is that I only > need > > ones with a email in them, which is "supposed" to be in position 3 but > could > > be in say 1, 4 or 5 if it was like john bohnam iii > [EMAIL PROTECTED] john bohnam iii sr > > [EMAIL PROTECTED] or it could be jon,, [EMAIL PROTECTED] or just > > [EMAIL PROTECTED] So I would like to get rid of the other rows before > > formating for input. > > > > Does that make sense? > > > > ~Dave the disruptor~ > > I forgot what I was gunna put here, Will woulda stole it anyways! > > > > ---------------------------------------- > > From: "John C. Bland II" > > Sent: Friday, February 10, 2006 3:46 AM > > To: CF-Talk > > Subject: Re: parsing a list > > > > That actually worked for me: > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231891 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
