RE: [WebDNA] Grep

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 103979
interpreted = N
texte = Sorry, I should have gave a more complete example. Description1 =3D "25PK DVD+RW 16X 4.7GB " Description2 =3D "BRANDED SPINDLE " So the code works well for removing the extra spaces, but still seems to re= move the + sign. The result I get is Title =3D "25PK DVD RW 16X 4.7GB BRANDED SPINDL= E" -----Original Message----- From: Govinda [mailto:govinda.webdnatalk@gmail.com] Sent: Tuesday, November 10, 2009 10:22 AM To: talk@webdna.us Subject: Re: [WebDNA] Grep > I have the following code that combines two database fields into one > and removes extra spaces at the same time. But this seems to also > be removing the + (plus symbol) from the data as well, which I don't > want to happen. Example, the data "DVD+RW" becomes "DVD RW". Any > ideas why this might be happening? > > [!]First - Find blank Title fields and fill them in with > Description1 and Description2 (using grep to remove extra spaces)[/!] > [Search db=3Dprice2.txt&eqTitledata=3D[blank]][numfound] > [ReplaceFoundItems]Title=3D[grep search=3D *$&replace=3D][Description1][/ > grep] [grep search=3D *$&replace=3D][Description2][/grep][/ > ReplaceFoundItems] > [/Search] This worked for me: (removes all spaces and leaves plus signs intact. [grep search=3D[URL][ ]+[/URL]&replace=3D]DVD + RW[/grep] (I don't know enough about the differences between BBedit's grep engine and webdna's to know why the asterick did not work for finding 'zero or instances of', thus my use of the + char. ------------ Govinda govinda.webdnatalk@gmail.com --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us old archives: http://dev.webdna.us/TalkListArchive/ Bug Reporting: http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D= 288 Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] grep character problem (Steve Craig 2012)
  2. Re: [WebDNA] grep character problem (Tom Duke 2012)
  3. Re: [WebDNA] grep character problem (Steve Craig 2012)
  4. Re: [WebDNA] grep character problem (Tom Duke 2012)
  5. Re: [WebDNA] Grep and "?" (Stuart Tremain 2012)
  6. Re: [WebDNA] Grep and "?" (Govinda 2012)
  7. Re: [WebDNA] GREP problem (Govinda 2011)
  8. Re: [WebDNA] GREP problem (Stuart Tremain 2011)
  9. Re: [WebDNA] GREP problem (Govinda 2011)
  10. Re: [WebDNA] GREP problem (William DeVaul 2011)
  11. Re: [WebDNA] Grep problem (William DeVaul 2010)
  12. Re: [WebDNA] GREP question (Stuart Tremain 2010)
  13. Re: [WebDNA] GREP question (Tom Duke 2010)
  14. Re: [WebDNA] Grep out square brackets? ("Dan Strong" 2010)
  15. Re: [WebDNA] Grep out square brackets? (Tom Duke 2010)
  16. Re: [WebDNA] Grep out square brackets? (Govinda 2010)
  17. Re: [WebDNA] Grep out square brackets? (Tom Duke 2010)
  18. Re: [WebDNA] Grep out square brackets? ("Dan Strong" 2010)
  19. Re: [WebDNA] Grep out square brackets? ("Terry Wilson" 2010)
  20. Re: [WebDNA] Grep everything and replace with asterisks? ("Terry Wilson" 2010)
  21. Re: [WebDNA] Grep everything and replace with asterisks? (Govinda 2010)
  22. Re: [WebDNA] Grep everything and replace with asterisks? ("Dan Strong" 2010)
  23. Re: [WebDNA] Grep everything and replace with asterisks? (Bob Minor 2010)
  24. Re: [WebDNA] Grep everything and replace with asterisks? ("Dan Strong" 2010)
  25. Re: [WebDNA] Grep everything and replace with asterisks? (Marc Thompson 2010)
  26. Re: [WebDNA] Grep everything and replace with asterisks? ("Dan Strong" 2010)
  27. Re: [WebDNA] Grep everything and replace with asterisks? (Marc Thompson 2010)
  28. Re: [WebDNA] Grep everything and replace with asterisks? ("Dan Strong" 2010)
  29. Re: [WebDNA] Grep help - catch all URLs (Tom Duke 2010)
  30. Re: [WebDNA] Grep help - catch all URLs (Stuart Tremain 2010)
  31. Re: [WebDNA] grep again (William DeVaul 2010)
  32. Re: [WebDNA] grep again (Govinda 2010)
  33. Re: [WebDNA] grep again (Brian Fries 2010)
  34. Re: [WebDNA] grep again (Bob Minor 2010)
  35. Re: [WebDNA] grep again (Kenneth Grome 2010)
  36. Re: [WebDNA] grep again (Tom Duke 2010)
  37. Re: [WebDNA] grep again (Bob Minor 2010)
  38. Re: [WebDNA] grep again (Brian Fries 2010)
  39. Re: [WebDNA] grep again (Govinda 2010)
  40. Re: [WebDNA] grep again (Kenneth Grome 2010)
  41. Re: [WebDNA] grep again (Donovan Brooke 2010)
  42. Re: [WebDNA] grep again (Brian Fries 2010)
  43. Re: [WebDNA] grep again (Bob Minor 2010)
  44. Re: [WebDNA] grep again: (how to handle replacing linefeed char?) (Govinda 2010)
  45. Re: [WebDNA] grep again (Kenneth Grome 2010)
  46. Re: [WebDNA] grep again (christophe.billiottet@webdna.us 2010)
  47. Re: [WebDNA] grep again (Kenneth Grome 2010)
  48. Re: [WebDNA] grep again (Tom Duke 2010)
  49. Re: [WebDNA] grep again (Bob Minor 2010)
  50. Re: [WebDNA] grep again (Tom Duke 2010)
  51. Re: [WebDNA] grep again (Kenneth Grome 2010)
  52. Re: [WebDNA] grep again (Bob Minor 2010)
  53. Re: [WebDNA] grep again (Kenneth Grome 2010)
  54. Re: [WebDNA] grep again (Bob Minor 2010)
  55. Re: [WebDNA] grep again (Kenneth Grome 2010)
  56. Re: [WebDNA] grep again (Bob Minor 2010)
  57. RE: [WebDNA] Grep (Mark Bergkvist 2009)
  58. Re: [WebDNA] Grep (Grant Hulbert 2009)
  59. RE: [WebDNA] Grep (Mark Bergkvist 2009)
  60. Re: [WebDNA] Grep (Tom Duke 2009)
  61. Re: [WebDNA] Grep (Govinda 2009)
  62. Re: [WebDNA] Grep (Govinda 2009)
  63. Re: [WebDNA] Grep (Matthew Bohne 2009)
  64. RE: [WebDNA] Grep (Mark Bergkvist 2009)
  65. Re: [WebDNA] Grep (Govinda 2009)
  66. Re: [WebDNA] grep question (Kenneth Grome 2009)
  67. Re: [WebDNA] grep question (Stuart Tremain 2009)
  68. Re: [WebDNA] grep question (Matthew Bohne 2009)
  69. Re: [WebDNA] grep question (Kenneth Grome 2009)
  70. Re: [WebDNA] grep question (Matthew Bohne 2009)
  71. Re: [WebDNA] grep question (Kenneth Grome 2009)
  72. Re: [WebDNA] grep question (Matthew Bohne 2009)
  73. Re: [WebDNA] grep question (William DeVaul 2009)
  74. Re: [WebDNA] grep question (Stuart Tremain 2009)
  75. Re: [WebDNA] grep code (William DeVaul 2009)
  76. Re: [WebDNA] grep code (christophe.billiottet@webdna.us 2009)
  77. Re: [WebDNA] Grep (Marc Thompson 2009)
  78. Re: [WebDNA] Grep (Stuart Tremain 2009)
  79. Re: [WebDNA] Grep (Marc Thompson 2009)
  80. Re: [WebDNA] Grep (Bob Minor 2009)
  81. Re: [WebDNA] Grep (Toby Cox 2009)
  82. Re: [WebDNA] Grep (Marc Thompson 2009)
  83. Re: [WebDNA] GREP Question (Steve Craig 2009)
  84. Re: [WebDNA] GREP Question (Tom Duke 2009)
