1 2 Previous Next 20 Replies Latest reply on Aug 4, 2016 3:54 AM by CICT

    Remove all characters to the left of = character

    dinoapolito

      Hi,

       

      I need to write an expression (I guess using the Substitute or Replace function) that strips all characters to the left of the = character.

       

      For example the data may be

       

      item=kicks

      or

      version=standard

      or

      background=blue

       

      You can see the number of characters to be removed will vary but in all cases I need to keep only what's to the right of the = character.

       

      I feel I should know this but I can't work it out.

       

      Many thanks in advance

      Dino

        1 2 Previous Next