Populating field with (text) data from another field in same dbase
I have a rather large database with a particular field (call if Field B) that is a long chunk of text. Within that text is nestled a line titled "SUBJECT: " That's followed by, appropriately enough, the subject of the text. The Subject line is never at a fixed location in the text, and the subject itself can be of any length.
I would like to search Field B for "SUBJECT: " and then duplicate whatever comes after it (or even the word SUBJECT as well) to Field A. This way I could sort the table based on the Subject of the text (which I can't durrently do since it's so deeply nestled).
Google searches, forums, even FM's own help pages, appear not to work, as the scripts I've run do nothing. I am not tied to any particular approach, so long as in the end I have one database, and Field B is "undisturbed" while Field A has only the text from the SUBJECT line.
Thanks in advance.