5 Replies Latest reply on Sep 30, 2015 12:19 PM by DavidJondreau

    Substitute calculation not performing as desired.

    MarcMP

      Hey all,

       

      Using FM-12 advanced.

       

      Hope someone can help me get this to work as desired. this is my current calculation.

       

      Substitute (

           PrinterList ;

      [ Char (9); ¶  ];

      [ Right ( PrinterList ; Length ( PrinterList ) - Position ( PrinterList ; "- See more at: "; 1 ;1 )) ; "" ] ;

      [ "- See more at:" ; ""  ]

      )

       

      It works good except for if the field does not contain the text "- See more at:" that it will only 90% of the time contain, it removed everything and I am left with a blank field. Also when it does contain "- See more at:" and the text that would follow it, it removes everything desired except for the "-" at the beginning..

       

      Thanks in advance for any assistance.