Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
load
Field,
Repeat('0', 10-len(Field)) & Field as NewField
inline [
Field
X100XC
X102X
Y200PRO
];
load
Field,
Repeat('0', 10-len(Field)) & Field as NewField
inline [
Field
X100XC
X102X
Y200PRO
];
Hi maxgro
thanks you , it is great
happy new year
gidon