Skip to Content
avatar image
Former Member

Processing multi delimited single flat file

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    Add comment
    10|10000 characters needed characters exceeded