Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

gidon500
Contributor II

Set text string to fixed Length

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Set text string to fixed Length

load

     Field,

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

inline [

Field

X100XC

X102X

Y200PRO

];

2 Replies
MVP
MVP

Re: Set text string to fixed Length

load

     Field,

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

inline [

Field

X100XC

X102X

Y200PRO

];

gidon500
Contributor II

Re: Set text string to fixed Length

Hi maxgro

thanks you , it is great

happy new year

gidon

Community Browser