About Umesh

I am Software consultant with approx 7 years of experience mainly in Business Intelligence and data warehousing assignments using Talend. Writing is not my passion but i am doing it to help others. if you have any special case where you want me to demonstrate then please post me.

One thought on “Read Multi Schema Positional File using tFileInutMSPositional

  1. Hi,
    I’m very new to talend. I have a multi schema input file:
    000001-000010 Saunders, Fred status:A from: 08/01/2016 to: 09/01/2016
    Amt 40.76 16.25
    Usg 11600.00
    001014-000200 blythe, jeremy status:B from: 08/01/2016 to: 09/01/2016
    Amt 30.55 16.25 75.50
    Usg 2100.00
    ….
    I need to parse it into
    000010|Saunders|Fred|A|08/01/2016|09/01/2016|40.76|16.25||11600
    000200|blythe|jeremy|B|09/01/2016|09/01/2016|30.55|16.25|75.50|2100.00
    The 000xxx- Is ignored. I have tried tFileInputMSDelimited and tFileInputMSPositional. The problem is to separate the HeaderValues for 000xxx, Amt, Usg I need to use wildcards in the HeaderValue field to do something like “00/d/d/d/d-” for the 001014 type entries, where /d is any number. Is there some way to do this?

Leave a Reply

Your email address will not be published. Required fields are marked *