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.
|
