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:287454 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
