[WebDNA] Grep

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 103977
interpreted = N
texte = --_000_1F600E66EAA5A9408FF9A8ED434781A120F8C4CC7EVMBX101ihoste_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I have the following code that combines two database fields into one and re= moves extra spaces at the same time. But this seems to also be removing th= e + (plus symbol) from the data as well, which I don't want to happen. Exam= ple, the data "DVD+RW" becomes "DVD RW". Any ideas why this might be happe= ning? [!]First - Find blank Title fields and fill them in with Description1 and D= escription2 (using grep to remove extra spaces)[/!] [Search db=3Dprice2.txt&eqTitledata=3D[blank]][numfound] [ReplaceFoundItems]Title=3D[grep search=3D *$&replace=3D][Description1][/gr= ep] [grep search=3D *$&replace=3D][Description2][/grep][/ReplaceFoundItems] [/Search] --_000_1F600E66EAA5A9408FF9A8ED434781A120F8C4CC7EVMBX101ihoste_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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 + (pl= us symbol) from the data as well, which I don't want to happen. Example, the d= ata “DVD+RW” becomes “DVD RW”.  Any ideas why this might be happening?<= o:p>

 

[!]First - Find blank T= itle fields and fill them in with Description1 and Description2 (using grep to remove extra spaces)[/!]

[Search db=3Dprice2.txt&eqTitledata=3D[blank]][numfound]

[ReplaceFoundItems]Titl= e=3D[grep search=3D *$&replace=3D][Description1][/grep] [grep search=3D *$&replace=3D][Description2][/grep][/ReplaceFoundItems]

[/Search]

