Getting left and right expression values

[Stanley - stanlyn-com]

Hi,

 

I have merged the date and time values into a single 16 character field with
a space separating the 2 values such as: 2012/04/23 21:25

 

In this datetime example, I used ld(yymd/,10) for the date part so sorting
would be automatic when saving as a character data type, and used the <
timepart that concatenates the time part with a leading space.

 

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:

 

lcDate=left(datetimefield,10) where lcDate would be equal to "2012/04/23",
or

lcTime=right(datetimefield,5) where lcTime is equal to "21:25"  

 


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.

 

I'm using sco filePro 5.014d

 

Thanks, Stanley

 

	

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20120423/a64ced79/attachment.html