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