Powered by QM on a Rpi server

KnowledgeBase 00055: Removing Redundant Mark Characters

Last updated: 22 Jul 2016
Applies to: All versions
Top level index       Full Index Search Tips
Previous article     Next article

This article was originally published as a Tip of the Week.

Sometimes programs generate data in which a dynamic array has redundant mark characters that should ideally be removed. It is easy to remove trailing field marks using TRIM() but trailing value marks within a field or trailing subvalue marks in a value are, at first sight, not so simple.

The CROP() Function

The CROP() function (named from the process of removing unwanted parts in image processing) removes redundant mark characters from a supplied dynamic array.

The returned value is a dynamic array in which trailing marks at each level of data in the original string are removed.

Related Articles


Please tell us if this article was helpful
Very     Slightly     Not at all
Email (optional)