The main thing that struck me when I read Richard's explanation (not
"solution" I guess) was that I could probably turn this into a custom
function so that it would be more versatile. I use a similar solution
to capture the file names contained in a folder, then loop through
each line (file name) and create data records with that file name. It
was an easier "nut to crack" since I controlled the data and only
needed to look for, and count, the hard returns. But seeing the logic
broken down made me realize since I've done this twice now, but with
different data sets, I could probably make a custom function for the
structure and just plug in the fields and characters I'm looking for.
In fact, the first thing I'll do is go to Brian Dunning's custom
function page and see if it already exists!
Thanks again for the help, it did work perfect!
Rick
On Nov 18, 2009, at 6:00 PM, FMPRO-L automatic digest system wrote:
Date: Wed, 18 Nov 2009 14:19:33 -0600
From: "Richard S. Russell" <[email protected]>
Subject: Re: Extracting Text from a report
On 2009 Nov 18, at 13:22, Rick O'Quinn wrote:
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 ...
Disclaimer: My "solution" was just a rough draft of an approach that
would have shortly yielded the result that Geoff gave you. I passed
it on more to show the thot process involved than to produce a usable
result, since Geoff had already done tha
-----------------------
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
