Adding zeroes or spaces to strings and get fixed length

Using the transformer stage, how do we get fixed length strings in output stream? In the below example, we see how to add zeroes and make the string of a given length.

Source having following data as below,

AB1

Aim2

Abnv5

1An8bx

as in my target/ output must have:

 

000AB1

00Aim2

0Abnv5

1An8bx

 

How do we achieve this?

Str(‘0’,6-Len(string)): string 

Leave a Reply

Your email address will not be published. Required fields are marked *