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 then on? > > Kenneth Grome, WebDNA ConsultantGood question. In this case, no. I want to take two fields (one numeric, and one alphanumeric (but left padded with zeros) and combine then (without the left padded zeros) into a new third field in a database of 64000 records 4-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:

    
  1. Re: Removing a character (Kenneth Grome 2000)
  2. Re: Removing a character (Rob Marquardt 2000)
  3. Re: Removing a character (Brian B. Burton 2000)
  4. Re: Removing a character (Michael Winston 2000)
  5. Re: Removing a character (Kenneth Grome 2000)
  6. Removing a character (Brian B. Burton 2000)
>>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 then on? > > Kenneth Grome, WebDNA ConsultantGood question. In this case, no. I want to take two fields (one numeric, and one alphanumeric (but left padded with zeros) and combine then (without the left padded zeros) into a new third field in a database of 64000 records 4-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)