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---
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
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
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
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?
>
>
>
~~~
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?
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?
~~~
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
#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?
~~~
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
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
11 matches
Mail list logo