Re: Removing a character

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 27901
interpreted = N
texte = >A quick challenge to the WebCatalog Super Heroes out there: > >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)?There must be an easier way than this, but it's what I could come up with in 3 minutes. haven't tried it, hope it works.:[TEXT SHOW=F]GO=YES[/TEXT] [TEXT SHOW=F]STRING=[GIVEN][/TEXT][LOOP START=1&END=[COUNTCHARS][GIVEN][/COUNTCHARS]] [SHOWIF [GO]=YES] [SHOWIF [GETCHARS START=1&END=1][STRING][/GETCHARS]=0] [TEXT SHOW=F]STRING=[GETCHARS START=2][STRING][/GETCHARS][/TEXT] [/SHOWIF][SHOWIF [GETCHARS START=1&END=1][STRING][/GETCHARS]!0] [TEXT SHOW=F]GO=NO[/TEXT] [/SHOWIF] [/SHOWIF] [/LOOP][STRING]So, count the number of characters in [GIVEN]. Loop through and, it the iteration passes the [GO] test, lop off the first character if it's a 0. If it's not a 0, change the filtering variable ([GO]) to NO to prevent anything from happening in the rest of the iterations. There's actually a command to break the loop, but I don't remember it and it's not documented.Michael ------------------------------------------------------------- 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)
>A quick challenge to the WebCatalog Super Heroes out there: > >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)?There must be an easier way than this, but it's what I could come up with in 3 minutes. haven't tried it, hope it works.:[TEXT SHOW=F]GO=YES[/TEXT] [TEXT SHOW=F]STRING=[GIVEN][/TEXT][LOOP START=1&END=[countchars][GIVEN][/COUNTCHARS]] [SHOWIF [GO]=YES] [SHOWIF [GETCHARS START=1&END=1][STRING][/GETCHARS]=0] [TEXT SHOW=F]STRING=[GETCHARS START=2][STRING][/GETCHARS][/TEXT] [/SHOWIF][SHOWIF [GETCHARS START=1&END=1][STRING][/GETCHARS]!0] [TEXT SHOW=F]GO=NO[/TEXT] [/SHOWIF] [/SHOWIF] [/LOOP][STRING]So, count the number of characters in [GIVEN]. Loop through and, it the iteration passes the [GO] test, lop off the first character if it's a 0. If it's not a 0, change the filtering variable ([GO]) to NO to prevent anything from happening in the rest of the iterations. There's actually a command to break the loop, but I don't remember it and it's not documented.Michael ------------------------------------------------------------- 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 Michael Winston

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:

[WebDNA] multiple cookies of the exact same name?! (2009) Separate SSL Server (1997) WebDNA maxing out processor / Strange intermittent WebDNA (2008) setlineiems and UnitShip Cost (2000) price change help (1998) can WC render sites out? (1997) expired beta (1997) Multi-User Security on *nix using mod_rewrite (2002) make a beep (2004) WebCat for Site Search? (1997) Missing Cart Information (2003) WebCatalog (1998) OT ImageMagick and Thumbnails (2003) Porting to NT (2001) Webcat Manual and TeaRoom Examples Uses Different Examples. (1997) Looping a variable name with [index] (1999) website pro trouble (1998) [WebDNA] Help with work-around format date (2013) PSC recommends what date format yr 2000??? (1997) [WebDNA] My SQL will not Connect (2020)