How do I pad leading Zeros?

[brad_shannon]

I have:

1234500

I want:

00001234500

I'm new.

[patrick_digan · Accepted solution]

The padleft function should do the trick: 

PadLeft([Field1],11,"0")

If it's a numeric field, you would want to add a tostring first:

PadLeft(tostring([Field1]),11,"0")

[MarqueeCrew]

@patrick_digan,

I know you're thinking, "I'm going to beat Marquee Crew" to the answer."  You know what?  You beat me!

Happy Friday :)

Mark

[brad_shannon]

Thanks very much for that.

[brad_shannon]

Now if you could just finish up the rest of my broken workflow..  lol.

[brad_shannon]

I'll have to remember that - when all else fails.

[jcornale]

You all are brilliant. That's all. Cheers.

[anthony123 · Accepted solution]

I'm new. What data types does this work with? Also, does it matter if it's VW String, VString, String?

[LordNeilLord · Accepted solution]

Hey @anthony123

Any string will do

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome