Grepping a csv

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 53781
interpreted = N
texte = this is my search/replace in bbedit. Its not working in webdna, any ideas? grep search=(")(.*)(")(,)(")(.*)(")(,)(")(.*)(")(,)(.*)(,)(.*)(,)(.*)(,)(.*\r )&replace=\2\t\6\t\10\t\13\t\15\t\17\t\19 Sample data: "122101000603 ","League Excellence ","CARD",2.0,.0,.0,2.00 "122101000702 ","Short Stop Ringer Tee ","CARD",3.0,.0,.0,3.00 "122101000703 ","Short Stop Ringer Tee ","CARD",3.0,.0,.0,3.00 "122101000704 ","Short Stop Ringer Tee ","CARD",.0,.0,.0,0.00 "122101000705 ","Short Stop Ringer Tee ","CARD",1.0,.0,.0,1.00 Robert Minor Director of Internet Services ------------------------------------------------------------ Cybermill Communications http://www.cybermill.com http://www.merchantmaker.com Providing Ecommerce and interactive website development and hosting services on Macintosh, Windows NT, *nix, and AS/400. ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Grepping a csv ( William DeVaul 2003)
  2. Re: Grepping a csv ( Rob Marquardt 2003)
  3. Re: Grepping a csv ( Bob Minor 2003)
  4. Re: Grepping a csv ( devaulw@onebox.com 2003)
  5. Grepping a csv ( Bob Minor 2003)
this is my search/replace in bbedit. Its not working in webdna, any ideas? grep search=(")(.*)(")(,)(")(.*)(")(,)(")(.*)(")(,)(.*)(,)(.*)(,)(.*)(,)(.*\r )&replace=\2\t\6\t\10\t\13\t\15\t\17\t\19 Sample data: "122101000603 ","League Excellence ","CARD",2.0,.0,.0,2.00 "122101000702 ","Short Stop Ringer Tee ","CARD",3.0,.0,.0,3.00 "122101000703 ","Short Stop Ringer Tee ","CARD",3.0,.0,.0,3.00 "122101000704 ","Short Stop Ringer Tee ","CARD",.0,.0,.0,0.00 "122101000705 ","Short Stop Ringer Tee ","CARD",1.0,.0,.0,1.00 Robert Minor Director of Internet Services ------------------------------------------------------------ Cybermill Communications http://www.cybermill.com http://www.merchantmaker.com Providing Ecommerce and interactive website development and hosting services on Macintosh, Windows NT, *nix, and AS/400. ------------------------------------------------------------- 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://webdna.smithmicro.com/ Bob Minor

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:

Multiple Newcarts (1996) unable to launch acgi in WebCat (1997) Sorting by highest number of matches unique to a field (2003) Online reference (1997) Setting up shop (1997) Credit card types (1997) [Sum] function? (1997) Cookie set browser session. (1998) Summ=T Problem (1997) WebCat & Liststar (1997) [WebDNA] CORRECTION: 60% failure rate using replace in a loop (2010) Rename folder under WC3 (2000) Tried installing Windows beta with no success... (2000) Header info in content (1998) Adding Message to Order (1997) 911: testing if the field is empty (2000) GuestBook example (1997) Ampersand Character (&) (1997) WebCatalog [FoundItems] Problem - AGAIN - (1997) Exclamation point (1997)