DSXchange

Hello

I have fixed with file as source in which there were couple of fields which were defined as Integer datatypes and right justified with leading spaces. Is it a common practice to have integer values as right justified. If i want to make the integers as left justified in the target file, is there a function in the transfomer that i can use?

Appreciate your help

Regards

Justification only applies to text fields. In order to left just try:
where MaxLen is the length of your left-padded string and In.Column is the text right-padded input column.

You can also use the following code..
Space(maxlength-Trim(In.column)):In.column

It IS common practice that integers are right justified, sometimes left padded with space, sometimes left padded with zeroes.

You can handle it easily with Trim().