AnsweredAssumed Answered

Substitute calculation not performing as desired.

Question asked by MarcMP on Sep 30, 2015
Latest reply on Sep 30, 2015 by DavidJondreau

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.

Outcomes