DSXchange

Posted: **Mon Dec 18, 2017 3:38 am**

Hi Team,

I want my out put file to look like below:

20 11111    xxxxxx
20 11111    yyyyy

datatype is,
col1 char(1), col2 char(2), col3 char(9),col3 char(6)

when im running my datastage job im always getting extra space after every value like below:

Code: Select all

2 0 11111     xxxxxx

for the 1st char im always getting extra space after 2.

Could you please let me know how to do left justified in transformer stage and my output is sequential file.

Posted: **Mon Dec 18, 2017 8:12 am**

Isn't there a stage property for the number of spaces between columns in the output? I can't check but it sounds like it is set to 1 and it should be 0.

Posted: **Mon Dec 18, 2017 1:27 pm**

Please provide your Output File Format

Spaces between columns: This field is only active when you select the Fixed-width columns check box. Contains a number to represent the number of spaces used between columns.

Posted: **Tue Dec 19, 2017 7:53 am**

There is also a file format property called Delimiter string, which allows one or more characters to be specified.

DSXchange

Issue with left justified column with spaces in fixed length

Issue with left justified column with spaces in fixed length

Re: Issue with left justified column with spaces in fixed le