Left padding wth spaces

Hello, I would like to left pad a string with spaces to a total number of characters. I've tried to use PadLeft([field],12," "), but the space in between the quotes is not being read. If I put in a character, it works, but I need spaces. Any ideas?

Developer Tools

Expression

Accepted answers

estherb47

@krankin

Just like @Claje , I tried this and it worked for me. A few suggestions. First, make sure your text field is long enough to accommodate the spaces. A Select tool before the Formula tool can help with that.

The next suggestion is to add a browse tool, run the workflow, and check the results in a new window. Sometimes it's easier to see that way.

Let me know if that helps.

Cheers!

Esther

All comments

Claje

Hi, I just tested this and it worked, the space was properly read. Are you trying to put 12 spaces in front of ALL records in that field?

krankin

Hi.... no I just want to have the field padded to 12 characters. I working with a string field that is 12 characters and the values are 7 characters. PDMCU = '2382010'..... need to have ' 2382010'

estherb47

@krankin

The next suggestion is to add a browse tool, run the workflow, and check the results in a new window. Sometimes it's easier to see that way.

Let me know if that helps.

Cheers!

Esther

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703