Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Delimitted text file Issues

Hi team.

I'm trying to load a text file taken from SAP system and load into table using BODS.

I downloaded a text file from SAP BW with the following format with header and data like below:


12345| ABCDE | 34 | SALE | B | CFGUI |1200.00 | X

There are actually 81 fields and its values available in the text file including the header data.

When I try to configure a file format for this input. I have chosed


Column = |

Rows = {new line}

Row with text string = character

Text = None


Style = Headers

When I preview the output for the above settings is strange.

1. It is taking only 71 header fields and remaining fields it is skipping

2. There are 100 records in the file

3. The record values for each row is taken upto 71 fields and the remaining values(71-81 fields) are taken as a second row in the table rather than updating in the remaining 10 fields.

I'm finding it hard to transform the 81 field output data into a text processing file. Each record values are rolling up to the next row rather than updating the corresponding fields.

Has anyone received such issue?




Helpful Answer

Not what you were looking for? View more on this topic or Ask a question