Re: Linebreak as a delimiter in listwords?
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 49601
interpreted = N
texte = Rob's way is cleaner.On Thu, 17 Apr 2003 10:57:04 Dan Strong
wrote:>*UNTESTED*>>=====================>[search db=persons.db&nenamedatarq=[blank]&namesort=1&namesdir=as]> [founditems]> [ListWords Words=[name]&delimiters=,]> [showif [index]=1][text show=f]LAST_NAME=[word][/text][/showif]> [showif [index]=2][text show=f]FIRST_NAME=[word][/text][/showif]> [/ListWords]> [append db=personsfinal.db]LASTNAME=[LAST_NAME]&FIRSTNAME=[FIRST_NAME][/append]> [/founditems]>[/search]>=====================>>-Dan>------------------------------------------------------------>http://www.StrongGraphicDesign.com>(208) 319-0137 | Toll-free p/f 877-561-1656>------------------------------------------------------------>>>>>>>>On Thu, 17 Apr 2003 12:34:58> Gary Krockover wrote:>>Ok, I give....>>>>If I have a list of names in the format of:>>>>Adams, John>>>>How can I get that to append to a new db in the format of:>>>>LASTNAME FIRSTNAME>>Adams John>>>>?>>>>I have this, and it almost works except that the firstname and lastname are>>on seperate rows of the db:>>>>[search db=persons.db&nenamedatarq=[blank]&namesort=1&namesdir=as]>>[founditems]>>[ListWords Words=[name]&delimiters=,]>>[index]: [word]
>>[append db=personsfinal.db][!]>>[/!]lastname=[showif [index]=1][word][/showif][!]>>[/!]&firstname=[showif [index]=2][word][/showif][!]>>[/!][/append]>>[/ListWords]>>[/founditems]>>[/search]>>>>GK>>>>>>-----Original Message----->>From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of>>Gary Krockover>>Sent: Thursday, April 17, 2003 11:31 AM>>To: WebDNA Talk>>Subject: Re: Linebreak as a delimiter in listwords?>>>>>>OH!>>>>An email from Donovan from yesterday was open in my email, so his name just>>happened to make my list of sample names. The middle initial with the>>period made for a good test too.>>>>GK>>>>-----Original Message----->>From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of>>Nitai @ ComputerOil>>Sent: Thursday, April 17, 2003 11:22 AM>>To: WebDNA Talk>>Subject: Re: Linebreak as a delimiter in listwords?>>>>>>On 17.4.2003 18:09 Uhr, Charles Kline wrote:>>>>>I don't know how many times I have posted questions to lists only to>>>figure out the answer ALMOST immediately afterwards... a phenomenon??>>>>Yup it is. But I was more relating to Gary's subcomment from his original>>post that was something like And no, I don't know how Donovan got on my>>list.>>>>Sincerely,>>Nitai Aventaggiato>>CEO>>>>-->>Tools to energize your business>>Content Management & eBusiness Systems>>>>ComputerOil? GmbH http://computeroil.com/>>Unionstrasse 4 info@computeroil.com>>8032 Zürich/Switzerland>>Tel: +41 (0)43 333 1 555>>>>>>------------------------------------------------------------->>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>>>>Web Archive of this list is at: http://webdna.smithmicro.com/>>>>>>------------------------------------------------------------->>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 >>Web Archive of this list is at: http://webdna.smithmicro.com/>>------------------------------------------------------------->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 >Web Archive of this list is at: http://webdna.smithmicro.com/------------------------------------------------------------http://www.StrongGraphicDesign.com(208) 319-0137 | Toll-free p/f 877-561-1656-------------------------------------------------------------------------------------------------------------------------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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Rob's way is cleaner.On Thu, 17 Apr 2003 10:57:04 Dan Strong wrote:>*UNTESTED*>>=====================>[search db=persons.db&nenamedatarq=[blank]&namesort=1&namesdir=as]> [founditems]> [ListWords Words=[name]&delimiters=,]> [showif [index]=1][text show=f]LAST_NAME=[word][/text][/showif]> [showif [index]=2][text show=f]FIRST_NAME=[word][/text][/showif]> [/ListWords]> [append db=personsfinal.db]LASTNAME=[LAST_NAME]&FIRSTNAME=[FIRST_NAME][/append]> [/founditems]>[/search]>=====================>>-Dan>------------------------------------------------------------>http://www.StrongGraphicDesign.com>(208) 319-0137 | Toll-free p/f 877-561-1656>------------------------------------------------------------>>>>>>>>On Thu, 17 Apr 2003 12:34:58> Gary Krockover wrote:>>Ok, I give....>>>>If I have a list of names in the format of:>>>>Adams, John>>>>How can I get that to append to a new db in the format of:>>>>LASTNAME FIRSTNAME>>Adams John>>>>?>>>>I have this, and it almost works except that the firstname and lastname are>>on seperate rows of the db:>>>>[search db=persons.db&nenamedatarq=[blank]&namesort=1&namesdir=as]>>[founditems]>>[ListWords Words=[name]&delimiters=,]>>[index]: [word]
>>[append db=personsfinal.db][!]>>[/!]lastname=[showif [index]=1][word][/showif][!]>>[/!]&firstname=[showif [index]=2][word][/showif][!]>>[/!][/append]>>[/ListWords]>>[/founditems]>>[/search]>>>>GK>>>>>>-----Original Message----->>From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of>>Gary Krockover>>Sent: Thursday, April 17, 2003 11:31 AM>>To: WebDNA Talk>>Subject: Re: Linebreak as a delimiter in listwords?>>>>>>OH!>>>>An email from Donovan from yesterday was open in my email, so his name just>>happened to make my list of sample names. The middle initial with the>>period made for a good test too.>>>>GK>>>>-----Original Message----->>From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of>>Nitai @ ComputerOil>>Sent: Thursday, April 17, 2003 11:22 AM>>To: WebDNA Talk>>Subject: Re: Linebreak as a delimiter in listwords?>>>>>>On 17.4.2003 18:09 Uhr, Charles Kline wrote:>>>>>I don't know how many times I have posted questions to lists only to>>>figure out the answer ALMOST immediately afterwards... a phenomenon??>>>>Yup it is. But I was more relating to Gary's subcomment from his original>>post that was something like And no, I don't know how Donovan got on my>>list.>>>>Sincerely,>>Nitai Aventaggiato>>CEO>>>>-->>Tools to energize your business>>Content Management & eBusiness Systems>>>>ComputerOil? GmbH http://computeroil.com/>>Unionstrasse 4 info@computeroil.com>>8032 Zürich/Switzerland>>Tel: +41 (0)43 333 1 555>>>>>>------------------------------------------------------------->>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>>>>Web Archive of this list is at: http://webdna.smithmicro.com/>>>>>>------------------------------------------------------------->>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 >>Web Archive of this list is at: http://webdna.smithmicro.com/>>------------------------------------------------------------->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 >Web Archive of this list is at: http://webdna.smithmicro.com/------------------------------------------------------------http://www.StrongGraphicDesign.com(208) 319-0137 | Toll-free p/f 877-561-1656-------------------------------------------------------------------------------------------------------------------------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 Web Archive of this list is at: http://webdna.smithmicro.com/
Dan Strong
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:
3RD POST Character limit in [Search]? (1998)
Pull down menu for categories (2000)
A Global Variable (1997)
showif and cart (1997)
WC2.0 Memory Requirements (1997)
Thanks Grant (1997)
WebCat2b12plugin - [search] is broken ... not! (1997)
WebCat2: Items xx to xx shown, etc. (1997)
[BoldWords] WebCat.acgib15Mac (1997)
PCS Frames (1997)
Stop the madness. (1997)
any idea (2004)
wc 2 pro users - sites, quotes wanted (1997)
WebCat2b12--[searchstring] bug (1997)
WebCat2 - Getting to the browser's username/password data (1997)
programmer help needed (1998)
breaking words (1997)
Trouble Searching (1999)
corrupted jpgs (2003)
Search in 2 or more catalogs (1997)