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 any comma'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 have to do a showif for each of the characters in my sr_convertchars.db. Of course 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 database she > >uses. I made a tpl that will get the information from her main catalog and > >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 text after > >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:

    
  1. Re: Convert Chars Q (John Peacock 2000)
  2. Re: Convert Chars Q (Peter Ostry 2000)
  3. Re: Convert Chars Q (Gary J. Krockover 2000)
  4. Re: Convert Chars Q (Peter Ostry 2000)
  5. Re: Convert Chars Q (Joseph D'Andrea 2000)
  6. Re: Convert Chars Q (Gary J. Krockover 2000)
  7. Re: Convert Chars Q (Joseph D'Andrea 2000)
  8. Re: Convert Chars Q (Gary J. Krockover 2000)
  9. Re: Convert Chars Q (Joseph D'Andrea 2000)
  10. Convert Chars Q (Gary J. Krockover 2000)
Thanks for the reply Joseph, Forgive me if I'm missing something, but how will your example convert any comma'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 have to do a showif for each of the characters in my sr_convertchars.db. Of course 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 database she > >uses. I made a tpl that will get the information from her main catalog and > >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 text after > >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:

[WebDNA] Search using CL (2017) duplicate items in cart (1998) Nested tags count question (1997) Upload (1998) Yosemite and 8.1??? (1999) WebCat and image maps (1997) TeaRoom Order fields email account remain empty even thoughthewy are filled. (1997) Nested tags count question (1997) Merging databases (1997) [OT] SubserviantChicken.com (2004) RE: textA and Title? (1997) Document Contains No Data (1998) Fwd: XML - USPS Lookups - UPS Lookups (2003) PGP encrypted email (1998) Dreamweaver noedit ??? (2005) Opinion: [input] should be called [output] ... (1997) Comments in db? (1997) FEW QUESTIONS (1997) ImageMagick on OSX (2003) syntax question, not in online refernce (1997)