doedit help

Guy Templin Guy_Templin at adelphikitchens.com
Thu Jun 17 07:34:28 PDT 2004


Thanks for all the suggestions I just got it to work. My problem was on the
import file. I added a delimiter to the end of the record and now it works.
I guess it had too much space after it since it is only 2 fields long. It is
now working.

Thanks for getting me to think outside the box. Sometimes we are so focused
on one issue we forget to look at the whole issue. Which is what is good
about this forum. It gets us thinking in a different direction.

Guy Templin
Adelphi Kitchens, Inc.
----- Original Message -----
From: "Guy Templin" <Guy_Templin at adelphikitchens.com>
To: "Jeff Harrison" <Jeff.Harrison at Epixweb.com>
Cc: "Filepro" <filepro-list at seaslug.org>
Sent: Thursday, June 17, 2004 10:07 AM
Subject: Re: doedit help


> Jeff,
>
> Thanks for the suggestions however even if I remove the edit on da it
still
> does not function. I have printed below the contents of the ascii file I
am
> importing from.
>
> ACKN|11118
> SEND|Submit Request
>
>
> With no edits the data should be left justified, not? It still fails the
> edit and db is blank.
>
> Your suggestion to add [{!" "!}] to the beginning of my doedit I don't
> understand. Where exactly should I add it and what does it do?
>
> Thanks,
>
> Guy Templin
> Adelphi Kitchens, Inc.
>
>
> ----- Original Message -----
> From: "Jeff Harrison" <Jeff.Harrison at Epixweb.com>
> To: "'Guy Templin'" <Guy_Templin at adelphikitchens.com>
> Cc: "Filepro" <filepro-list at seaslug.org>
> Sent: Wednesday, June 16, 2004 4:38 PM
> Subject: RE: doedit help
>
>
> > Guy Templin wrote:
> >
> > >
> > > my edit is N N N <-> N N (length of field is 6)
> > >
> > > The edit works in *clerk processing if someone enters a value
> > > of 111-18 or
> > > when someone enters 11118 it adds the dash and it will pass the edit.
> > >
> > > My problem is I am getting the input from a file created from
> > > web input and
> > > I want to be able to have the dash added it they forget to put it in.
> > >
> > > I need the value from da if it equals "11118" to be passed on to db as
> > > "111-18"
> > >
> > > thanks for your help.
> > >
> >
> > In your earlier post you mentioned that the definition for da is (6,#)
> that
> > means that you are supplying the value " 11118" to your doedit function.
> > Note the leading space.  If you add [{!" "!}] to the beginning of your
> > doedit that should do the trick for you.
> > Jeff Harrison
> > jeff.harrison at epixweb.com
> >
> > Author of JHExport and JHImport - The fastest and easiest ways to
generate
> > code for filepro exports and imports.  Demos available upon request.
> >
> >
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>




More information about the Filepro-list mailing list