thanks but they didnt want to spend $50
this works just fine
<cfloop index="index" list="#csvcrap#" delimiters="#chr(10)##chr(13)#">
<!--- get each line and grab the card name --->
<cfset item = #listgetAt('#index#',2, ',')#>
---------- Original Message ----------------------------------
From: "Dave Phillips" <[EMAIL PROTECTED]>
Reply-To: cf-talk@houseoffusion.com
Date: Thu, 20 Jan 2005 15:20:54 -0600
>Csv2query tag would probably help. It's been great for me:
>
>http://www.cftagstore.com/tags/csv2query.cfm
>
>You can just use the 'card name' column after it's done running...
>
>Sincerely,
>
>Dave Phillips
>BizBreeze.com
>[EMAIL PROTECTED]
>615-746-3851
>
>-----Original Message-----
>From: dave [mailto:[EMAIL PROTECTED]
>Sent: Thursday, January 20, 2005 3:19 PM
>To: CF-Talk
>Subject: pulling values from a csv
>
>k im helpin someone but im sick as a dog today and the theraflu has me high
>as a kite, whoo hoo simple ?, i dont wanna think about at the moment
>
>a user will upload a csv file that will be parsed, the data is like such
>
>Qty,Card Name
>1,Zombie Trailblazer
>7,Zombie Cutthroat
>1,Zombie Brute
>8,Zealous Inquisitor
>15,Yotian Soldier
>
>dont want first line of course, dont want the number nor the , just the name
>thats bout all they need it will then loop though comparing each name to a
>db value so in short just want the name, it could be 1-6 words in length the
>rest, i'll worry bout later tia
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware: a new and convenient web-based time tracking application. Start
tracking and documenting hours spent on a project or with a client with Logware
today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191292
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
