Re: [WebDNA] grep character problem

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 109215
interpreted = N
texte = --000e0ce0b2d47a62c304c284fe91 Content-Type: text/plain; charset=UTF-8 Steve, I have dealt with a similar problem using a different HTML editor (Xstandard). I use the following table to clean data before being added to a db. [!] ------------------------------------ ### Clear out dodgy characters from being added to dbs ### %0D%0A - CR/LF - carriage return/linefeed %09 - horizontal (i.e. standard) tab %C2%A0 - non-breaking space - not removed for now [/!][table name=xstandardConversions&fields=from,to] %0D %0A %09 [/table] There's a tab character after each hex above. Wrap your field in a [convertchars table=xstandardConversions][value][/convertchars] and hopefully that will solve your problem. - Tom --000e0ce0b2d47a62c304c284fe91 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Steve,

I have dealt with a similar problem using a diffe= rent HTML editor (Xstandard). =C2=A0 I use the following table to clean dat= a before being added to a db.

[!]
<= br>

------------------------------------
### =C2=A0Clear out d= odgy characters from being added to dbs =C2=A0###

%0D%= 0A - CR/LF - carriage return/linefeed
%09 - horizontal (i.e. standard) tab<= /div>
%C2%A= 0 - non-breaking space - not removed for now

[/!][= table name=3DxstandardConversions&fields=3Dfrom,to]
%0D
%0A
%09
[/table]


There's a tab character after each hex above. =C2=A0 Wrap your field in= a [convertchars table=3DxstandardConversions][value][/convertchars] and ho= pefully that will solve your problem.

<= /div>
- Tom

=

--000e0ce0b2d47a62c304c284fe91-- 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)
--000e0ce0b2d47a62c304c284fe91 Content-Type: text/plain; charset=UTF-8 Steve, I have dealt with a similar problem using a different HTML editor (Xstandard). I use the following table to clean data before being added to a db. [!] ------------------------------------ ### Clear out dodgy characters from being added to dbs ### %0D%0A - CR/LF - carriage return/linefeed %09 - horizontal (i.e. standard) tab %C2%A0 - non-breaking space - not removed for now [/!][table name=xstandardConversions&fields=from,to] %0D %0A %09 [/table] There's a tab character after each hex above. Wrap your field in a [convertchars table=xstandardConversions][value][/convertchars] and hopefully that will solve your problem. - Tom --000e0ce0b2d47a62c304c284fe91 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Steve,

I have dealt with a similar problem using a diffe= rent HTML editor (Xstandard). =C2=A0 I use the following table to clean dat= a before being added to a db.

<= br>

------------------------------------
### =C2=A0Clear out d= odgy characters from being added to dbs =C2=A0###

%0D%= 0A - CR/LF - carriage return/linefeed
%09 - horizontal (i.e. standard) tab<= /div>
%C2%A= 0 - non-breaking space - not removed for now

[/!][= table name=3DxstandardConversions&fields=3Dfrom,to]
%0D
%0A
%09
[/table]


There's a tab character after each hex above. =C2=A0 Wrap your field in= a [convertchars table=3DxstandardConversions][value][/convertchars] and ho= pefully that will solve your problem.

<= /div>
- Tom

=

--000e0ce0b2d47a62c304c284fe91-- Tom Duke

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:

Searching multiple Databases (1997) strange problem listfiles and movefile (2000) F2 to F3 rocky transition (1997) WC2.0 Memory Requirements (1997) Multihoming and webcat (1998) completed orders database (1997) Linux problems (2000) Re:Emailer Set Up (1997) [OT] Appropriate Signature??? (2003) checkbox results written to a database (1999) [OT] Am I an Idiot? (2004) page redirect in webDNA (1997) Using EIMS instead of Emailer (1998) hm. (2002) File Upload, Browser Timeout (2003) Weird Math (2000) 2.0 Info (1997) Mixing and/or in searches (1998) A little syntax help (1997) Securing/hiding database file (2000)