Re: Expunging Char (0)

2016-09-22 Thread Tom Dillon
L&K 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 Alan Chan
This is cute. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >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... >>

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 Wed,

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-22 Thread Doug Hall
How "legacy" are we talking? Because I plan to use DataCheck on my 4D 2004 database (before conversion to v15), to do exactly this. Just wanted to make sure this old solution hadn't slipped your mind, if it's relevant. Doug On Wed, Sep 21, 2016 at 4:19 PM, Douglas von Roeder wrote: > I've hit

Re: Expunging Char (0)

2016-09-22 Thread Chip Scheide
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? ;-) ** 4D Internet Users Grou

Re: Expunging Char (0)

2016-09-21 Thread Douglas von Roeder
Chip: Thanks for posting this code. I can use that if I do the "crawl through the records". Since Pat's from the UK, does it left-justify the text? ;-) -- Douglas von Roeder 949-336-2902 On Wed, Sep 21, 2016 at 2:56 PM, Chip Scheide <4d_o...@pghrepository.org> wrote: > Doug, > if I am readi

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 Douglas von Roeder
Chip: You're correct - there's a variety of non-printing characters so it will be a QbF that does a Find in array. I'm just wondering is there's a way to fix this that's not so time consuming. And, just to deke me, there's a filter called "Text_Filter" that's empty. :-) -- Douglas von Roeder 94

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 cha

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 wo