RE: Killing Commas
I think he got the point :) Wazzat... 7 responses? lol =) -Original Message- From: Mike Sullivan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 12:39 PM To: CF-Talk Subject: RE: Killing Commas cfset astr = "1,2,3,4"> #astr# > -Original Message- > From: Brian Thornton [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, March 27, 2001 11:38 AM > To: CF-Talk > Subject: Killing Commas > > Anyone know of a "quick" fix for removing commas in returned data? > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Killing Commas
The file importing the data, only accepts comma... Not tabs, pipes, nothing else. Thanks so much for your helpful insight... - Original Message - From: "Jennifer" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 27, 2001 12:36 PM Subject: Re: Killing Commas > At 11:38 AM 3/27/2001 -0800, you wrote: > >Anyone know of a "quick" fix for removing commas in returned data? > > Why do you have unwanted commas in your return data to begin with? > > If the problem that you are trying to solve is that you are putting the > results in a list and the commas are screwing up the list, you can use a > different delimiter when you make the list and get around the issue. > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Killing Commas
Murderers. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Killing Commas
At 11:38 AM 3/27/2001 -0800, you wrote: >Anyone know of a "quick" fix for removing commas in returned data? Why do you have unwanted commas in your return data to begin with? If the problem that you are trying to solve is that you are putting the results in a list and the commas are screwing up the list, you can use a different delimiter when you make the list and get around the issue. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Killing Commas
cfset astr = "1,2,3,4"> #astr# > -Original Message- > From: Brian Thornton [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, March 27, 2001 11:38 AM > To: CF-Talk > Subject: Killing Commas > > Anyone know of a "quick" fix for removing commas in returned data? > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Killing Commas PART 2
better yet, use the REMOVECHARS function! -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 1:38 PM To: CF-Talk Subject: Killing Commas Anyone know of a "quick" fix for removing commas in returned data? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Killing Commas
errr use the replace function! -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 1:38 PM To: CF-Talk Subject: Killing Commas Anyone know of a "quick" fix for removing commas in returned data? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Killing Commas
Replace(ReturnedData,',','','ALL') > Anyone know of a "quick" fix for removing commas in returned data? > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Killing Commas
#replace (, ",", "", "ALL")# Should work :) -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 11:38 AM To: CF-Talk Subject: Killing Commas Anyone know of a "quick" fix for removing commas in returned data? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Killing Commas
you can either replace them with nothing:
replace("1,2,3,4,5,6,7,8,8",",","","ALL")
or use listchangedelims
ListChangeDelims("1,2,3,4,5,6,7,8,8", "")
-Original Message-
From: Brian Thornton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 1:38 PM
To: CF-Talk
Subject: Killing Commas
Anyone know of a "quick" fix for removing commas in returned data?
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Killing Commas
Use the replace function replace(FieldName, ",", "some character", "All") HTH, Duane -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 2:38 PM To: CF-Talk Subject: Killing Commas Anyone know of a "quick" fix for removing commas in returned data? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
