Convert Chars Q
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 35854
interpreted = N
texte = Hi all,I have a client that has opted to have her products co-listed onStoreRunner.com. StoreRunner (SR) requires a CSV format of the database sheuses. I made a tpl that will get the information from her main catalog anddo a price lookup to her other database and then compile it into atab-delimited database. It works fine. I'm now trying to get fancy andinstead of her having to change comma's in the database to another unusedcharacter, and then import that into Excel, clean up what needs to be &convert the file to a CSV & then open the CSV in BBEdit and change theunused characters to , -I'm trying to have this CSV database builderconvert the comma's for her. The ConvertChars is cutting off all text afterit finds the To character though. Any help would be appreciated! Webcat3.08:Here's the CSV database builder (breaks caused by email-comments added atbreakpoints):[deletefile file=storerunner.db][COPYFILE from=storerunner_backup.db&to=storerunner.db][search db=catalog.txt&neakudatarq=[blank]&akusort=1&akusdir=as&akutype=num][FOUNDITEMS][textshow=F]pageurl=[url][raw]http://www.mellingers.com/results.tpl?command=search&db=catalog.txt&eqakudatarq=[/raw][/url][/text][!]Uncomment the next line to test the price hide feature[/!][lookup db=products.txt&lookinField=aku&value=[AKU]&returnField=price-each][showif [price-each]!][REPLACE DB=storerunner.db&eqAKUdatarq=[AKU]&append=T][!][/!]sku=[AKU][!][/!][showif [Title]!]&Title=[ConvertCharsdb=sr_convertchars.db][Title][/ConvertChars][/showif][showif[Title]=]&Title=[lookupdb=catalog.txt&lookinField=aku&value=[Slave_to]&returnField=[ConvertCharsdb=sr_convertchars.db]Title[/ConvertChars]][/showif][!][/!]&URL=[pageurl][aku][!][/!]&Price=[lookupdb=products.txt&lookinField=aku&value=[AKU]&returnField=price-each][!][/!][showif [Category]!]&Category=[ConvertCharsdb=sr_convertchars.db][category][/ConvertChars][/showif][showif[Category]=]&Category=[lookupdb=catalog.txt&lookinField=aku&value=[Slave_to]&returnField=[ConvertCharsdb=sr_convertchars.db]category[/ConvertChars]][/showif][!][/!]&Description=[ConvertCharsdb=sr_convertchars.db][description][/ConvertChars][!][/!]&IsDiscounted=[Specials][!][/!]&Keyword1=[ConvertCharsdb=sr_convertchars.db][tagline][/ConvertChars][!][/!]&Keyword2=[ConvertCharsdb=sr_convertchars.db][tagline2][/ConvertChars][!][/!]&ImageURL=[hideif[photo_name]=][raw]http://www.mellingers.com/GSImages/thumbnails/[/raw][url][photo_name][/url][/hideif][!][/!][/REPLACE][/showif][/FOUNDITEMS][/SEARCH]Here's the sr_convertchars.db file:from
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 Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hi all,I have a client that has opted to have her products co-listed onStoreRunner.com. StoreRunner (SR) requires a CSV format of the database sheuses. I made a tpl that will get the information from her main catalog anddo a price lookup to her other database and then compile it into atab-delimited database. It works fine. I'm now trying to get fancy andinstead of her having to change comma's in the database to another unusedcharacter, and then import that into Excel, clean up what needs to be &convert the file to a CSV & then open the CSV in BBEdit and change theunused characters to , -I'm trying to have this CSV database builderconvert the comma's for her. The ConvertChars is cutting off all text afterit finds the To character though. Any help would be appreciated! Webcat3.08:Here's the CSV database builder (breaks caused by email-comments added atbreakpoints):[deletefile file=storerunner.db][COPYFILE from=storerunner_backup.db&to=storerunner.db][search db=catalog.txt&neakudatarq=[blank]&akusort=1&akusdir=as&akutype=num][founditems][textshow=F]pageurl=[url][raw]http://www.mellingers.com/results.tpl?command=search&db=catalog.txt&eqakudatarq=[/raw][/url][/text][!]Uncomment the next line to test the price hide feature[/!][lookup db=products.txt&lookinField=aku&value=[AKU]&returnField=price-each][showif [price-each]!][REPLACE DB=storerunner.db&eqAKUdatarq=[AKU]&append=T][!][/!]sku=[AKU][!][/!][showif [Title]!]&Title=[ConvertCharsdb=sr_convertchars.db][Title][/ConvertChars][/showif][showif[Title]=]&Title=[lookupdb=catalog.txt&lookinField=aku&value=[Slave_to]&returnField=[ConvertCharsdb=sr_convertchars.db]Title[/ConvertChars]][/showif][!][/!]&URL=[pageurl][aku][!][/!]&Price=[lookupdb=products.txt&lookinField=aku&value=[AKU]&returnField=price-each][!][/!][showif [Category]!]&Category=[ConvertCharsdb=sr_convertchars.db][category][/ConvertChars][/showif][showif[Category]=]&Category=[lookupdb=catalog.txt&lookinField=aku&value=[Slave_to]&returnField=[ConvertCharsdb=sr_convertchars.db]category[/ConvertChars]][/showif][!][/!]&Description=[ConvertCharsdb=sr_convertchars.db][description][/ConvertChars][!][/!]&IsDiscounted=[Specials][!][/!]&Keyword1=[ConvertCharsdb=sr_convertchars.db][tagline][/ConvertChars][!][/!]&Keyword2=[ConvertCharsdb=sr_convertchars.db][tagline2][/ConvertChars][!][/!]&ImageURL=[hideif[photo_name]=][raw]http://www.mellingers.com/GSImages/thumbnails/[/raw][url][photo_name][/url][/hideif][!][/!][/REPLACE][/showif][/FOUNDITEMS][/SEARCH]Here's the sr_convertchars.db file:from 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 Web Archive of this list is at: http://search.smithmicro.com/
Gary J. Krockover
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:
Old & New? (2003)
UnitShopCost (2007)
Encrypt & SetHeader Length Problem (2000)
grep question - how to strip spaces from the beginning ofa string? (2002)
WebCatalog 2.1b4/Mac available (1997)
Re:E-Mailer (WebCatb15acgiMac) (1997)
wild question (1998)
Nesting searches. (1998)
PCS Frames-Default page is solution! (1997)
wrong input values? (1997)
WebCat2 - many [carts] on one template page? (1997)
WebCatalog2 Feature Feedback (1996)
Talk List Suggestions (1997)
cart (1997)
setitems, one more thing (1997)
SiteEdit NewFile.html ? (1997)
Errata: WCS Newbie question (1997)
Document Contains No Data! (1997)
Webcat2, WebCommerce, Mod 10 etc. (1997)
READFILE command? (1998)