Re: Expunging Char (0)

2016-09-22 Thread Tom Dillon
L Lo wrote: >It's not our fault Americans can't spell. >:-) Yeah, I know, like, right? Some of us still put extra letters like "ugh" in tho. How brown is your cow now? (That last sentence is silent.) -- -- Tom Dillon

RE: Expunging Char (0)

2016-09-22 Thread Chip Scheide
https://pbs.twimg.com/media/CRchX5dW0AAUWag.jpg:large LOL On Thu, 22 Sep 2016 14:45:17 +, Lo wrote: > Hey Chip > > It's not our fault Americans can't spell. > :-) > > Love and kisses > Lo > >> no... >> but it probably adds a bunch of "u"s to words, like color (colour) > >> 8) > > On

RE: Expunging Char (0)

2016-09-22 Thread Lo
Hey Chip It's not our fault Americans can't spell. :-) Love and kisses Lo > no... > but it probably adds a bunch of "u"s to words, like color (colour) > 8) On Wed, 21 Sep 2016 16:14:25 -0700, Douglas von Roeder wrote: > > Since Pat's from the UK, does it left-justify the text? ;-)

Re: Expunging Char (0)

2016-09-21 Thread Chip Scheide
Doug, if I am reading this correctly (http://kb.4d.com/resources/inug?msgid=GmailId14980bbd87790d18 ) - Keisuke is saying... SET TEXT TO PASTEBOARD($text) $text:=Get text from pasteboard apply to your text field(s) Also I found this on game (12 years ago - from Pat Bensky) Here is some code

Re: Expunging Char (0)

2016-09-21 Thread Chip Scheide
Doug, this might be more then you think... as I recall there are a number of non-printing characters in unicode char(0) through char(31) except Char(10), char(13) so it may not be a "simple" Query by formula([table];position(char(0);[table]field)>0) It may actually be a case of do any of the

Expunging Char (0)

2016-09-21 Thread Douglas von Roeder
I've hit a situation in a legacy application that has records with alpha and text fields that contain numerous non-printing characters. The non-printing characters are causing non-printing. How do I go about finding the records the have invalid characters and deleting the Char(0)? One approach