SAP MII V15 - Import and processing of flat file (TXT) transaction

[Former Member]

Hello,

Here are my needs:

I have to deal TXT files in a transaction (over 1,000 units) with undefined name. These files are stored in a single directory.

These files are not fully standardized (no separator, no tag).

But I can indentify file values with key labels (Exemple: "PRODUCTION TIME:      11:03:35").

Can you help me identify how to structure my transaction (Text_Loader, FlatFileToDoc...) ? How to upload my files? What Action block use? How to read my values?

Thank you in advance for your help.

Guillaume V.

[Former Member]

Hi Vendeville Guiilaume,

Can you please attach sample txt file.

Regards,

Raviteja.

[Former Member]

Hello Raviteja and thank you for your return.

Here is attached an example file structure that I can have.

For example, in this file, I have to take the value of the "TIME PRODUCTION" which is "0:25:00".

It can be any line, but always still 7 characters after the wording "TIME PRODUCTION".

Thank you

GV12345.txt.zip

[Former Member]

I imagine using the block action "Text Loader" to load flat files.

But I do not know how to read and returned identifiable by a label "TIME PRODUCTION" in my example?