Sorry, I should have gave a more complete example. Description1 =3D "25PK DVD+RW 16X 4.7GB " Description2 =3D "BRANDED SPINDLE " So the code works well for removing the extra spaces, but still seems to re= move the + sign. The result I get is Title =3D "25PK DVD RW 16X 4.7GB BRANDED SPINDL= E" -----Original Message----- From: Govinda [mailto:govinda.webdnatalk@gmail.com] Sent: Tuesday, November 10, 2009 10:22 AM To: talk@webdna.us Subject: Re: [WebDNA] Grep > I have the following code that combines two database fields into one > and removes extra spaces at the same time. But this seems to also > be removing the + (plus symbol) from the data as well, which I don't > want to happen. Example, the data "DVD+RW" becomes "DVD RW". Any > ideas why this might be happening? > > [!]First - Find blank Title fields and fill them in with > Description1 and Description2 (using grep to remove extra spaces)[/!] > [Search db=3Dprice2.txt&eqTitledata=3D[blank]][numfound] > [replacefounditems]Title=3D[grep search=3D *$&replace=3D][Description1][/ > grep] [grep search=3D *$&replace=3D][Description2][/grep][/ > ReplaceFoundItems] > [/Search] This worked for me: (removes all spaces and leaves plus signs intact. [grep search=3D[url][ ]+[/URL]&replace=3D]DVD + RW[/grep] (I don't know enough about the differences between BBedit's grep engine and webdna's to know why the asterick did not work for finding 'zero or instances of', thus my use of the + char. ------------ Govinda govinda.webdnatalk@gmail.com --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us old archives: http://dev.webdna.us/TalkListArchive/ Bug Reporting: http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D= 288 Mark Bergkvist

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:

anyone integrated inventory w/ storebuilder? (2003) Help with Repost Data msg from form (1997) searching by date (1998) WebCat2 as a chat server? (1997) Encrypt Users.db problem (1998) Math with Time (1997) Resume Catalog ? (1997) includes and cart numbers (1997) OT: Backup Strategies (2007) Max Record length restated as maybe bug (1997) possible, WebCat2.0 and checkboxes-restated (1997) Requiring that certain fields be completed (1997) Setting up shop (1997) AppleShare IP 6.1 (1998) Verifying and adding new users (1997) Tax Collection for Different Items (2003) Sorting Dates in a search (2000) textarea to page display (1998) Great product and great job ! (1997) StoreBuilder/SiteBuilder (2005)