Set text string to fixed Length

[gidon500]

hi guy

I need to adjust text string to fixed length  10 positions

input

Field

X100XC

X102X

Y200PRO

output :

FixedField

0000X100XC

00000X102X

000Y200PRO

any easy way to do it  ?

thanks

gidon

[maxgro · Accepted solution]

load

     Field,

     Repeat('0', 10-len(Field)) & Field as NewField

inline [

Field

X100XC

X102X

Y200PRO

];

[gidon500]

Hi maxgro

thanks you , it is great

happy new year

gidon