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:

upgrading (1997) View order not right (1997) emailer and other smtp (1998) Can't use old cart file (was One more try) (1997) [WebDNA] WebDNA Crashing or Not **YES** (2008) catagories (1997) too many nested tags ... (1997) woops - speed results - right subject (2002) Has anyone integrated ZipBurst with WebCat? (2000) webmerchant/mac auth. rejects zipcode (1998) [protect admin] (1997) &fieldsdir=ra truely random?? (2000) [WebDNA] Working Authorize.net script if you wanna post... (2020) WebCatalog and directory indexing (1998) Replace and Date (2002) Comments in db? (1997) Integration with SQL (1997) Error: Too many nested [xxx] contexts (1997) Webcatalog Conference? (1998) Webstar 1.3.1 PPC (1997)