Delphix Products

 View Only
Expand all | Collapse all

How to preserve more than One header and trailer in a flxed width file? Please help

  • 1.  How to preserve more than One header and trailer in a flxed width file? Please help

    Posted 11-17-2022 11:10:00 PM
    Hi, we are implementing files masking for some of the Fixed width files.
    The File has many headers and many trailer records and they have to be preserved.
    We have tried the header option under record types, but not able to preserve all the header and trailer records.

    Below is the sample. Here we have to preserve the lines starting with 1, 2 & 5 and mask the lines starting with 3
    Please let me know how to preserve the lines highlighted with Red below? thanks in advance.
    1 5TH3RD 00000702 00009 20220829 X
    2 00005 X
    3 0001 0023456789 000000001015123456 0000005536 
    3 0002 0023456789 000000001015245678 0000016068
    3 0003 0023456789 000000001015256789 0000003604  
    3 0004 0023456789 000000001015212345 0000008947
    5 00005 0004 0000190544 X
    2 00009 X

    Thank you!
    Ramesh Kumar
    Cognizant

    ------------------------------
    Ramesh Kumar S A
    Community Member
    Cognizant Technology Solutions
    ------------------------------


  • 2.  RE: How to preserve more than One header and trailer in a flxed width file? Please help
    Best Answer

    Posted 11-18-2022 01:45:00 PM
    Edited by Michael Torok 11-18-2022 02:44:04 PM
    Hi Ramesh,

    I would suggest creating a new Body record type with a pattern that matches the first column value for records you don't want to mask - [125] - at position 1. For this record type, do not make any masking assignments, so those rows will be entirely preserved.

    Regards,

    ------------------------------
    John Leser
    Staff Engineer
    Delphix
    ------------------------------