Sorry, the line turned out wrong...I put it in HTML below to display better
Chris Martin wrote: > Basically all I'm trying to is separate "LANCASTER MS BAND" from "JAMES > GUENGERMAN" because they are two seperate items. But since they reside > on the same line, simply performing adding a different delimiter (other > than the single space) isn't going to give me what I want...it just > create a different delimiter for the list. Here's what I've tried. > > The is formatted like this: > > LANCASTER MS BAND > JAMES GUENGERMAN > > 1. <cfset theCustomer = #listFirst(line, "chr(32)chr(32)")#> > 2. <cfset theCustomer = #listGetAt(line, 1, "chr(32)chr(32)")#> > > I only put 2 spaces as the delimiter because anything else is single > spaced. > > Chris Martin > > > > > Andy Matthews wrote: >> What are you expecting to happen? Do you want to return multiple indexes >> from those multiple spaces? Maybe you could find and replace spaces with a >> tilde (~) or something, then use that as your new delimiter? >> >> -----Original Message----- >> From: Chris Martin [mailto:[EMAIL PROTECTED] >> Sent: Thursday, August 30, 2007 9:38 AM >> To: CF-Talk >> Subject: listQualify and multiple spaces >> >> I'm trying to parse a .txt file using the built-in java reader and have come >> across an issue where I need to qualify a list based on multiple spaces on a >> line. For instance, >> >> LANCASTER MS BAND >> JAMES GUENGERMAN >> >> The qualifier will be between "Band" and "James". There are over 10,000 >> records that will be read in this method, so there is no set number of >> spaces between the two strings. >> >> Any help is greatly appreciated! >> >> >> >> >> >> >> Chris Martin >> >> >> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287456 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4