Re: Removing a character
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 27920
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 Consultant>>Good 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.)I don't remember the code the other person posted as an answer to your question, but here's my first thought:[spawn][search][founditems][showif [given]~0][text]newValue=[getchars start=2][given][/getchars][/text][text]loopCount=[countchars][newValue][/countchars][/text][loop start=1&end=[loopCount]][showif [newValue]~0][text]newValue=[getchars start=2][newValue][/getchars][/text][/showif][/loop][replace db=some.db&eqskudatarq=[sku]&max=1]whatYouWant=[numericField][newValue][/replace][/showif][/founditems][/search][/spawn]================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================-------------------------------------------------------------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 then>on?>>>> Kenneth Grome, WebDNA Consultant>>Good 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.)I don't remember the code the other person posted as an answer to your question, but here's my first thought:[spawn][search][founditems][showif [given]~0][text]newValue=[getchars start=2][given][/getchars][/text][text]loopCount=[countchars][newValue][/countchars][/text][loop start=1&end=[loopCount]][showif [newValue]~0][text]newValue=[getchars start=2][newValue][/getchars][/text][/showif][/loop][replace db=some.db&eqskudatarq=[sku]&max=1]whatYouWant=[numericField][newValue][/replace][/showif][/founditems][/search][/spawn]================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================-------------------------------------------------------------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
Kenneth Grome
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:
WordBreak Qestion (1998)
OT: javascript for dynamic pulldowns? (1998)
Nested tags count question (1997)
Quantity (1998)
Webstar V and Webcatalog (2001)
Can anyone help me with this shipping thing? (1998)
Grep issue (2003)
[OT] Robust order processing (2003)
PIXO (1997)
[shell] (2002)
[HIDEIF] inside [FOUNDITEM] (1997)
[OT] Mystery Autoreply (2004)
webcat2b12 CGI -- Date comparisons (1997)
RE: pricing continued (1998)
f2 download problems (1997)
suffix mapping, use of cache, etc. (1997)
NT IIS number of files limit (2003)
checksum for Discover credit cards (1999)
cookies (2001)
RE:formula.db problems (1999)