Is it possible to cut off specified characters at the beginning or end of a string?

Question

Is it possible to cut off specified characters at the beginning or end of a string?

e.g.
Data before extraction: abcdzzzz Data after extraction: abcd
Data before extraction: abcdzzzz Data after extraction: zzzz

Answer

By using Trim Left or Trim Right in Mapper logics, it is possible to cut off specified characters at the beginning or end of a string.

Please try the following procedure:
1. Place the Mapping.
2. Place Trim Left or Trim Right in the Mapper editor.
3. Uncheck all the checkboxes in the property of the trim logic and specify unnecessary characters in [Other character to trim].

For details of each logic, please refer to the following online help.

Trim Left
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Mapper/TrimLeft.htm

Trim Right
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Mapper/TrimRight.htm

Related FAQs

Trimming strings does not work as expected