removesuffix(
TEXT
,
SUFFIX
)

The removesuffix( function checks to see if a text item ends with a suffix. if it does, the suffix is removed.


Parameters

This function has two parameters:

text – text that may or may not have a suffix.

suffix – suffix value to remove.


Description

This function checks to see if a text item ends with a suffix. If it does, the suffix is removed.

removesuffix("abc.",".") ☞ abc
removesuffix("37¢","¢") ☞ 37

Note: This function is equivalent to:

?(thetext endswith thesuffix,trim(thetext,length(thesuffix)),thetext)

See Also


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.