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

    Mid statement based on character

    Phil Speight



      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