4 Replies Latest reply: Feb 26, 2016 6:58 AM by Phil Speight RSS

    Mid statement based on character

    Phil Speight

      Hi

       

      I want to remove some text from the beginning of a field by expression / script.  The seperater is '#', but it is not always at the same mid point of the field.  Could anyone help.  Please see below  ....

       

       

      123;#Peter Jones

      56789;# John Smith

       

      I want to show .....

       

      Peter Jones

      John Smith

       

       

      Any thoughts welcome

       

       

      Thanks  

       

       

      Phil