Positional file with multi structure

[PatrickSalv]

Hi all,

I have a flat to load with multiple structure and no delimiters.

An example:

DEBFI 17/07/2024 09:51:40
DEBTA MGDEP
FINTA MGDEP 000000 record
DEBTA MGART
001000720125CL B.NRJ RED BULL .
001003600170CL WH.40%SIR EDWARDS .
FINTA MGART 000002 records
DEBTA MGEAN
3018300004540 00100072.
3018300000245 00100072.
3011932004971 00100360.
FINTA MGEAN 000003 records
FINFI 000005 records

The file has a first level with tag DEBFI ending by tag FINFI.

The second level level has a tag DEBTA and ending by FINTA.

Each DEBTA has a specific structure:

MGART:

Product on 8 first characters, and name of product after

MGEAN:

EAN on 13 first characters, and product on 8 characters

How can i read and load this file?

Thx

[Shicong_Hong]

Hello 

I'm unsure of the specific output you're hoping for. My suggestion is to utilize tFileInputRegex component to read the file, use regular expressions to initially capture the data between DEBTA and FINTA, and subsequently proceed with processing the data.

Regards

Shicong