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:

Interfacing WebMerchant to www.fedex.com (1997) [WebDNA] AutoFill Drop Down Menu (2009) Re:quit command on NT (1997) Summary search -- speed (1997) RE: [WebDNA] Handling passwords in WebDNA (2010) searching illegal HTML (2002) retail integration (2000) Bulk Email >>>>Any ideas? (2001) Error Lob.db records error message not name (1997) Formulas.db not working (2006) [WebDNA] cron - curl to replace triggers.. (2009) Problem 2: Prefs file... (1997) 2.01 upgrade problems (1997) Search with Special Chars (1997) Security hole in WebCat? (1999) Price Not Appearing (2000) need help please (1997) Form/HTML Help (2000) RequiredFields template (1997) [WebDNA] Small Parsing Problem (2009)