Trim content of columns
If you want to remove white characters at the beginning or end of your content, this function is what you’re looking for.
You need to specify in which columns you’re expecting to remove the characters but also if you’re considering the leading (left), trailing (right) or both characters.
The example here under is removing white characters at the end of the content of columns foor and bar.
case trim right columns 'foo', 'bar' ;The example here under is removing white characters at the begiing and end of the content of column foor.
case trim column 'foo' ;