Edit Help!
Kenneth Brody
kenbrody at bestweb.net
Sun May 16 06:40:46 PDT 2004
Quoting "Jay R. Ashworth" <jra at baylink.com>:
> On Fri, May 14, 2004 at 12:00:54PM -0400, Tim Fischer wrote:
[...]
> > Basically, I need to make an mdy/ format into yyyy-mm-dd.
>
> You aren't quite clear; do you just need the reverse order and the 4
> digit year, or do you *explicitly* need dashes as the delimiters?
>
> If the former, just assign it into an MMDY/ type dummy.
ITYM "YYMD/".
> If you need the dashes, too, you'll have to do a second assignment,
> into something that changes slashes into dashes, like
>
> [ { ! "/" ! < "-" > close-curly close-square
>
> (broken keyboard)
>
> Did I get that right, Ken?
That would convert slashes to dashes, but wouldn't allow any other
characters.
[...]
My first solution would be to do it in one step with processing:
xx = xlate(doedit(mdy_field,"YYMD/","10"),"/","-")
--
KenBrody at BestWeb dot net spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.5starEbooks.com
http://www.fileProPlus.com
More information about the Filepro-list
mailing list