Qlik Community

Ask a Question

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY

String function: Strip all whitespace from start and end

daviewales
Contributor III
Contributor III

String function: Strip all whitespace from start and end

The 'Trim()' function only removes literal ascii space characters from the start and end of strings.

It would be good to have a 'Strip()' function which removes all 25 unicode whitespace characters as defined in this Wikipedia article.

Additionally, much like Python 3's 'str.strip()' function, the 'Strip()' function could take an optional second argument to specify specific characters to strip from the start and end of strings.

2 Comments
WiscoSippi
Creator
Creator

The ability to specify a character to strip would be nice. Using replace() is works most of the time but occasionally don’t want to remove all instances of the character. 

Patric_Nordstrom
Employee
Employee

Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

Thanks,

Patric

Status changed to: Open - Collecting Feedback