OT: foxPro
Richard Kreiss
rkreiss at verizon.net
Tue Apr 24 07:56:27 PDT 2012
> -----Original Message-----
> From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
> [mailto:filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com] On
> Behalf Of Kenneth Brody
> Sent: Tuesday, April 24, 2012 10:15 AM
> To: Stanley - stanlyn-com
> Cc: filepro-list at lists.celestial.com
> Subject: Re: Getting left and right expression values
>
> On 4/23/2012 10:30 PM, Stanley - stanlyn-com wrote:
> > Hi Ken,
> >
> >> Use MID(), which is the equivalent of your substr() example.
> > OK, yes I see that, and thanks...
> >
> > Now, what about the left and right functions? How would you get those
> > parts out of a string?
> [...]
>
> "left()" is simply "mid()" starting at position 1.
>
> "right()" is a smidge more involved, but you can use len() to get the
length of
> the field, and use length-n as the mid() starting position to get the
rightmost
> "n" characters.
>
> --
> Kenneth Brody
The only feature of FoxPro that I would like to see in filepro has to do
with how they treat a memo field. You can limit its size. This allows for
placement on a form with the proper size and location and no chance for the
user to put in too much data.
In one of my applications, this would have worked better than a multiline
(fields) that I had to use.
Richard Kreiss
GCC Consulting
Office: 410-653-2813
More information about the Filepro-list
mailing list