--_000_1F600E66EAA5A9408FF9A8ED434781A120F8C4CC7EVMBX101ihoste_-- 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. [WebDNA] grep character problem (Steve Craig 2012)
  6. Re: [WebDNA] Grep and "?" (Stuart Tremain 2012)
  7. Re: [WebDNA] Grep and "?" (Govinda 2012)
  8. [WebDNA] Grep and "?" (=?ISO-8859-1?Q?Cristi=E1n_Tapia?= 2012)
  9. [WebDNA] Grep the whole page (WebDNA Solutions 2012)
  10. Re: [WebDNA] GREP problem (Govinda 2011)
  11. Re: [WebDNA] GREP problem (Stuart Tremain 2011)
  12. Re: [WebDNA] GREP problem (Govinda 2011)
  13. Re: [WebDNA] GREP problem (William DeVaul 2011)
  14. [WebDNA] GREP problem (Stuart Tremain 2011)
  15. Re: [WebDNA] Grep problem (William DeVaul 2010)
  16. [WebDNA] Grep problem (Kenneth Grome 2010)
  17. Re: [WebDNA] GREP question (Stuart Tremain 2010)
  18. Re: [WebDNA] GREP question (Tom Duke 2010)
  19. [WebDNA] GREP question (Stuart Tremain 2010)
  20. Re: [WebDNA] Grep out square brackets? ("Dan Strong" 2010)
  21. Re: [WebDNA] Grep out square brackets? (Tom Duke 2010)
  22. Re: [WebDNA] Grep out square brackets? (Govinda 2010)
  23. Re: [WebDNA] Grep out square brackets? (Tom Duke 2010)
  24. Re: [WebDNA] Grep out square brackets? ("Dan Strong" 2010)
  25. Re: [WebDNA] Grep out square brackets? ("Terry Wilson" 2010)
  26. [WebDNA] Grep out square brackets? ("Dan Strong" 2010)
  27. Re: [WebDNA] Grep everything and replace with asterisks? ("Terry Wilson" 2010)
  28. Re: [WebDNA] Grep everything and replace with asterisks? (Govinda 2010)
  29. Re: [WebDNA] Grep everything and replace with asterisks? ("Dan Strong" 2010)
  30. Re: [WebDNA] Grep everything and replace with asterisks? (Bob Minor 2010)
  31. Re: [WebDNA] Grep everything and replace with asterisks? ("Dan Strong" 2010)
  32. Re: [WebDNA] Grep everything and replace with asterisks? (Marc Thompson 2010)
  33. Re: [WebDNA] Grep everything and replace with asterisks? ("Dan Strong" 2010)
  34. Re: [WebDNA] Grep everything and replace with asterisks? (Marc Thompson 2010)
  35. Re: [WebDNA] Grep everything and replace with asterisks? ("Dan Strong" 2010)
  36. [WebDNA] Grep everything and replace with asterisks? ("Dan Strong" 2010)
  37. Re: [WebDNA] Grep help - catch all URLs (Tom Duke 2010)
  38. Re: [WebDNA] Grep help - catch all URLs (Stuart Tremain 2010)
  39. [WebDNA] Grep help - catch all URLs (Tom Duke 2010)
  40. Re: [WebDNA] grep again (William DeVaul 2010)
  41. Re: [WebDNA] grep again (Govinda 2010)
  42. Re: [WebDNA] grep again (Brian Fries 2010)
  43. Re: [WebDNA] grep again (Bob Minor 2010)
  44. Re: [WebDNA] grep again (Kenneth Grome 2010)
  45. Re: [WebDNA] grep again (Tom Duke 2010)
  46. Re: [WebDNA] grep again (Bob Minor 2010)
  47. Re: [WebDNA] grep again (Brian Fries 2010)
  48. Re: [WebDNA] grep again (Govinda 2010)
  49. Re: [WebDNA] grep again (Kenneth Grome 2010)
  50. Re: [WebDNA] grep again (Donovan Brooke 2010)
  51. Re: [WebDNA] grep again (Brian Fries 2010)
  52. Re: [WebDNA] grep again (Bob Minor 2010)
  53. Re: [WebDNA] grep again: (how to handle replacing linefeed char?) (Govinda 2010)
  54. Re: [WebDNA] grep again (Kenneth Grome 2010)
  55. Re: [WebDNA] grep again (christophe.billiottet@webdna.us 2010)
  56. Re: [WebDNA] grep again (Kenneth Grome 2010)
  57. Re: [WebDNA] grep again (Tom Duke 2010)
  58. Re: [WebDNA] grep again (Bob Minor 2010)
  59. Re: [WebDNA] grep again (Tom Duke 2010)
  60. Re: [WebDNA] grep again (Kenneth Grome 2010)
  61. Re: [WebDNA] grep again (Bob Minor 2010)
  62. Re: [WebDNA] grep again (Kenneth Grome 2010)
  63. Re: [WebDNA] grep again (Bob Minor 2010)
  64. Re: [WebDNA] grep again (Kenneth Grome 2010)
  65. Re: [WebDNA] grep again (Bob Minor 2010)
  66. [WebDNA] grep again (Kenneth Grome 2010)
  67. RE: [WebDNA] Grep (Mark Bergkvist 2009)
  68. Re: [WebDNA] Grep (Grant Hulbert 2009)
  69. RE: [WebDNA] Grep (Mark Bergkvist 2009)
  70. Re: [WebDNA] Grep (Tom Duke 2009)
  71. Re: [WebDNA] Grep (Govinda 2009)
  72. Re: [WebDNA] Grep (Govinda 2009)
  73. Re: [WebDNA] Grep (Matthew Bohne 2009)
  74. RE: [WebDNA] Grep (Mark Bergkvist 2009)
  75. Re: [WebDNA] Grep (Govinda 2009)
  76. [WebDNA] Grep (Mark Bergkvist 2009)
  77. Re: [WebDNA] grep question (Kenneth Grome 2009)
  78. Re: [WebDNA] grep question (Stuart Tremain 2009)
  79. Re: [WebDNA] grep question (Matthew Bohne 2009)
  80. Re: [WebDNA] grep question (Kenneth Grome 2009)
  81. Re: [WebDNA] grep question (Matthew Bohne 2009)
  82. Re: [WebDNA] grep question (Kenneth Grome 2009)
  83. Re: [WebDNA] grep question (Matthew Bohne 2009)
  84. Re: [WebDNA] grep question (William DeVaul 2009)
  85. Re: [WebDNA] grep question (Stuart Tremain 2009)
  86. [WebDNA] grep question (Kenneth Grome 2009)
  87. Re: [WebDNA] grep code (William DeVaul 2009)
  88. Re: [WebDNA] grep code (christophe.billiottet@webdna.us 2009)
  89. [WebDNA] grep code (Kenneth Grome 2009)
  90. Re: [WebDNA] Grep (Marc Thompson 2009)
  91. Re: [WebDNA] Grep (Stuart Tremain 2009)
  92. Re: [WebDNA] Grep (Marc Thompson 2009)
  93. Re: [WebDNA] Grep (Bob Minor 2009)
  94. Re: [WebDNA] Grep (Toby Cox 2009)
  95. Re: [WebDNA] Grep (Marc Thompson 2009)
  96. [WebDNA] Grep ("Ki Song - Knifecenter.com" 2009)
  97. Re: [WebDNA] GREP Question (Steve Craig 2009)
  98. Re: [WebDNA] GREP Question (Tom Duke 2009)
  99. [WebDNA] GREP Question (Steve Craig 2009)
