I have a need to scrape some text from a character field in a form and then be able to pop it into another field on that same form. The text I need will always be on the second line in the field, and it will always start at the same place, but will be of differing lengths. It will always start and stop with a single quote - ', and the first quote will always be the first one in the field. If I could grab the text (it's a company name), I believe I could then put it in a temp field and use that temp field to set the other field. I just don't quite know how to get that text. Any ideas? This is in 6.3, we use (sadly) the CRM app.

Look at the available functions that you can use in set field action in the documentation.