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:

question on [delete] (1998) WC1.6 to WC2 date formatting -FIXED! (1997) E-mailer error codes (1997) Format of Required fields error message (1997) Typhoon Rev. and PCS store problems (1999) ErrorMessages.db (1998) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) emailer (1997) Help name our technology! (1997) [include] error message (was:how to put/keep product customization info in basket?) (1998) searching multiple databases (1997) Denying access by IP address (2000) [Announce] Newest Commerce Site based on WebCatalog (1997) service stop and restart (1997) WebCat2: Items xx to xx shown, etc. (1997) [quantity] solved (1997) FYI: virus alert (1996) Date and Time Math (1997) [ShowNext] feature in 2.0 (1997) redirect within the ErrorMessages.db (2003)