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 derfloh 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
Joined
Apr 2, 2002
Messages
111
Location
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 Question
CFIF for CFmail
Replies
0
Views
907
sirnose1
sirnose1
cfhelp
  • Locked
  • Question Question
Coldfusion 2016 - Cant find CFX_tags
Replies
0
Views
674
cfhelp
cfhelp
RosieGp
  • Locked
  • Question Question
How to read string of 0s and 1s
Replies
3
Views
999
LyndonOHRC
LyndonOHRC
LyndonOHRC
  • Locked
  • Question Question
Need help using ImageCrop()
Replies
1
Views
340
LyndonOHRC
LyndonOHRC
FALCONSEYE
  • Locked
  • Question Question
Error: no known VMs. (check for corrupt jvm.cfg file) !!! How I Fixed It !!!
Replies
0
Views
1K
FALCONSEYE
FALCONSEYE

Part and Inventory Search

Sponsor

Back
Top