I need to extract a number from a text string INCLUDING the (-) sign if it's a negative number. I'm using MiddleWords function to extract the number but the negative parenthasis is dropping off.
I've read through a number of forums and there is a lot of mention of the TextToNum function which will keep the (-) but I can't find anything about the proper syntax for it. Does this even exist in FMP11? Is there a better way to extract this number from text?