Power Query or any other solution
Dear Experts,
I have a data in the below format(attached txt file too).
Each Packet( example for Packet-1) has the same structure.
I want to export , it to excel , with the Packet and the data under “Meta Log Buffer” as below for 1st packet.
Attached the result for just 1st Packet, the actual log file may have more than ~1000s of such Packets.
Could you please share some PQ script etc to fetch the data from the attached txt file(seems txt file not supported as attachment so zipped it) into the above format.
Thanks in Advance,
Br,
Anupam
Dear Experts, I have a data in the below format(attached txt file too).Each Packet( example for Packet-1) has the same structure.I want to export , it to excel , with the Packet and the data under “Meta Log Buffer” as below for 1st packet.Attached the result for just 1st Packet, the actual log file may have more than ~1000s of such Packets.Could you please share some PQ script etc to fetch the data from the attached txt file(seems txt file not supported as attachment so zipped it) into the above format. Thanks in Advance,Br,Anupam Read More