I have a CSV that looks like the following... 3270,5101650,"Dewey, Cheatum & Howe ", 0 , 0 ,0.00,0.00,9.25,-9.25 3270,5101650,Phillip Vector , 34 ," 3,161.00 ",92.97,79.25,61.76,17.50 3270,5101650,"James P. Kardone JR., P.C. ", 0 , 0 ,0.00,0.00,9.25,-9.25
I'm stuck on how to process the fields and load them into an array. How would I say, "If the field is surrounded by quotes, then ignore the commas in it"? I would think I would need to load it into the array as a field before I could find out if it's surrounded by quotes. But I can't load it correctly into the array until I find out if there are quotes around it. Changing the CSV is not an option (I know, it would make things much easier). Ideas? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329310 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4