Re: Grepping a csv

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 53783
interpreted = N
texte = You are running into the "grep is greedy" concept. Is is probably finding one match for you. You might try replacing the (.*) with ([^"]*) and see if that works. Bill -----Original Message----- From: Bob Minor Sent: Mon, 3 Nov 2003 15:55:57 -0600 To: (WebDNA Talk) Subject: Grepping a csv 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/ ------------------------------------------------------------- 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)
You are running into the "grep is greedy" concept. Is is probably finding one match for you. You might try replacing the (.*) with ([^"]*) and see if that works. Bill -----Original Message----- From: Bob Minor Sent: Mon, 3 Nov 2003 15:55:57 -0600 To: (WebDNA Talk) Subject: Grepping a csv 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/ ------------------------------------------------------------- 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/ devaulw@onebox.com

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:

carriage returns in data (1997) NT or Mac (1998) inetinfo.exe (1999) Crashing bug setting an array value to blank (2003) AD Error Msg (1997) Searching Multiple Databases (2000) RE: AccountAuthorizer doesn't seem to work (1997) Plugin or CGI or both (1997) [WebDNA] current thinking on architecture of mass email scripts? (2011) problems with WebCat-Plugin (1997) Stupid question (2003) HomePage Caution (1997) WebCat2: Items xx to xx shown, etc. (1997) Show shoppingcart after remove last item (1997) syntax question, not in online refernce (1997) File Upload (1997) Checkboxes (1998) log files (1998) More OSX funkiness (2000) quotation marks needed? (2000)