differend recordtypes in plaintext file

[CrazyBird]

We are replacing an old host application with a new JEE- Application. To get data from other systems into the application there are existing textfiles, which are imported in our application.

 

These interfaces should not be changed. There is one file per inerface, within one and the same file there are different kinds of plain text files:

 

Every kind of dataset is defined within the first 4 characters of the line:

 

For example "CUST" tells us that the line is the definition of the customer, which should be updated.

This dataset is followed by a one or more sets with "ADDR" which indicates that this line contains address - information to the customer.

 

Then the next customer follows in another "CUST" line.

 

So now let's imagine that customers exist in a database and that I have to create or update the address- entries for these customers.

 

How do I have to do this with JasperETL? Problem is that there are no fixed positions which are valid for the whole file but only for a dataset type so I'm not able to use the FileInputPositional- compontent available in JasperETL.

 

Example:

 

CUSTJohn Doe

ADDR12345London Street 4

 

Thanks for your help!

 

Stefan