how to remove leading zero from a string

linp0001 please try this may be solve your problem.

1)Syntax : --

text( value, format )

2) Syntax : -- 

split ( text, separator )

For more details please refer this documentation --> text() Function - Appian 21.1

split function --> split() Function - Appian 21.1

thanks for the information, the problem is that the number of leading 0 is variant. so it probably will not work.

regards,

Hi Lin,

Please try this plugin -regexreplaceall . Thus will help you for this specific case and also many other use cases related to formatting text using regex. Refer the link for downloading the plugin.

regexreplaceall("^0+","0000100","")

https://community.appian.com/b/appmarket/posts/regular-expression-functions

hope this helps. Have  a good Day!

It's working! Thank you very much for the help.

regards,

Also, in case anyone is looking for an OOTB solution here - the fixed() function will do this easily for you.

tointeger(
  fixed(00002803,0)
)