Getting left and right expression values

[Kenneth Brody]

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