Skip to Content

Processing multi delimited single flat file

Dec 07, 2016 at 06:14 AM


avatar image
Former Member

Hello Guys,

I have a flat file that contains multiple records type. Each of these records are delimited in different format with single header. The way we are handling currently is extract these same type of records and put it in single flat file so the format is unified and we can process the file as it is delimited properly. but there are limitation we are facing due to this. Is there a way we can achieve this in sap bods?

File format is as below.

ABCD Text1 Tex3 Text5 Text9
JFHS hfyrjdldj fhfjdkdj djfhfsdfh sdfhfksdfj sdfhfksdfh hfsdfhf sdfksdfh sdfkhsd
DEFHF jfhfbf fjfhfjfh jfhfhfhf fjjfhfjfh fjfhfjk jfhfhfh

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Dirk Venken
Dec 07, 2016 at 02:38 PM

I load such file into a 1-column table.

Then build data flows to split the content according to record type.Use the word and word_ext built-in functions to get the desired results.

10 |10000 characters needed characters left characters exceeded