Re: [WebDNA] grep character problem

This WebDNA talk-list message is from

2012

It keeps the original formatting. numero = 109216
interpreted = N
texte = That's exactly the kind of thing I need but I have your code in place =now and it is still there, do you know anyway I can tell what the =character is?Cheers=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DSteve Craig - Asylum Interactive LtdTel +44 1330 860550 Fax +44 1330 860880=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3Dhttp://www.asylumweb.comEmail: steve@asylumweb.comSkype: s.craig - iChat: steve.craig=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DOn 15 Jun 2012, at 17:05, Tom Duke wrote:> Steve,>=20> 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.>=20> [!]>=20>=20> ------------------------------------> ### Clear out dodgy characters from being added to dbs ###> =09> %0D%0A - CR/LF - carriage return/linefeed> %09 - horizontal (i.e. standard) tab> %C2%A0 - non-breaking space - not removed for now>=20> [/!][table name=3DxstandardConversions&fields=3Dfrom,to]> %0D=09> %0A=09> %09=09> [/table]>=20>=20> There's a tab character after each hex above. Wrap your field in a =[convertchars table=3DxstandardConversions][value][/convertchars] and =hopefully that will solve your problem.>=20> - Tom>=20>=20> --------------------------------------------------------- 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 Bug Reporting: =support@webdna.us Associated Messages, from the most recent to the oldest:

Re: [WebDNA] grep character problem (Steve Craig 2012) Re: [WebDNA] grep character problem (Tom Duke 2012) Re: [WebDNA] grep character problem (Steve Craig 2012) Re: [WebDNA] grep character problem (Tom Duke 2012) [WebDNA] grep character problem (Steve Craig 2012)

That's exactly the kind of thing I need but I have your code in place =now and it is still there, do you know anyway I can tell what the =character is?Cheers=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DSteve Craig - Asylum Interactive LtdTel +44 1330 860550 Fax +44 1330 860880=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3Dhttp://www.asylumweb.comEmail: steve@asylumweb.comSkype: s.craig - iChat: steve.craig=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DOn 15 Jun 2012, at 17:05, Tom Duke wrote:> Steve,>=20> 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.>=20> [!]>=20>=20> ------------------------------------> ### Clear out dodgy characters from being added to dbs ###> =09> %0D%0A - CR/LF - carriage return/linefeed> %09 - horizontal (i.e. standard) tab> %C2%A0 - non-breaking space - not removed for now>=20> [/!][table name=3DxstandardConversions&fields=3Dfrom,to]> %0D=09> %0A=09> %09=09> [/table]>=20>=20> There's a tab character after each hex above. Wrap your field in a =[convertchars table=3DxstandardConversions][value][/convertchars] and =hopefully that will solve your problem.>=20> - Tom>=20>=20> --------------------------------------------------------- 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 Bug Reporting: =support@webdna.us Steve Craig

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:

Sku numbers (1997) Re:Emailer and encryption (1997) TCP Connect for a newbie (2002) [protect] on NT? (1997) WebCat2 - Getting to the browser's username/password data (1997) many-to-one problem (1998) using showpage and showcart commands (1996) Sort Order on a page search (1997) AutoCommit Preference? (1998) Sandboxes & Kitty Litter trays (2003) Bug Report, maybe (1997) Show items based on login Password (2003) SiteEdit (1999) SiteEdit NewFile.html ? (1997) pc (1997) Secure Server (1997) New Cart No. on same page (2003) WebDNA and SQL (2003) Prices coming up 0.00 (2001) WebCat2: Items xx to xx shown, etc. (1997)