--_000_1F600E66EAA5A9408FF9A8ED434781A120F8C4CC7EVMBX101ihoste_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I have the following code that combines two database fields into one and re= moves extra spaces at the same time. But this seems to also be removing th= e + (plus symbol) from the data as well, which I don't want to happen. Exam= ple, the data "DVD+RW" becomes "DVD RW". Any ideas why this might be happe= ning? [!]First - Find blank Title fields and fill them in with Description1 and D= escription2 (using grep to remove extra spaces)[/!] [Search db=3Dprice2.txt&eqTitledata=3D[blank]][numfound] [replacefounditems]Title=3D[grep search=3D *$&replace=3D][Description1][/gr= ep] [grep search=3D *$&replace=3D][Description2][/grep][/ReplaceFoundItems] [/Search] --_000_1F600E66EAA5A9408FF9A8ED434781A120F8C4CC7EVMBX101ihoste_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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 + (pl= us symbol) from the data as well, which I don't want to happen. Example, the d= ata “DVD+RW” becomes “DVD RW”.  Any ideas why this might be happening?<= o:p>

 

[!]First - Find blank T= itle fields and fill them in with Description1 and Description2 (using grep to remove extra spaces)[/!]

[Search db=3Dprice2.txt&eqTitledata=3D[blank]][numfound]

[replacefounditems]Titl= e=3D[grep search=3D *$&replace=3D][Description1][/grep] [grep search=3D *$&replace=3D][Description2][/grep][/ReplaceFoundItems]

[/Search]

--_000_1F600E66EAA5A9408FF9A8ED434781A120F8C4CC7EVMBX101ihoste_-- 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:

Bug Report, maybe (1997) WebDNA for Dummies (2003) Multiple prices (1997) suffix mapping for NT? (1997) Formulas.db + Users.db (1997) price carry over (1997) [OT] See QT? (Was Eaaaasy FTP...) (2003) Country & Ship-to address & other fields ? (1997) [WebDNA] lists opinion - [listwords] delimiter change (2009) DON'T use old cart file! (1997) New Zealand [OT - was Car Database] (2002) Seeking Better Display of results... (1997) searchable list archive (1997) FAX orders (1996) UNSUBSCRIBE (2000) Inventory Adjustment (2000) [WebDNA] Apache configuration fail when... (2013) [date] problem with %d%m%Y (1998) Cookie still not working (1999) Interface to Quickbooks (2005)