I took your advice and started from scratch testing each component
separately and then putting together the function in its entirety.
It works--and the boss is impressed.
For today, at least.
Thank you.
Bennett
On May 8, 9:09 pm, Grip <g...@[EMAIL PROTECTED]
> wrote:
> On May 8, 5:15 pm, rudabj <rud...@[EMAIL PROTECTED]
> wrote:
>
>
>
> > On May 8, 1:34 pm, Grip <g...@[EMAIL PROTECTED]
> wrote:
>
> > > On May 8, 1:26 pm, rudabj <rud...@[EMAIL PROTECTED]
> wrote:
>
> > > > My boss expects me to get data out of an old database that did not
> > > > take into account future usage. All in one field ("Info") there is
> > > > data like this all together
>
> > > > Telephone: (xxx) xxx-xxxx, xxxx Telefax: (xxx) xxx-xxxx
> > > > Mr. John Doe
> > > > Proprietor and Founder
>
> > > > I tried doing this: Right( Info; Position( Info; "Telefax:" ; 1 ;
1 )
> > > > +14) but the calculation is not accepted--it claims that the field
is
> > > > not recognized and highlights " Info; Position"
>
> > > > What do I need to do?
>
> > > > Thank you in advance,
>
> > > > Bennett
>
> > > Is this in a script or a field in a related table or a field in the
> > > same table? Are you hand typing the whole calc or selecting the
field
> > > "Info" from a list? I suspect the problem is you need to explicitly
> > > reference the table that Info is in. Add "tablename::" in front of
> > > Info or choose it from the list of available fields.
>
> > > G
>
> > I made a new field in the DB and made it a calculation using the
> > calculation I described. This way the database record would have the
> > data for laster use. Is there another way of doing it?
>
> You're doing it mostly correctly, but there's a problem with your
> syntax. Use the tools Filemaker gives you and select the field from
> the list, and then don't play around with it.
|
