Add Zeros in the string

4 replies
27 views

Hi,

I want my alphanumeric field with the below condition.

if the text is asdf45 I want the output total as 10 digits with Zero's in the front. How can I do that?

When I try doing text(asd45,"0000000000") --> this is not considering the strings present.

Thanks!

hema.mathivathananAnswer

Employee

I used join array and repeat function and it worked

hema.mathivathananAuthorAnswer

Employee

I used join array and repeat function and it worked

mathieud0001

Genius

Probably cleaner to do something with a combination of concat/stripWith/cleanWith/text.

mathieud0001

Genius

a!localVariables(
  local!text: "asdf45",
  concat(
    stripwith(local!text, "0123456789"),
    text(
      cleanwith(local!text, "0123456789"),
      "0000000000"
    )
  )
)

M

marcush852182

New Participant

rept("0", 10-len("asdf45")) & "asdf45"

Sign up

Login with SSO

Login to the community

Login with SSO