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:
apostrophe in search item (1997)
webcat NT with [dos] command (1997)
Word search (1997)
searchable list archive (1997)
Search design (1997)
unable to run webcatalog locally (1998)
WebCatalog NT (1996)
PCS Emailer's role ? (1997)
Silly Question (1997)
multi-paragraph fields (1997)
limitation found on group searching (1997)
WebCatalog seems to choke on large (2meg) html files. (1998)
Help SM: Duplicate cart #'s - still! (2003)
WebCatalog for guestbook ? (1997)
PCS Customer submissions ? (1997)
RAM variables (1997)
[Announce] WebCatalog 3.0 Beta Program (1998)
[WebDNA] Timer (2009)
Unable to view next 101-200 (1997)
strange IE 4.0 (1998)