AnsweredAssumed Answered

Text right of commas

Question asked by ShirleyMB on May 13, 2012
Latest reply on May 14, 2012 by philmodjunk

Title

Text right of commas

Post

I found this calculation on the forum website but get a message that there are too few parameters. I keep adding a bracket and playing around with the calculation, but I still get the same message. I work on FM8 and need to get all the text after the first comma. Thanks in advance for any help with this calculation.

 

Let ( [ t = YourTextfield ;
           L = Length ( t ) ;
           p = position ( t ; "," )
         ] ;
         Right ( t ; L - p )
        )

Outcomes