In that case,
<cffile action="read" file="#ExpandPath('.')#/test.txt" variable="fileData">
<cfset fileData = Replace(fileData, chr(13), "|", "ALL")>
<cfset fileData = Replace(fileData, chr(9), "|" , "ALL")>
<cfloop index="i" list="#fileData#" delimiters="#chr(10)##chr(13)#">
<cfset emailPosition = ListContains(i, "@", "|")>
<cfif emailPosition GT 0>
<cfoutput><li>#ListGetAt(i, emailPosition, "|")#</li></cfoutput>
</cfif>
</cfloop>
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 <[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] 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" <[EMAIL PROTECTED]>
> Sent: Friday, February 10, 2006 3:46 AM
> To: CF-Talk <[email protected]>
> Subject: Re: parsing a list
>
> That actually worked for me:
>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231886
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
