Processing multi delimited single flat file

[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.

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

[former_member187605]

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.