Geoff,
That worked perfect, and thanks for the additional tip on the Trim
wrap.... did the job. I may play around with Richard Russell's
solution too, but this is a quick and dirt solution that basically
keeps me from having to re-enter a bunch of data entry into yet
another form, that is redundant to what I already do.... AND nobody
even looks at, but if I don't turn it in, they take away my Pcard. I
realized last month that for several reports in a row, I'd left out
the receiving dates on every entry and nobody noticed! Must have been
3-4 months in a row!
Thanks again, that saved me a bunch of trial and error!
Rick
On Nov 17, 2009, at 6:00 PM, FMPRO-L automatic digest system wrote:
Date: Tue, 17 Nov 2009 16:45:46 -0500
From: Geoff Graham <[email protected]>
Subject: Re: Extracting Text from a report
Rick,
to extract from the text field "given":
Middle ( given ; Position( given ; ")"; 1; 1) + 1 ;
Position( given ; =20=
";"; 1; 1) - Position( given ; ")"; 1; 1) - 1)
You have a leading space in the returned text that could be
eliminated =20=
if desired by wrapping it in a Trim function.
Geoff
-----------------------
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
