Getting left and right expression values

[Stanley - stanlyn-com]

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?

Thanks, Stanley







-----Original Message-----
From: Kenneth Brody [mailto:kenbrody at spamcop.net] 
Sent: Monday, April 23, 2012 10:21 PM
To: Stanley - stanlyn-com
Cc: Filepro-list at lists.celestial.com
Subject: Re: Getting left and right expression values

On 4/23/2012 9:49 PM, Stanley - stanlyn-com wrote:
> Hi,
[...]
> How do I get just the date part and/or the time part?  In the other 
> languages I use we have a left and right functions that returns values 
> from the left or right as in:
[...]
> Also what about a function that would return a string starting at a 
> known position and for x number of characters, such as 
> lcString=substr(datetimefield, 7,6) where lcString would be equal to 
> "4/23 2"
>
> I use this kind of stuff all the time in other languages and don't see 
> any easy way of doing it in filePro.
[...]

Use MID(), which is the equivalent of your substr() example.

--
Kenneth Brody