This works:
<!--- List Delimiter --->
<cfset custom = 'Yummy Crackers, Inc.*Florida'>
<cfoutput>Company = #listGetAt(custom, 1, '*')#<br></cfoutput>
<cfoutput>Location = #listGetAt(custom, 2, '*')#<br></cfoutput>
<cfloop list="#custom#" index="currentValue" delimiters="*">
<cfoutput>#currentValue#<br></cfoutput>
</cfloop>
On Jan 21, 2008 2:22 PM, Mark Proper <[EMAIL PROTECTED]> wrote:
> My apologies if you get this twice...first time using this resource and
> I did not see the post show up. Trying it again:
>
>
>
> I have a string that I knew was going to have commas in it (such as
> company names or address) so I made the delimiter in the string an
> asterisk.
>
>
>
> Here is small example code I've been trying to get working:
>
>
>
> <cfset custom = 'Yummy Crackers, Inc.*Florida'>
>
> <cfloop list="#custom#" index="fields">
>
> <cfoutput>Company = #listGetAt(fields, 1,
> '*')#<br></cfoutput>
>
> <cfoutput>Location = #listGetAt(fields, 2,
> '*')#<br></cfoutput>
>
> </cfloop>
>
>
>
> When I do that, Company is "Yummy Crackers" (truncates the ", Inc.) and
> it blows up on field 2 saying it doesn't exist. It works fine if the
> company doesn't have a comma in it.
>
>
>
> Obviously the comma is completely screwing up the logic. What can I do
> to get this working? I am at a complete loss and under the gun, so I'm
> begging for help here. Begging, literally.
>
>
> This email, and any files transmitted with it, is the
> property of CCAP and, unless indicated otherwise, is
> intended only for the individual or entity addressed.
> This email may contain confidential information.
> If you are not the intended recipient, or the recipient's
> authorized agent, you are hereby advised that keeping,
> using, copying, disclosing or disseminating this communication
> without CCAP's advance written consent is prohibited.
> If you have received this email in error, please notify the sender
> immediately and then delete it.
> CCAP cannot accept liability for any loss or damage caused by software
> viruses and advises that you carry out your own virus checks on any
> attachment to this message.
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297014
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4