Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member
Question: What is the best way to remove leading zeros?  I have a field that is alphanumeric values (JONESBJ001, SMITH KC02, 0000012345, 0000555213.

Solution: If all of your data with leading zeros will always be some sort of numerical string (ie there will not be values like 000{character}) you could create a custom column using the following expression in the Elasticube:
WHEN Left([Values],1) = '0' THEN ToString(ToInt([Values]))
ELSE [Values]
Version history
Last update:
‎03-02-2023 08:31 AM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?