How do I pad leading Zeros?

I have:

1234500

I want:

00001234500

I'm new.

Workflow

Accepted answers

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")

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

Any string will do

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

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")

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

Happy Friday

Mark

Thanks very much for that.

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