Re: Removing a character
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 27903
interpreted = N
texte = >>What is the smallest amount of code (please show) that you can write to>>accomplish this simple task:>>>>You are given a database containing a field of data left padded by zeros>>that you need to clean out. Example:>>>>Given -> What you want>>----- ------------->>00B B>>BLK BLK>>BL0 BL0>>0BT BT>>0Y0 Y0>>>>Any quick ideas (looking for least processor intensive, and prefer to avoid>>a lookup or looping convertchars)?>> Do you want to get rid of the leading zeros just once, so you can generate> a new db without the leading zeros in it, then use the new database from thenon?>> Kenneth Grome, WebDNA ConsultantGood question. In this case, no. I want to take two fields (one numeric, andone alphanumeric (but left padded with zeros) and combine then (without theleft padded zeros) into a new third field in a database of 64000 records4-12 times a day.(it's an incoming file that gets processed and posted.) Brian B. Burton BOFH - Department of Redundancy Department--------------------------------------------------------------- MMT Solutions - Specializing in Online Shopping Solutions 973-808-8644 http://www.safecommerce.com-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to
.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
Associated Messages, from the most recent to the oldest:
>>What is the smallest amount of code (please show) that you can write to>>accomplish this simple task:>>>>You are given a database containing a field of data left padded by zeros>>that you need to clean out. Example:>>>>Given -> What you want>>----- ------------->>00B B>>BLK BLK>>BL0 BL0>>0BT BT>>0Y0 Y0>>>>Any quick ideas (looking for least processor intensive, and prefer to avoid>>a lookup or looping convertchars)?>> Do you want to get rid of the leading zeros just once, so you can generate> a new db without the leading zeros in it, then use the new database from thenon?>> Kenneth Grome, WebDNA ConsultantGood question. In this case, no. I want to take two fields (one numeric, andone alphanumeric (but left padded with zeros) and combine then (without theleft padded zeros) into a new third field in a database of 64000 records4-12 times a day.(it's an incoming file that gets processed and posted.) Brian B. Burton BOFH - Department of Redundancy Department--------------------------------------------------------------- MMT Solutions - Specializing in Online Shopping Solutions 973-808-8644 http://www.safecommerce.com-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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
Brian B. Burton
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:
Fwd: Problems with Webcatalog Plug-in (1997)
E-mailer error codes (1997)
Re:WebCat Emailer & Liststar (1997)
[HIDEIF] inside [FOUNDITEM] (1997)
Trouble with formula.db (1997)
Nested tags count question (1997)
Nav. 4 probs with cart - Serious problem (1997)
Serial Number Question (1997)
California Tax Rates (1998)
WebCat2 beta FTP site (1997)
Printing from Web pages (1998)
WC on Mac OS X or Mac OS X Server 2.x (2001)
math on date? (1997)
Duplicate record (2005)
Formulas.db + Users.db (1997)
converted seed value? (1998)
Showif, Hideif reverse logic ? (1997)
Further tests with the infamous shipCost (1997)
Sku numbers (1997)
[ShowNext] (1997)