Re: String manipulation in Webcatalog
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39070
interpreted = N
texte = Laeg Ent. wrote: > > [grep > search=0+([0-9]+)0+&replace=\1][likenumber][/grep] > > this just gets rid of the initial zeros...... > > 0010200 results in 10200 > Sorry, the ([0-9]+) is too greedy (snagging all trailing zeros). If you were using Perl, you could use this instead: [grep search=0+([0-9]+?)0+&replace=\1][likenumber][/grep]which would be the nongreedy version of 1 or more. In this case, you will have to pick off the initial zeros then strip the trailing zeros. Do this to strip the trailing zeros: [grep search=([1-9]+)0+$&replace=\1][likenumber][/grep]which is to say find any sequence numbers that do not include 0 and are followed to the end of line by only zeros and replace it by just the number.John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Laeg Ent. wrote: > > [grep > search=0+([0-9]+)0+&replace=\1][likenumber][/grep] > > this just gets rid of the initial zeros...... > > 0010200 results in 10200 > Sorry, the ([0-9]+) is too greedy (snagging all trailing zeros). If you were using Perl, you could use this instead: [grep search=0+([0-9]+?)0+&replace=\1][likenumber][/grep]which would be the nongreedy version of 1 or more. In this case, you will have to pick off the initial zeros then strip the trailing zeros. Do this to strip the trailing zeros: [grep search=([1-9]+)0+$&replace=\1][likenumber][/grep]which is to say find any sequence numbers that do not include 0 and are followed to the end of line by only zeros and replace it by just the number.John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
John Peacock
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
&fieldsdir=ra truely random?? (2000)
Auto SKU's (2000)
Thanks ! (1997)
Renaming DB fields (2000)
Logging purchases (1997)
Default contains WEBDNA (1998)
[WebDNA] Is there a D.E. database record limit? (2014)
Questions about searching (1999)
More questions about serial number dishing (1997)
Search-context (1999)
WebCatalog NT beta 18 now available (1997)
unsubscribe (1997)
PCS Emailer's role ? (1997)
referrer and no caches (1997)
Error Lob.db records error message not name (1997)
Missing Links (2000)
Error: Error: expected [/APPLICATION] ??? (1998)
[replaceChars] would be nice ... (1997)
Secure server question (1997)
[WebDNA] search command problem (2009)