Re: Text Utility

2017-07-06 Thread David Adams via 4D_Tech
On Fri, Jul 7, 2017 at 10:44 AM, John DeSoi via 4D_Tech < 4d_tech@lists.4d.com> wrote: >I'm still using the LCS code you published years ago. Thanks very much for that. My pleasure. I really love fuzzy matching...it makes it hard to sleep just thinking about it...currently diving into some other s

Re: Text Utility

2017-07-06 Thread John DeSoi via 4D_Tech
Hi David, Funny you mention this as I was working on it today. I have been using PostgreSQL's pg_trigram for years and had the interest to implement this in 4D. The code to create n-grams is pretty simple. Putting trigrams in a keyword indexed text field makes it super fast to find matches. The

Re: Text Utility

2017-07-06 Thread David Adams via 4D_Tech
Robert, Thanks for posting full code for a cool algorithm, a good example for the rest of us on the list. Levenshtein distance (aka "edit distance") is great! The short definition is that it measure the total number of substitutions required to convert one string into another. There are some subtl

Re: revelation! - Choose

2017-07-06 Thread Sujit Shah via 4D_Tech
I swear I was the first one to invent this... :-)) Good one! On Fri, Jul 7, 2017 at 2:45 AM, Chip Scheide via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Thanks to code from Robert Livingston > I found out about a command I had not known about > Choose > > I love this command > if anyone does not

Re: Request : Text utilities

2017-07-06 Thread Alan Chan via 4D_Tech
Thanks. It's good to know. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >Well observed. Aussies can be *way* to polite to tell someone when they're >being rude, so, yeah, they might not complain about a little thing that >they can live with.

Re: Request : Text utilities

2017-07-06 Thread David Adams via 4D_Tech
> Are these acceptable by Australian? Better ask a life-long native that was around when these formats came into play. > So far, we haven't got any complaint (may be they're too nice to say anything). Well observed. Aussies can be *way* to polite to tell someone when they're being rude, so, yeah,

Text Utility

2017-07-06 Thread Robert Livingston via 4D_Tech
The Levenshtein Distance is a measure of how similar two strings are. There is no strict definition of "degree of similarity" of two strings so this is one of many ways to measure what is an intuitive concept. i.e. ("hot dog" and "pot frog" are more similar to each other than "cold cat" and "blu

Re: revelation! - Choose

2017-07-06 Thread Chip Scheide via 4D_Tech
I only memorized the command from v1 after all who needs all those new fangled add ons :) On Thu, 6 Jul 2017 14:56:43 -0400, Chuck Miller via 4D_Tech wrote: > You mean you have not memorized all the commands. I am depressed and > disappointed in you. > 😀 > Chuck > > Sent from my iPhone > >>

Re: revelation! - Choose

2017-07-06 Thread Chuck Miller via 4D_Tech
You mean you have not memorized all the commands. I am depressed and disappointed in you. 😀 Chuck Sent from my iPhone > On Jul 6, 2017, at 12:45 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Thanks to code from Robert Livingston > I found out about a command I had not known

Re: revelation! - Choose

2017-07-06 Thread Jeremy Roussak via 4D_Tech
Yes, Choose is a very useful command. I’d been using it for some time before I realised that the first argument need not be boolean but can be integer, allowing selection from a list. Jeremy Jeremy Roussak j...@mac.com > On 6 Jul 2017, at 17:45, Chip Scheide via 4D_Tech <4d_tech@lists.4d.c

Emails sent from 4DIC showing garbage in Mac Outlook

2017-07-06 Thread Tony Ringsmuth via 4D_Tech
Since upgrading a 4D system from v15 to v16, some automated emails that I send out of that 4D system are showing garbage characters in Mac Outlook - after the first couple of lines. Like this: First line of Body Second line of Body Th`���٥��́ѥ���51���Mх} �ѕ|���ܴ�ش�""���

revelation! - Choose

2017-07-06 Thread Chip Scheide via 4D_Tech
Thanks to code from Robert Livingston I found out about a command I had not known about Choose I love this command if anyone does not know about it - read it is so nice to do in one line of code what other wee takes at least5 Chip --- Gas is for washing parts Alcohol is for drinkin'

Re: Request : Text utilities

2017-07-06 Thread Alan Chan via 4D_Tech
We have been formatting Australia phone number like (2) 3456 7899 434 567 899 Are these acceptable by Australian? So far, we haven't got any complaint (may be they're too nice to say anything). TIA Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >Note that local custom varies. For

Re: SQL

2017-07-06 Thread Charles Miller via 4D_Tech
great eyes. I think you have it as the apostrophes are different. One is different than the other. regards chuck On Thu, Jul 6, 2017 at 3:34 AM, Jerker Stenberg via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Robert > Can it be the [DOCTOR_CODE] ? '10289’ seems odd, should prob. be '10289' > or

Re: Request : Text utilities

2017-07-06 Thread Chip Scheide via 4D_Tech
it could be useful. I have used renamer (or something similar - don't remember the name) on occasion. I don t know that I want to get as involved as that app, but a simple file renamed utility could be done. Which feature(s)? I think: allow - Drag n drop a selection of files or folders or -ope

Re: Request : Text utilities

2017-07-06 Thread Chip Scheide via 4D_Tech
really? I thought the special needs of Auzzies was related to ALCOHOL INTAKE :) On Thu, 6 Jul 2017 09:44:40 +1000, Wayne Stewart via 4D_Tech wrote: >> Note that local custom varies. For example, Australia > > Australian's have special needs, it's due to our convict past. > > > Regards, > > W

Re: Request : Text utilities

2017-07-06 Thread Chip Scheide via 4D_Tech
Thanks for the links and info On Thu, 6 Jul 2017 07:23:51 +1000, David Adams via 4D_Tech wrote: > On Thu, Jul 6, 2017 at 1:28 AM, Chip Scheide via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> >> Things I know I need : >> - Phone # formatting, to include various (non-US) formats -- most of which

Re: SQL

2017-07-06 Thread Wendell Turner via 4D_Tech
Could it be the value for the [DOCTOR_NAME] and/or the [DOCTOR_PRINT_NAME] fields, as they seem to contain the ‘comma’ character, and the code seems to also be using the ‘comma’ character as a field delimiter. Wendell Turner p:= +44(0)7403 524010

Re: SQL

2017-07-06 Thread Jerker Stenberg via 4D_Tech
Hi Robert Can it be the [DOCTOR_CODE] ? '10289’ seems odd, should prob. be '10289' or 10289 depending on field type. On Jul 5, 2017, at 12:13 PM, Robert McKeever via 4D_Tech <4d_tech@lists.4d.com> wrote: The site is running v11, and communicates with the other system by SQL. Been working th