System Edit

[Jeff Harrison]

--- Steven Waters <swaters at triumphinstruments.com>
wrote:

> Greetings,
> 
> Is there a way to view the system edits?
> The reason I am asking is I have copied and then
> modified the 
> MMM_YY edit. I have modified the result to read
> JAN/01/2005. 
> 
> I know if you are in a MDY/ defined field
> and just enter / the system will return 01/01/05. I
> want
> to duplicate this behavior by copying what the
> system edit does. 
> 
> Can I view system edits?
> If not, does someone know how the / to today's date
> works.
> 
> Thanks,
> Steve
> 
>

Hi, I don't think there is a MMM_YY system edit - it
is a regular global edit.

You can't see what the system edits do by definition,
because they are part of the source code.  Also, they
were not written with the define edits program, they
were written in C.

At any rate one easy way to approach this is to do it
in processing.  I don't think it can be done with a
single edit.  Set aside a temporary dummy field with a
valid system date edit like mdyy/, then put your slash
in that field and then parse out the result with your
code and expand the month name.

For example (untested):

@wlf1
If: 1 eq "/"
Then: gosub expandt
Then: end

expandt
aa(10,mdyy/)=1
If: aa eq "01"
Then: 1="JAN"&mid(aa,"3","2") & mid(aa,"7","4");
display; return

Good luck.

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The easiest and
fastest ways to generate code for filePro exports and
imports.



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com