AnsweredAssumed Answered

TextToNum function?

Question asked by FMNewbie on Sep 11, 2011
Latest reply on Sep 12, 2011 by FMNewbie


TextToNum function?


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?