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:

/1B/XBACAB1  /2B/XBACAB2 /3C/XBACAB3 /4D/XBACAB4 /5E/XBACAB5  /6F/XBACAB6 /7G/XBACAB7 /8H/XBACAB8

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

Delimetters

Column = |

Rows = {new line}

Row with text string = character

Text = None

Input/Output

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?

Thanks

Bala

Tags:

Helpful Answer

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