Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trim leading zeros using CF...HOW?

Status
Not open for further replies.
WildWest

WildWest

Programmer
Apr 2, 2002
111
US
Does anyone know how to trim leading zeros in CF?

For example, I have "0003457823"
and I only want "3457823"

Thanks in advance!
 
Sort by date Sort by votes
i am suprised nobody else answered this

i am a total noob when it comes to regular expressions, but this one was pretty easy --

REReplace(field,"^0+","")


rudy
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sirnose1
  • Locked
  • Question
CFIF for CFmail
Replies
0
Views
674
sirnose1
sirnose1
cfhelp
  • Locked
  • Question
Coldfusion 2016 - Cant find CFX_tags
Replies
0
Views
524
cfhelp
cfhelp
RosieGp
  • Locked
  • Question
How to read string of 0s and 1s 1
Replies
3
Views
727
LyndonOHRC
LyndonOHRC
LyndonOHRC
  • Locked
  • Question
Need help using ImageCrop()
Replies
1
Views
241
LyndonOHRC
LyndonOHRC
FALCONSEYE
  • Locked
  • Question
Error: no known VMs. (check for corrupt jvm.cfg file) !!! How I Fixed It !!!
Replies
0
Views
802
FALCONSEYE
FALCONSEYE

Part and Inventory Search

Sponsor

Back
Top