What Justin should have put was this:
WHERE somefield =
Always use cfqueryparam for user-supplied query values!
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing
> I have tried multiple combinations using the trim function, but
> none of them work.
It looks like you're putting the trim() on the value attribute of the input
field. How about the value you pass into the query? This should work:
select fields from table where
somefield = '
I have tried multiple combinations using the trim function, but none of
them work. If I put a trailing space at the end of the search, I get no
record found. If there is no trailing space, the record is produced. I
would appreciate any guidance you can give.
I have tried:
value="
Then, technically, the function is accurate: StripLZero
He needs a function named StripLZeros
:^)
m!ke
-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2008 10:10 AM
To: CF-Talk
Subject: Re: Trim leading zeros
I just ran
> -Original Message-
> From: Paul Ihrig [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 01, 2008 10:43 AM
> To: CF-Talk
> Subject: Trim leading zeros
>
> how would i trim the results below
> i only want the numbers after the zeros.
>
> 0
If you add an * after the zero works (return
REReplace(s,"^0*","","ALL");). This is the greedy way to do it though. I
am sure there is a more elegant way.
I even put in a zero in the middle of the other numbers just to make
sure it did not strip it out and it did not. Just figured it would be a
I've just tested this and it works:
#Val((myVal * Pi()) / Pi()) * 1^(64-Tan(12))#
But perhaps something simple would be better like Val(theValue) :p
Dominic
--
Blog it up: http://fusion.dominicwatson.co.uk
~|
Ado
at you would
> expect to see.
>
> reFind(origString, "^0+", "")
>
> m!ke
>
>
> -Original Message-
> From: James Smith [mailto:[EMAIL PROTECTED]
>
> Sent: Tuesday, April 01, 2008 9:52 AM
> To: CF-Talk
> Subject: Re: Trim leading
Actually doing anything mathematical to it will work too so you could also do...
#yourNumber*1#
#yourNumber+1-1#
#ceiling(yourNumber)#
etc...
--
Jay
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release
Sent: Tuesday, April 01, 2008 9:52 AM
To: CF-Talk
Subject: Re: Trim leading zeros
> CFLib.org has a UDF that does this:
>
> http://cflib.org/udf.cfm?ID=239
That wouldn't work, looking at the code for that UDF it wou
Add Val(000123) to that list too.
Adrian
-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED]
Sent: 01 April 2008 15:47
To: CF-Talk
Subject: Re: Trim leading zeros
numberFormat(yourNumber,0)
or if you want to be silly...
rereplace(yourNumber,'^0+',''
I'll second the numberformat()..
On Tue, Apr 1, 2008 at 9:47 AM, Bruce Sorge <[EMAIL PROTECTED]> wrote:
> CFLib.org has a UDF that does this:
>
> http://cflib.org/udf.cfm?ID=239
>
>
>
>
> Paul Ihrig wrote:
> > how would i trim the results below
>
> CFLib.org has a UDF that does this:
>
> http://cflib.org/udf.cfm?ID=239
That wouldn't work, looking at the code for that UDF it would only
strip the first zero...
--
Jay
~|
Adobe® ColdFusion® 8 software 8 is the most importan
CFLib.org has a UDF that does this:
http://cflib.org/udf.cfm?ID=239
Paul Ihrig wrote:
> how would i trim the results below
> i only want the numbers after the zeros.
>
> 0009970656
> 056901
>
> 9970656
>
numberFormat(yourNumber,0)
or if you want to be silly...
rereplace(yourNumber,'^0+','','ALL')
On Tue, Apr 1, 2008 at 3:44 PM, James Smith <[EMAIL PROTECTED]> wrote:
> numberformat(youNumber,0)
>
>
> On Tue, Apr 1, 2008 at 3:42 PM, Paul Ihrig <
how would i trim the results below
i only want the numbers after the zeros.
0009970656
056901
9970656
56901
thanks
-paul
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
No worries!
Cheers,
Teddy
On 1/10/07, Jen N <[EMAIL PROTECTED]> wrote:
>
> Teddy,
>
> No interuption at all, I appreciate the response :) Anyway, for now, that
> is exactly how we're handling it. We just decided to put a trim on the
> coldfusion side.
>
>
Teddy,
No interuption at all, I appreciate the response :) Anyway, for now, that is
exactly how we're handling it. We just decided to put a trim on the coldfusion
side.
After talking to some database folk it seems to be a known Oracle JDBC driver
issue. I'm not sure if
I hope that I am not interpreting wrong here, but whther you get mixed
results or not, do you want a trailing space after the column "level?"
You could just use the following and whether you receive the extra space or
not, it should return the same result:
#trim(level)#123
Cheers,
Ted
tal' as name,
'NYY' as code
FROM table
#level#123
Results in MX:
0 123
Results in CF5:
0123
However if the column "level" is actually in the database. .. we can trim
within the sql and we get the expected results when
uot;. However in CF7 an extra space is added on to the end. So if we
append 123 on the end, we get "wddx 123" or "paramString 123". Before we
thought it was just with any column, but it appears to the ones that are in the
case statments. Its bascially forcing us to do the tri
; ~Dave the disruptor~
> This bottle of lemonaid says "contains no lemon juice"
> and the can of Pledge says "contains real lemon juice"
> figures @%*((&%
>
>
> From: Andrew Grosset <[EMAIL PROTECTED]>
> Sent: W
From: Andrew Grosset <[EMAIL PROTECTED]>
Sent: Wednesday, June 01, 2005 11:57 PM
To: CF-Talk
Subject: form trim ?
>can you compound the trim funtion with HTMLEditFormat to do both at once?
>
> like maybe
>
>
>~Dave the disruptor~
>This bottle of
>can you compound the trim funtion with HTMLEditFormat to do both at once?
>
> like maybe
>
>
>~Dave the disruptor~
>This bottle of lemonaid says "contains no lemon juice"
>and the can of Pledge says "contains
can you compound the trim funtion with HTMLEditFormat to do both at once?
like maybe
~Dave the disruptor~
This bottle of lemonaid says "contains no lemon juice"
and the can of Pledge says "contains real lemon
Just to show off
REReplace(number,"\.\d\d$","")
Pascal
> -Original Message-
> From: Ewok [mailto:[EMAIL PROTECTED]
> Sent: 06 August 2004 02:58
> To: CF-Talk
> Subject: Re: trim numbers
>
> any of these should do the trick
>
> NumberForm
Sent: Thursday, August 05, 2004 12:24 PM
Subject: RE: trim numbers
I usually use the following:
replace(dollarformat(number), ".00", "", "All")
hope this helps
Duane
_
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 05,
Thanks it did...
-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 05, 2004 12:25 PM
To: CF-Talk
Subject: RE: trim numbers
I usually use the following:
replace(dollarformat(number), ".00", "", "All")
hope this helps
Depending on how the data is formatted, this will also work:
ListFirst(price,'.')
- Original Message -
From: Gavin Brook <[EMAIL PROTECTED]>
Date: Thu, 5 Aug 2004 17:32:14 +0100
Subject: RE: trim numbers
To: CF-Talk <[EMAIL PROTECTED]>
If you know roughly t
If you know roughly the maximum price to be displayed you could use:
NumberFormat(number,"999,999,999") for 1 million dollars
-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]
Sent: 05 August 2004 17:25
To: CF-Talk
Subject: RE: trim numbers
I usually use the
Are you outputing the number with the dollar sign on it or are you
adding that during output?
If the latter, use NumberFormat(number,mask)
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functa48.htm#wp11
10053
Michael T. Tangorre
> I need to trim numbers from a price.
>
> Fo
I usually use the following:
replace(dollarformat(number), ".00", "", "All")
hope this helps
Duane
_
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 05, 2004 12:14 PM
To: CF-Talk
Subject: trim numbers
I need to trim numbers from a p
I need to trim numbers from a price.
For example, I want the price displayed as $120 not $120.00 as it is now. Is the code for this using LTRIM?
I need it to count how many characters then trim the last three so that $50.00 would look like $50 the same as $120.00 would look like $120.
Robert O
Brain fart moment... how can I most easily/reliably trim the prefix from an
e-mail address:
[EMAIL PROTECTED]
I want everything before the @... so: 'test'.
--
Jillian
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
TW7 5QD
[EMAIL PROTECTED]
http://www.sky.com
tel: +44 (0) 20 7941 5329
fax: +44 (0) 20 7941 5243
_
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: 19 May 2004 20:47
To: CF-Talk
Subject: Trim E-Mail Prefix
Brain fart moment... how can I most e
Why don't you try, ?
Steve
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 19, 2004 3:47 PM
To: CF-Talk
Subject: Trim E-Mail Prefix
Brain fart moment... how can I most easily/reliably trim the prefix from an
e-mail address:
[EMAIL PROT
Thanks all for your QUICK suggestions. Sometimes its too easy but your thinking too ahead of the game.
Robert O.
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 10, 2004 9:32 AM
To: CF-Talk
Subject: RE: Trim in cfoutput
Change it to
#trim
Move your #s outside the TRIM function
#TRIM(getinfo.trialname)#.htm
Randy Adkins
SRA International
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 10, 2004 9:23 AM
To: CF-Talk
Subject: Trim in cfoutput
How do I apply the trim
Change it to
#trim(getinfo.trialname)#.html
Notice the difference? The # signs are around trim. In your example, they
were only arround the varaible so CF just ignored the Trim part.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
#trim(getInfo.trialName)#.htm
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
How do I apply the trim function in a CFOUTPUT?
I have: Trim(#getinfo.trialname#).htm. (Maybe it should be in cfoutput--not sure on this)
It's probably wrong I figure. I need the ".htm" to appear right after the "getinfo.trialname" so it can be clicked directly to a htm
s = cfexecute_output;
s = removeChars(s, 1, find("---", s) + 3);
s = trim(s);
That should give you everything after the three dashes. If you're looking
for three dashes on a line by themselves, then replace the find() call with
REfind("^---$", s) and you should be s
I have this variable that stores the output of a cfexecute function, for
our payment processing. I am trying to figure out a way to trim it down
so that the variable data is only the text after the --- towards the
bottom. Since the response from the server will always be a Y01
number or
- Original Message -
From: "Joshua Miller" <[EMAIL PROTECTED]>
> Yes, the file field seems to be the anomaly in using that method ...
> I've found you have to actually TRIM() the file upload in the CFFILE tag
> to get it to work 100%
--
Yes, the file field seems to be the anomaly in using that method ...
I've found you have to actually TRIM() the file upload in the CFFILE tag
to get it to work 100%
This is what I do to catch everything but the file field, then I just
TRIM() all CFFILE uploads
if(HTTP_USER_AGENT contains
ts
thrown when you try, saying something like "form.filePath doesn't contain a
file".
Of course by the time you get to the server, form.filePath is something like
"C:\WinNT\Temp\AC0245.tmp" due to the way CF uploads stuff. But I really
can't see any difference between
Thanks All, That was the answer I needed!
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www
D]]
> Sent: Wednesday, September 11, 2002 5:32 PM
> To: CF-Talk
> Subject: Re: is there a trim function to get rid of a space between
> names
>
>
> I think you really need to ask for first name and last name
> separately,
> or just accept the full name the way they enter it
I think you really need to ask for first name and last name separately,
or just accept the full name the way they enter it.
You run into problems in certain cultures where the surname is used
first.
Also, I remember one lady named [sp]:
sue man joe
How do handle that?
HTH
Dick
O
Well, if you had a full name, i.e. "Allan Mac Donald" and you wanted to
eliminate the 2nd space, you could use
Of course, this assumes that there aren't any numbers in the person's
name... if you want to allow digits, just change [:alpha:] to [:alnum:] ...
You could also use [[:space:]]+? inste
--
jon
mailto:[EMAIL PROTECTED]
Wednesday, September 11, 2002, 4:26:31 PM, you wrote:
RJS> Hi all,
RJS> Is there a way to get CF to delete the space in between a name. ie... "Mac
RJS> Donald" to just "MacDonald"?
RJS> Thanks,
RJS> Joy
RJS>
_
Maybe by getting rid of all spaces?
Jerry Johnson
>>> [EMAIL PROTECTED] 09/11/02 04:26PM >>>
Hi all,
Is there a way to get CF to delete the space in between a name. ie... "Mac
Donald" to just "MacDonald"?
Thanks,
Joy
__
Try ReplaceNoCase("Mac Donald", " ", "", "ALL")
-Original Message-
From: Rebecca Joy Sherman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 11, 2002 2:27 PM
To: CF-Talk
Subject:is there a trim function to get rid of a spac
herman [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 11, 2002 4:27 PM
> To: CF-Talk
> Subject: is there a trim function to get rid of a space between names
>
>
> Hi all,
>
> Is there a way to get CF to delete the space in between a name.
> ie... "Mac
>
]>
Sent: Wednesday, September 11, 2002 4:26 PM
Subject: is there a trim function to get rid of a space between names
> Hi all,
>
> Is there a way to get CF to delete the space in between a name. ie... "Mac
> Donald" to just "MacDonald"?
>
>
> Thanks,
>
Rebecca Joy Sherman writes:
#replace("Mac Donald", " ", "", "all")#
will work...
there's probably a regular expression to search for a space...i just don't
know reg exps :(
charlie
> Hi all,
>
> Is there a way to get CF to delete the space in between a name. ie... "Mac
> Donald" to
Errr...What's wrong with
Replace(LastName," ","","ALL")
> -Original Message-
> From: Rebecca Joy Sherman [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 11, 2002 4:27 PM
>
> Is there a way to get CF to delete the space in between a
> name. ie... "Mac
> Donald" to just "MacDon
Hi all,
Is there a way to get CF to delete the space in between a name. ie... "Mac
Donald" to just "MacDonald"?
Thanks,
Joy
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources
applicants,
colName,
trim(jobapplicants[colName][rowNum]),
rowNum);
}
On Wed, 10 Jul 2002 11:54:31 -0400, in cf-talk you wrote:
>Ick ick ick. Remember you don't need to use ev
ally it is." - Yoda
> -Original Message-
> From: James Blaha [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 10, 2002 11:51 AM
> To: CF-Talk
> Subject: Re: Issue: Trying to loop through a query and trim
> all the fields in the table before I output them without
Duh, I meant:
...
Jamie
On Wed, 10 Jul 2002 10:46:15 -0400, in cf-talk you wrote:
>Congratulations, you win the prize for longest subject line. :D
>
>I'd trim in the query itself, but if you want to:
>
>
>
>for (i=1; i LTE listlen(jobapplicants.columnlist)
Jamie it didn't work. What about something like this? But its not
working right.
SELECT *
FROM dbo.tApply
#JobApplicants.ColumnList#
#vCol#
Jamie Jackson wrote:
>Congratulations, you win the prize for longest subject line. :D
>
>I'd trim in the query itself,
Congratulations, you win the prize for longest subject line. :D
I'd trim in the query itself, but if you want to:
for (i=1; i LTE listlen(jobapplicants.columnlist); i=i+1) {
colName = listgetat(jobapplicants.columnlist, i);
querySetCell(jobapplicants, colName, trim(eva
Why not trim in the query?
select rtrim(ltrim(col)), etc
===
Raymond Camden, ColdFusion Jedi Master for Macromedia
Email: [EMAIL PROTECTED]
Yahoo IM : morpheus
"My ally is the Force, and a powerful ally it is.&qu
Hello All:
Issue: Trying to loop through a query and trim all the fields in the
table before I output them without having to hardcode each field.
.
Sincerely,
James Blaha
SELECT *
FROM dbo.tApply
#ValuesPassed
Yeah - I've run into that too. That's why its important to trim strings
when inserting them, but I've worked on projects where the data is
pre-existent and that wasn't an option.
-Original Message-
From: James Sleeman [mailto:[EMAIL PROTECTED]]
Sent: Monday, March
- Original Message -
From: "Ben Forta" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 05, 2002 3:07 PM
Subject: RE: Trim in SQL
> There is no TRIM(), but there is a RTIM() and a LTRIM():
>
> SELECT foo from bar
There is no TRIM(), but there is a RTIM() and a LTRIM():
SELECT foo from bar
WHERE RTRIM(LTRIM(narf)) is like 'blah'
-Original Message-
From: James Sleeman [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 9:07 PM
To: CF-Talk
Subject: OT: Trim in SQL
Anybody know if
Anybody know if there is a way of doing something like the following with
SQL server
SELECT foo from bar
WHERE TRIM(narf) is like 'blah'
---
James Sleeman
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 /
>
> >I'm using #Trim(value)# or #LTrim(RTrim(value))#
> >And in both, some characters "from the side" are being corrupted.
> >This are Hebrew letters.
> >
> >Using CF 5.0, any known bugs?
> >
> yep theres a hotfix for this bug
>
htt
Jason Davis wrote:
>I'm using #Trim(value)# or #LTrim(RTrim(value))#
>And in both, some characters "from the side" are being corrupted.
>This are Hebrew letters.
>
>Using CF 5.0, any known bugs?
>
I'm using #Trim(value)# or #LTrim(RTrim(value))#
And in both, some characters "from the side" are being corrupted.
This are Hebrew letters.
Using CF 5.0, any known bugs?
__
Dedicated Windows 2000 Server
PIII 8
: Thursday, February 21, 2002 2:12 PM
To: CF-Talk
Subject: RE: How to trim text (read inside)
The only problem with this is that it will cut it off in mid-word. So,
you can just loop from 1000 down to 1 and check for the end of a word/parag
raph, and when it is found, take that index to do the Left().
er char position 1000 and trims
at
that point.
Add a ... < more > link to the full article and you're set
- j
jim.curran
technical.director
nylon.technology
212.691.1134
[EMAIL PROTECTED]
-Original Message-
From: Webmaster [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 200
on 1000 and trims at
that point.
Add a ... < more > link to the full article and you're set
- j
jim.curran
technical.director
nylon.technology
212.691.1134
[EMAIL PROTECTED]
-Original Message-
From: Webmaster [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 5:14 PM
T
I have a database table that contains news headlines. I was wondering how to
be able to take like the first 100 - 200 words of the news story and display
it in a "introduction" like section. What I want is that when people come to
the site, they see the latest headlines with the headline, the date
Nevermind, I answered that myself.
Used the #Left(info,250)#...
"Webmaster" <[EMAIL PROTECTED]> wrote in message
3c6d8994$[EMAIL PROTECTED]">news:3c6d8994$[EMAIL PROTECTED]...
> I have a database table that contains news headlines. I was wondering how
to
> be able to take like the first 100 -
> Good news. A tech notes/hot fix for "The trim, ucase, and lcase Functions
Return Incorrect Results for Non-English Languages" is now available at...
>
> http://www.macromedia.com/v1/handlers/index.cfm?ID=22434&Method=Full
>
> this relates to ?'s ( german f
from the forums.macromedia.com
Good news. A tech notes/hot fix for "The trim, ucase, and lcase Functions Return
Incorrect Results for Non-English Languages" is now available at...
http://www.macromedia.com/v1/handlers/index.cfm?ID=22434&Method=Full
this relates to ß's ( ger
Yes, it does.
Antonio Mokarzel
- Original Message -
From: "Paul Hastings" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 29, 2001 1:54 AM
Subject: Re: trim function & non-english languages
> > I use it with Port
> I use it with Portuguese. No problems until now.
thanks. does portuguese extend into the high ascii?
beyond 160?
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives:
Paul,
I use it with Portuguese. No problems until now.
Antonio Mokarzel
- Original Message -
From: "Paul Hastings" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 29, 2001 12:49 AM
Subject: trim function & non-english lan
is anyone using cf5 & non-english language having
problems with the TRIM() function? we have two
sites upgraded to ver 5 that are seeing TRIM()
throw out certain characters along with the spaces.
these are both running nt4. if you're having the same
problem, would you please get b
myString=oldString.replace(/^ */,'').replace(/ *$/,'');
Marlon
-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 9:49 PM
To: CF-Talk
Subject: Trim () in javascript?
A newbie javascript question for ya. Maybe a bit OT
Jeff Green" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 30, 2001 10:49 PM
Subject: Trim () in javascript?
> A newbie javascript question for ya. Maybe a bit OT but you all know the
> Trim() function in CF :)
>
> Just want
A newbie javascript question for ya. Maybe a bit OT but you all know the
Trim() function in CF :)
Just want to know the javascript function for Trim() in CF
But in javascript :)
Thanks,
Jeff
~~
Structure your ColdFusion code with Fusebox
t; <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 29, 2001 2:08 PM
Subject: Trim Question
> For some reason, a custom tag that I am using is adding beginning and
> trailing spaces to the output. Does this happen when the tag takes a
little
> while for the CF
Try #Trim(OutputVariable)#. Otherwise, you will need to go into your
custom tag and figure where the code is adding the spaces. It's not a
problem of CF Server adding the spaces.
HTH,
Steve
"Brian Scott Barnett" <[EMAIL PROTECTED]> wrote in message
000701c100df$c9b6
For some reason, a custom tag that I am using is adding beginning and
trailing spaces to the output. Does this happen when the tag takes a little
while for the CF App server to process?
It's causing a display issue in some versions of Netscape. Any idea how I
might be able to trim the s
amed [Email] and
>[Domain] and I am trying to use either a MID or TRIM statement to copy just
>the domain information into the [Domain] Field.
>
>Any suggestions would be greatly appreciated!!!
>
>Troy Wussow
>Web Dev
See page 1023 of SYBEX's "Mastering Cold Fusion" book for list of SQL functions and
the databases they work with:
Concatenate the following functions into a SQL statement with an AS statement and it
should work...
mLEN = Length(trim(str1)) -- returns the length of the trimed
L PROTECTED]]
> Sent: Wednesday, February 28, 2001 2:28 PM
> To: CF-Talk
> Subject: OT: HELP PLEASE! MS Access Trim Statement
>
>
> I am trying to separate an e-mail address from the domain -
> everything to
> the right of the "@" symbol. I have 2 database fields na
> I am trying to separate an e-mail address from the domain - everything to
> the right of the "@" symbol. I have 2 database fields named [Email] and
> [Domain] and I am trying to use either a MID or TRIM statement to
> copy just the domain information into the [Domain] Fie
: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, February 28, 2001 2:28 PM
Subject: OT: HELP PLEASE! MS Access Trim Statement
| I am trying to separate an e-mail address from the domain - everything to
| the right of the "@" symbol. I have 2 database fields named [Ema
I am trying to separate an e-mail address from the domain - everything to
the right of the "@" symbol. I have 2 database fields named [Email] and
[Domain] and I am trying to use either a MID or TRIM statement to copy just
the domain information into the [Domain] Field.
Any suggestion
> i was actually going to suggest this. the only problem is if the
> file name
> is something like filename.old.cfm or something like that.
So then you can do this:
That will handle almost anything. As long as you know you want to strip off
everything after the last period, and that t
>Note that you don't need the # signs inside the tag.
>
>Bob
>
>-Original Message-
>From: Chad Gray [mailto:[EMAIL PROTECTED]]
>Sent: February 7, 2001 1:56 PM
>To: CF-Talk
>Subject: trim a string variable
>
>
>Is there a way to trim a string like : fi
]]
Sent: Wednesday, February 07, 2001 3:42 PM
To: CF-Talk
Subject: RE: trim a string variable
Look at the List functions within ColdFusion - they are extremely useful.
In your example, you could say
Note that you don't need the # signs inside the tag.
Bob
-Original Message-
From:
01 1:56 PM
> To: CF-Talk
> Subject: trim a string variable
>
>
> Is there a way to trim a string like : file.jpg
> to : file
> (aka knock off the last 4 characters)
>
> Does not
> work because the
> name of the file in the database could be longer then 4 ch
Try
-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2001 20:26
To: CF-Talk
Subject: RE: trim a string variable
Left(var,Len(var)-4)
Let's say var = Bahehehe
You End up with Bahe
Left gives x numbers of characters in var from the left, and Le
1 - 100 of 139 matches
Mail list logo