5 Replies Latest reply: Jul 15, 2015 5:55 PM by Phaneendra Kunche RSS

    Removing a definite number of characters from the beginning and end

    Bindu George

      I would like to remove a certain number of characters from the beginning and end of string. What would be the best option. I have tried using LEFT and MID which does one at a time ( right or left).

      In the examples, would like to remove 127 characters from the left and 21 from the right at once

      <?xml version='1.0' encoding='UTF-8'?><root available-locales="en_US" default-locale="en_US"><Description language-id="en_US">Admin Test</Description></root>

       

      <?xml version='1.0' encoding='UTF-8'?><root available-locales="en_US" default-locale="en_US"><Description language-id="en_US">Allows Access to the tool</Description></root>