AnsweredAssumed Answered

Word functions - Hyphens and other word seperators

Question asked by RWWest on Jun 27, 2011
Latest reply on Jun 30, 2011 by ninja

Title

Word functions - Hyphens and other word seperators

Post

I've read through many posts trying to find an answer or work around.  I'm trying to extract the middle word(s) out of a field and hyphens and/or word count is messing my calculation.  Below are example (FNAME - PO_FILE) of what I'm working with, the underlined portion is what I am trying to retrieve and place into another field (FNAME - PO_NO)

ABC DEF-HIJ PO 123456-00.PDF

ABC DEF-HIJ PO 123456.PDF

ABCDEF GHI-JKL PO 123456.PDF       

ABCDEF GHI-JKL PO 123456-00.PDF

ABCDEF GHI-JKL PO 123456-00 ABCD.PDF

Any help will be appreciated.  This maybe impossible, but I figured one of the kind people here may know of a solution. 

Using Filemaker Pro 5, don't laugh it still works great.

Outcomes