Word functions - Hyphens and other word seperators
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.