Forum Discussion

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
3 years ago

File with Pipeline delimiter

Dear All,

 

I have a set of files in a folder with same format of column header and as observed in same .txt file it is having data with headers column are available with another set of new record with data.

 

snapshot for your reference:

 

 

Please suggest.

 

Regards,

Rajendra

 

 

Need Help

2 Replies

  • Dhairya's avatar
    Dhairya
    Icon for Solution Supplier rankSolution Supplier
    3 years ago

    Hey rajendraongole1 
    Can you please share the sample input(after removing sensitive information) and the expected output so that I can try it on my system to provide you with an efficient solution?

    • rajendraongole1's avatar
      rajendraongole1
      Icon for Super User rankSuper User
      3 years ago

      Thank you Dhairya - Please find the sample dataset in text format.

       

      in .txt

      --------------------------------------------------------------------------------
      | P|Meldung |Menge|A|Datum |Uhrzeit |Gew.Ende |Materialkurztext
      |--------------------------------------------------------------------------------
      | |041315819| 1| |02.08.2023|14:12:16| |HBB10.
      | |941307648| 1| |15.06.2023|09:26:33| |STATOR-

      --------------------------------------------------------------------------------------------
      --------------------------------------------------------------------------------------------
      | P|Meldung |Menge|A|Datum |Uhrzeit |Gew.Ende |Materialkurztext
      |-------------------------------------------------------------------------------------------
      | |121319089| 1| |25.08.2023|10:34:33| |MSTC-P01.2-M1-NN-NN-NN-FW
      | |941317961| 1| |16.08.2023|13:35:46| |SFFA 4.0230.030-00.071

      data is available in below format