RE: Killing Commas

2001-03-27 Thread Costas Piliotis
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---

Re: Killing Commas

2001-03-27 Thread Brian Thornton
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:3

RE: Killing Commas

2001-03-27 Thread lsellers
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.cf

Re: Killing Commas

2001-03-27 Thread Jennifer
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

RE: Killing Commas

2001-03-27 Thread Mike Sullivan
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? > > > ~~~

RE: Killing Commas PART 2

2001-03-27 Thread Phoeun Pha
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?

RE: Killing Commas

2001-03-27 Thread Phoeun Pha
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? ~~~

Re: Killing Commas

2001-03-27 Thread Tony Schreiber
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://w

RE: Killing Commas

2001-03-27 Thread Costas Piliotis
#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? ~~~

RE: Killing Commas

2001-03-27 Thread Caulfield, Michael
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 Co

RE: Killing Commas

2001-03-27 Thread Duane Boudreau
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 return