That might be one of your problems. If you use multiple characters as
delimiters, ColdFusion only sees "one" of them. I'd recommend using
REReplaceNoCase to remove the additional spaces first, then insert an
alternate delimiter in the correct spot. This will replace 2 or more spaces
with a tilde:
<cfset yourString = "LANCASTER MS BAND JAMES
GUENGERMAN">
<cfoutput>[#REReplaceNoCase(yourString,"[ ]{2,}","~","ALL")#]</cfoutput>
-----Original Message-----
From: Chris Martin [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 30, 2007 10:27 AM
To: CF-Talk
Subject: Re: listQualify and multiple spaces
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
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287457
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
