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:

Locking up with WebCatalog... (1997) chicken / egg::purchase / setheader (2002) UPS/FEDEX/OTHER Ship lookups available?? (1998) Merging databases (1997) Search probl. since change WebCatalog from 2.1.3 to 3.0 (1998) RE: WebCat cannot handle compatible search parameters? (1997) Help with [LineItems] in [OrderFile] on ShoppingCart.tpl (2003) Hard Questions ? (1997) [WebDNA] API Integration (2010) tab deliminated txt file (2001) WebCatalog stalls (1998) File dates in WebCatalog .tmpl/.inc (1997) Disappearing Database (1998) The List is Changing (1997) Cookies and webcat (1997) RE: ShowNext Command (1997) price on detail, but not shoppingcart (1997) Windows nt service pack 3 upgrade (1997) [format 40s]text[/format] doesn't work (1997) Revisit: speed test (2002)