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:
EIMS Problems (1997)
OT: CT Scan might have saved my life!! (2006)
Re:2nd WebCatalog2 Feature Request (1996)
[protect] (1998)
Re:2nd WebCatalog2 Feature Request (1996)
[OT]: BBEdit grep (2003)
MacFinder -- a new WebDNA web site (1998)
Db design question (relational vs. flat?) (1998)
using showpage and showcart commands (1996)
There's a bug in the math context ... (1997)
Dynamically Generated Pages & WC? (2000)
Was cart limit-- Limits (2002)
[WebDNA] Some code inside a large loops fail ... but why? (2010)
E-Mailer (WebCatb15acgiMac) (1997)
4.0.2b5 not finding databases under load (2000)
Include a big block of text (1997)
off topic fetch vs PCS photomaster (1997)
[random] only for 1-100??? (1997)
same products but different (1998)
Problems with [Applescript] (1997)