Re: Convert Chars Q
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 35857
interpreted = N
texte = Thanks for the reply Joseph,Forgive me if I'm missing something, but how will your example convert anycomma's it finds to , for the append to the CSV database?Also, I figured this is what the ConvertChars was for anyways, as I'd haveto do a showif for each of the characters in my sr_convertchars.db. Ofcourse the main one that I'm concerned with is the comma.G.> At 7:54 PM 8/7/00, Gary J. Krockover wrote:> >Hi all,> >I have a client that has opted to have her products co-listed on> >StoreRunner.com. StoreRunner (SR) requires a CSV format of the databaseshe> >uses. I made a tpl that will get the information from her main catalogand> >do a price lookup to her other database and then compile it into a> >tab-delimited database. It works fine. I'm now trying to get fancy and> >instead of her having to change comma's in the database to another unused> >character, 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 the> >unused characters to , -I'm trying to have this CSV database builder> >convert the comma's for her. The ConvertChars is cutting off all textafter> >it finds the To character though. Any help would be appreciated!Webcat>> Instead of doing it how you're doing it, wouldn't it be wasier to> test each field and if it contains a comma, then surround it in> quotes?>>> In otherwords... do whatever you need to do to get the fields of the> record you want to output. Then on the fields that might contain a> comma do something like this: (not testes)>> [showif [field1]^,]> [text]field1=[field1]]> [/showif]>>> Then do:>> [appendfile file=name.csv][field1],[field2], ..... [/append]>> Or am I missing something?-------------------------------------------------------------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:
Thanks for the reply Joseph,Forgive me if I'm missing something, but how will your example convert anycomma's it finds to , for the append to the CSV database?Also, I figured this is what the ConvertChars was for anyways, as I'd haveto do a showif for each of the characters in my sr_convertchars.db. Ofcourse the main one that I'm concerned with is the comma.G.> At 7:54 PM 8/7/00, Gary J. Krockover wrote:> >Hi all,> >I have a client that has opted to have her products co-listed on> >StoreRunner.com. StoreRunner (SR) requires a CSV format of the databaseshe> >uses. I made a tpl that will get the information from her main catalogand> >do a price lookup to her other database and then compile it into a> >tab-delimited database. It works fine. I'm now trying to get fancy and> >instead of her having to change comma's in the database to another unused> >character, 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 the> >unused characters to , -I'm trying to have this CSV database builder> >convert the comma's for her. The ConvertChars is cutting off all textafter> >it finds the To character though. Any help would be appreciated!Webcat>> Instead of doing it how you're doing it, wouldn't it be wasier to> test each field and if it contains a comma, then surround it in> quotes?>>> In otherwords... do whatever you need to do to get the fields of the> record you want to output. Then on the fields that might contain a> comma do something like this: (not testes)>> [showif [field1]^,]> [text]field1=[field1]]> [/showif]>>> Then do:>> [appendfile file=name.csv][field1],[field2], ..... [/append]>> Or am I missing something?-------------------------------------------------------------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:
OS X permissions to write to Globals directory (2003)
carriage returns in data (1997)
syntax question, not in online refernce (1997)
[format xs] freeze (1997)
WebCat2b12 CGI Mac -- Problems propagating the cart through frames...still (1997)
many-to-one problem (1998)
Mass Mail (2000)
re: [addlineitem] working almost (1997)
Old code new problem? (2004)
problems with 2 tags (1997)
WebMerchant 1.6 and SHTML (1997)
linetiems in thankyou.tpl (1997)
PIXO (1997)
Thanks ! (1997)
Beta 3.0.3 fix for serial# problem (Mac) (1998)
Hiding HTML and page breaks (1997)
combining strings (1997)
Too many wrong answers! (1998)
[Listfiles] vs Netfinder (1997)
Showif, Hideif reverse logic ? (1997)