It would be nice to see a areal example of the text. It has been my experience that when these type of questions come up, there is always variables that prevent a smooth Left, Middle and right extraction.
Looking at your example, I'm wondering if there really is a Left and Right Parentheses in the text? Lee On Nov 17, 2009, at 1: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
