Rick,
to extract from the text field "given":
Middle ( given ; Position( given ; ")"; 1; 1) + 1 ; Position( given ;
";"; 1; 1) - Position( given ; ")"; 1; 1) - 1)
You have a leading space in the returned text that could be eliminated
if desired by wrapping it in a Trim function.
Geoff
On Nov 17, 2009, at 4:24 PM, Rick O'Quinn wrote:
I have to build a form from an Excel sheet. I don't have any control
on the formatting and information on the Excel sheet, which is why
I'm importing it into a FMPro file to parse and print the data. I
have one cell that use to be 3 different cells, now combined into
one. I need to extract the first part into a calc field. The wording
will vary from line to line, but it will follow the same pattern:
(MeLastName, MeFirstName, 11/10/09 14:52) xxx some text xxx; (Doe,
Jane, 11/11/09 07:52) Signed Off: jd 11/11/09; (smith, john,
11/12/09 07:47) Signed Off: js 11-12-09
What I need to do is pull the text:
xxx some text xxx
out of this string. It will always come after the first () and
before the first ;
I know there's a way to do this with the Middle and Position
functions, but I've always been bad at using those.
Any help would be appreciated.
rick
-----------------------
Rick O’Quinn
Photographic Services Coordinator
University of Georgia
Public Affairs
Broadcast, Video & Photographic Services
188 Georgia Center
Athens GA 30602-3603
Work: (706) 542-8085
Fax: (706) 583-0011
[email protected]
http://www.photo.alumni.uga.edu
