Whitespace in Fixed Width file
Posted: Thu Feb 24, 2011 12:05 pm
Hi,
I am writing two columns with data type as decimal(16,2) followed by a charater field into a sequential file with the properties set as Record Delimiter = DOS style and Field Delimiter as None. I have removed the rest of record level and field level properties.
The code run is good but the data was not as expected. I could see a whitespace character at the start of the decimal fields.
Any clue of how to get rid of this whitespace.
Note: The third character field is appearing as expected
I am writing two columns with data type as decimal(16,2) followed by a charater field into a sequential file with the properties set as Record Delimiter = DOS style and Field Delimiter as None. I have removed the rest of record level and field level properties.
The code run is good but the data was not as expected. I could see a whitespace character at the start of the decimal fields.
Code: Select all
00000000000100.00 00000000000001.00Other Banks
Note: The third character field is appearing as expected