Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member


What is the best way to remove leading zeros?  I have a field that is alphanumeric values (JONESBJ001, SMITH KC02, 0000012345, 0000555213.


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 an Elasticube:
WHEN Left([Values],1) = '0' THEN ToString(ToInt([Values]))
ELSE [Values]
Version history
Last update:
‎11-16-2023 04:23 PM
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?

Email [email protected]

Share this page: