Replacing Segments with String Operations

You can apply a string operation to a segment that is being replaced. For example, you may have a value of 11002293 but when the segments are written, you want to only take the last four digits, or the first six digits. Examples using the member 11002293:

  • Ignore the first two characters and provide the result: 002293. Use #FORMAT("##*").

  • Truncate the last three characters provide the result: 11002. Use #FORMAT("?????").

  • Ignore the first two and truncate the last three with the result: 002. Use #FORMAT("##???").