edit for date with month spelled in abbreviated format
Kenneth Brody
kenbrody at spamcop.net
Thu Jun 7 09:02:26 PDT 2012
Please use an e-mail program that knows how to follow industry-standard
quoting practices. Your reply has nothing to tell the reader which parts
are mine, and which are yours. (Even Laura mis-parsed it, thinking that it
was I who wrote "How would I know if mmm_yy edit was broken".)
I have fixed your broken quoting in my re-reply.
On 6/7/2012 11:22 AM, Dennis Malen wrote:
> -----Original Message-----
> From: Kenneth Brody [mailto:kenbrody at spamcop.net]
> Sent: Thursday, June 07, 2012 11:14 AM
> To: Dennis Malen
> Cc: filepro-list at lists.celestial.com
> Subject: Re: edit for date with month spelled in abbreviated format
>
> On 6/7/2012 10:50 AM, Dennis Malen wrote:
>>> Trying to test this: jj(8,mdy/)="05/01/12";da(12,mmm_yy)=jj
>>> Msgbox "da"<da shows the result to be "da"
>>
>> I get "da MAY 12 ", as expected.
>
> Tried again with different dummy fields. Value is still blank.
Not sure why you felt that the problem was with the names "jj" and "da".
>>> Also not sure of the "12" in definition of "da".
>>
>> What about the "12" are you not sure about?
>
> Was not sure how many characters I would need so chose 12. If that does not
> affect it then fine.
As long as it's long enough (and 8 is long enough for a 2-digit-year date).
>>> Could it be my version of 5.0?
>> [...]
>>
>> Did someone "break" the "mmm_yy" edit?
>
> How would I know if mmm_yy edit was broken. Never used before. How can I
> determine if broken and how do I fix?
Test it in define edits. Use "mmm_yy" length 10. (Or use 12, to match your
processing.) Type "05/01/12", and it should be replaced with "MAY 12". If
not, someone "broke" it.
It should be:
=====
MMM_YY:~ ( mthabrv <" "> N N [ N N ] ) | ( repnum [!/!] delnum delnum [!/!]
<" "> N N [ N N ] )
repnum:( (!01! <JAN>) | (!02! <FEB>) | (!03! <MAR>) | (!04! <APR>) | (!05!
<MAY>) | (!06! <JUN>) | (!07! <JUL>) | repnum2 )
repnum2:( (!08! <AUG>) | (!09! <SEP>) | (!10! <OCT>) | (!11! <NOV>) | (!12!
<DEC>) )
mthabrv:"JAN"|"FEB"|"MAR"|"APR"|"MAY"|"JUN"|"JUL"|"AUG"|"SEP"|"OCT"|"NOV"|"DEC"
delnum:( !0! | !1! | !2! | !3! | !4! | !5! | !6! | !7! | !8! | !9! )
=====
--
Kenneth Brody
More information about the Filepro-list
mailing list