AnsweredAssumed Answered

Populating field with (text) data from another field in same dbase

Question asked by TXCiclista on Sep 2, 2011
Latest reply on Sep 2, 2011 by philmodjunk

Title

Populating field with (text) data from another field in same dbase

Post

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.

Outcomes