|Powered by QM on a Rpi server|
KnowledgeBase 00055: Removing Redundant Mark Characters
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.
NEW = CROP(ORIGINAL)The returned value is a dynamic array in which trailing marks at each level of data in the original string are removed.