5 Replies Latest reply on May 14, 2012 6:26 AM by philmodjunk

    Text right of commas

    ShirleyMB

      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 )
              )