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:

Re(2): Append command (1999) RE: type 2 errors with ssl server (1997) DON'T use old cart file! (1997) ups calculator (2000) Correct me if I'm wrong... (2000) Caching [include] files ... (1997) Memory Error message (1998) emailer prob (1998) bug in wn searching NT version? (1997) WebCatalog Hosting (1998) WebCatalog2 Feature Feedback (1996) Setting up WebCatalog with Retail Pro data (1996) Shipping calculations (1997) creator code (1997) Help formatting search results w/ table (1997) [WriteFile] problems (1997) taxTotal, grandTotal (1997) [Webcat 2]Next (1997) EMailFolder will not send (2003) UPDATE PROBLEM (1997)