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],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="" Remove Footer Here-->
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
