On May 8, 1:39 pm, Martin Trautmann <t-...@[EMAIL PROTECTED]
> wrote:
> On Thu, 8 May 2008 10:26:33 -0700 (PDT), rudabj 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"
>
> Did you write this formula manually or did you compose it by
> mouseclicks?
>
> Where do you use it? A calculation field within the same table or
> something within a script or...? This would require to include the table
> name, such as olddata::info
>
> Personally, I would not trust a fixed length, but would start to catch
> anything from "Telefax" til the end of the line. No extra spaces
> anywhere? No international numbers?
>
> Processing this kind of data usually is an iterative job, where I
> first move the data to a tem****ary field, extract some data, review it,
> remove it from the temp field, search for remaining stuff and go on and
> on.
I did it using the fields, but then started playing with it manually.
I thought it would be fairly straightforward to create a new field
containing a calculation that would start from the "telefax:" and then
take the next 15 characters. What other way is there of doing it that
would not require more than an intermediate knowledge of FMP?
Thank you in advance,
Bennett
|
