----- Original Message -----
From: Elliot Temple <[EMAIL PROTECTED]>
Date: Mon, 26 Jul 2004 19:18:26 -0700
To: CF-Newbie <[EMAIL PROTECTED]>
Subject: Re: Reading a comma delimited file from excel and splitting it into variables
you need a loop, unless there will always be the same number of emails,
in which case you could just copy/paste ur line a few times and change
the number. for a loop do something like:
<cfloop index="i" from=7 to = *length of your list goes here, look up
the function for that* >
Email #i#: #ListGetAt(extFile, i)#<br>
</cfloop>
or format to taste
-- Elliot Temple
http://www.curi.us/
On Jul 26, 2004, at 7:11 PM, Scott Adams wrote:
> Hello Adrian,
>
> Thanks. Every works except for the following:
>
> [EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED]
>
> I used Email: #ListGetAt(extFile, 7)# but I only get the following
> output:
>
> Email: [EMAIL PROTECTED]
>
> The email will always be in the "7th" place so I want everything that
> follows that line. So the output would be:
>
> Email:
> [EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED]
>
> ----- Original Message -----
> From: "Adrian Lynch" <[EMAIL PROTECTED]>
> Date: Tue, 27 Jul 2004 00:54:14 +0100
> To: CF-Newbie <[EMAIL PROTECTED]>
> Subject: RE: Reading a comma delimited file from excel and splitting
> it into variables
>
> If the data is always of the same format
>
> Food: #ListGetAt(extFile, 1)#<br />
> Desc: #ListGetAt(extFile, 2)#<br />
> Cost:��#ListGetAt(extFile, 3)#<br />
> etc...
> etc...
>
> Except you want it in a table :OP
>
> Hope that's of some help
>
> Ade
> ��-----Original Message-----
> ��From: Scott Adams [mailto:[EMAIL PROTECTED]
> ��Sent: 27 July 2004 00:03
> ��To: CF-Newbie
> ��Subject: Reading a comma delimited file from excel and splitting it
> into
> variables
>
> ��Someone help me please if you can.
>
> ��I have a comma delimited file that I'm reading in and putting it
> into a
> variable "extfile"
>
> ��File looks like this
>
> ��cabbage,makes you
>
> fart,$5.00,$1.00,$6.00,[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED]
> om,gr
> [EMAIL PROTECTED]
>
> ��From the above line how can I output this as a table in CF to look
> like
> the following:
>
> ���������Food: cabbage
> ��Description: makes you fart
> ���������Cost: $5.00
> ��������� Tax: $1.00
> ��������Total: $6.00
> ��������Email:
> [EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED]
>
>
> ��--
> ��_______________________________________________
> ��Find what you are looking for with the Lycos Yellow Pages
>
>
> http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/
> default.asp
> ?SRC=""> >
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
