Spaces getting truncated

[former_member208402]

Hi All,

We are extracting data from SAP tables and loading into flat file.

The spaces between the strings are being truncated.

Say we have source data like this  <Ravi Kiran> and it is being loading as <RaviKiran>

But it is loading correctly when the target is table.

Can someone help us overcome this issue.

Thanks,

Ravi kiran.

[former_member187057]

Hi Ravi,

Please check the code page that you are using for the file format it should be as same as table code page which you are seeing appropriate data.

try to put temp table and table along with file for query output same time and see the data how it was in table and file and temp table and you can do more and share your analysis .

Thanks,

Sreenivas

[former_member200473]

Hi Ravi,

what's Column and Row Delimiter ?

Regards,

Shiva Sahu

[Former Member]

Following.

[former_member198401]

Can you place a template table and check if it is truncating space in the columns as well. What is the data type which are you using to define in the Flat File target column

Regards

Arun Sasi