Oh, my code assumed that the first three entries were firstname,
lastname and email.
The only change necessary is to the first loop:
<cfloop condition="i LTE ArrayLen(allRowsArray)">
<cfif allRowsArray[i]) CONTAINS "@">
<cfset ArrayAppend(wantedRows,allRowsArray[i])>
</cfif>
<cfset i = i + 1>
</cfloop>
On 2/10/06, dave <[EMAIL PROTECTED]> 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] or 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.
--
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231885
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
