Data shaping

[Chaitanya_malir]

Hi Guys,

I am new to powerBI. I have multiple text files inside a folder whose format is like this 

I want to extract the data starting from "RESPONSE_PDU       0x62,FD,02" . i cant remove simply top rows since the other text files may not contain same rows. so can i do it in other way rather than removing top rows. because multiplec text files can be added into that folder and dash board must be updated dynamically

Thanks in Advance,

[mussaenda]

Hi @Chaitanya_malir 

Please provide a sample file where we can use the data to solve your issue.

With screenshot, we cannot type manually.

Thank you

[Chaitanya_malir]

[Tester]
Negative response received [NRC] 0x34 [NRC-Text] authenticationRequired
5hf91343.812dwq REQUEST_PDU 0x10,03
Response State not acknowledged
ghf294434.8wdedhed RESPONSE_PDU 0x7F,10,34
[Tester]
5gh942.81999 REQUEST_PDU 0x22,01,82
Response State acknowledged
gjg4942.8r3f3q RESPONSE_PDU 0x62,01,82,80,DD,45,58,CC,84,CC,0A,C1,64,D5,18,EC,A6,45,06,5B,96,14,36
[Tester]
gh05036.8qwdq REQUEST_PDU 0x22,F1,90
Response State acknowledged
50hfdh036.8dwdf RESPONSE_PDU 0x62,F1,90,3F,3F,3F,3F,3F,3F,3F,3F,3F,3F
[Tester]
505f4.8wedwf REQUEST_PDU 0x31,01,02,60,00,00,00,00,01,8C,30,82,01,88,30,82,01,30,A0,03,02,01,02,02,09,02,C4,9A,5B,3F
,7E,00,00,02,30,0F,06,0D,2B,06,01,04,01,96,64,03,06,83,7D,05,6E,30,12,31,10,30,0E,06,03,55,04
,03,0C,07,41,42,30,30,30,30,31,30,1E,17,0D,32,32,31,30,31,32,31,31,31,31,35,37,5A,17,0D,32,32
,31,30,32,36,31,31,31,31,35,37,5A,30,12,31,10,30,0E,06,03,55,04,03,0C,07,52,4F,4D,48,55,42,45
,30,34,30,0F,06,0D,2B,06,003,06,83,7D,05,6E,03,21,00,34,60,03,25,30,DD,6F,41,9D
,FC,BD,F4,9E,E8,42,16,FC,60,70,A3,81,8E,30,81,8B,30,17
,06,0D,2B,06,01,04,01,96,64,03,06,83,7D,05,65,01,01,FF,04,03,04,01,03,30,17,06,0D,2B,06,01,04
,01,96,64,03,06,83,7D,05,6B,01,01,F,02,30,0F,06,0D,2B,06,01,04,01,96,64,03,06,83,7D,05,6E,03
,41,00,24,FD,79,5B,52,75,F8,94,DB,F6,04,71,50,A0,61,72,73,85,AE,23,E0,2A,B7,9C,DF,31,C9,C8,4A
,0F,EC,FF,4B,24,86,F2,0E,FF,4A,F4,69,71,CF,9D,26,78,6A,D6,C4,61,28,4C,34,39,07,55,95,14,85,32
,A2,A8,14,07
Response State acknowledged
505dwdd RESPONSE_PDU 0x71,01,02,60,00,00,00,20,7C,E9,0E,29,4D,7A,C0,8E,FB,9B,42,4E,41,B8,16,07,BD,31,3A,F1,05,7D
,ED,B2,00,66,26,D4,1A,B2,CE,FE,00,00,00,00
[Tester]
505cdss REQUEST_PDU 0x31,01,02,60,00,01,00,00,00,40,39,4C,DB,D3,B3,90,FC,00,94,D9,E8,58,D2,04,F8,CF,02,F4,08,A4
,83,E5,8D,4C,04,1D,36,E0,29,90,1C,25,5E,BA,4D,2D,95,A4,87,F6,E0,E7,48,B7,7B,96,70,C0,0C,AC,71
,A7,31,05,98,42,52,FF,83,27,6F,B5,EE,05
Response State acknowledged
505sdcs RESPONSE_PDU 0x71,01,02,60,00,01,00,00,00,00,00,00
[Tester]
Response State acknowledged
[Tester]
505sdcs REQUEST_PDU 0x10,03
Response State acknowledged
5058dcs RESPONSE_PDU 0x50,03,00,14,00,C8
[Tester]
Response State acknowledged
[Tester]
[Tester]
505ccsdc REQUEST_PDU 0x22,F1,00
Response State acknowledged
5dcscs RESPONSE_PDU 0x62,F1,00,00,50,09,03
[Tester]
51scsc REQUEST_PDU 0x22,FD,02
Response State acknowledged
51sdcss RESPONSE_PDU 0x62,FD,02,00,00,1A,00,01,00,00,02,00,00,03,00,00,04,00,00,05,05,00,06,E4,00,07,1A,00,08,00
,00,09,00,00,0A,00,00,0B,00,00,0C,05,00,0D,0A,00,0E,1A,00,0F,E4,00,10,00,00,11,00,00,12,00,00
,13,05,00,14,0A,00,15,1A,00,16,00,00,17,00,00,18,00,00,19,00,00,1A,05,00,1B,0A,00,1C,0B,00,1D
,00,00,1E,00,00,1F,00,00,20,00,00,21,00,00,22,00,00,23,00,00,24,00,00,25,00,00,26,0B,00,27,00
,00,28,00,00,29,00,00,2A,00,00,2B,00,00,2C,E4,00,2D,00,00,2E,E4,00,2F,00,00,30,00,00,31,00,00
,32,00,00,33,00,00,34,00,00,35,00,00,36,00,00,37,E4,00,38,00,00,39,E4,00,3A,00,00,3B,E4,00,3C
,00,00,3D,00,00,3E,00,00,3F,00,00,40,00,00,41,E4,00,42,00,00,43,00,00,44,E4,00,45,E4,00,46,E4
,00,47,E4,00,4vhmgmg,htu,4D,0A,00,4E,00,00,4F,00,00,50,00,00
,51,00,00,52,00,00,53,00,00,54,00,00,55,00,00,56,0D,00,57,06,00,58,E4,00,59,06,00,5A,E4,00,5B
,00,00,5C,0A,00,5D,0A,00,5E,00,00,5F,00,00,60,00,00,61,0A,00,62,00,00,63,E4,00,64,E4,00,65,32
,00,66,00,00,67,00,00,68,00,00,69,00,00,6A,00,00,6B,00,00,6C,00,00,6D,00,00,6E,00,00,6F,00,00
,70,50,00,71,0A,00,72,0A,00,73,E4,00,74,5A,00,75,0A,00,76,0A,00,77,E4,00,78,0A,00,79,13,00,7A
,09,00,7B,E4,00,7C,09,00,7D,00,00,7E,00,00,7F,E4,00,80,E4,00,81,00,00,82,00,00,83,00,00,84,00
,00,85,00,00,86,12,00,87,E4,00,88,12,00,89,0A,00,8A,0A,00,8B,E4,00,8C,0A,00,8D,00,00,8E,00,00
,8F,14,00,90,E4,00,91,02,00,92,14,00,93,E4,00,94,00,00,95,00,00,96,00,00,97,00,00,98,00,00,99
,00,00,9A,00,00,9B,00,00,9C,00,00,9D,00,00,9E,E4,00,9F,00,00,A0,00,00,A1,E4,00,A2,00,00,A3,00
,00,A4,14,00,A5,00,00,A6,00,00,A7,00,00,A8,00,00,A9,14,00,AA,00,00,AB,00,00,AC,21,00,AD,00,00
,AE,00,00,AF,00,00,B0,0A,00,B1,0A,00,B2,42,00,B3,00,00,B4,0C,00,B5,09,00,B6,09,00,B7,13,00,B8
,09,00,B9,42,00,BA,E4,00,BB,12,00,BC,00,00,BD,E4,00,BE,12,00,BF,12,00,C0,12,00,C1,12,00,C2,00
,00,C3,21,00,C4,12,00,C5,28,00,C6,00,00,C7,24,00,C8,14,00,C9,14,00,CA,00,00,CB,13,00,CC,09,00
,CD,00,00,CE,00,00,CF,00,00,D0,00,00,D1,00,00,D2,00,00,D3,00,00,D4,16,00,D5,16,00,D6,E4,00,D7
,16,00,D8,16,00,D9,E4,00,DA,00,00,DB,00,00,DC,E4,00,DD,00,00,DE,E4,00,DF,00,00,E0,12,00,E1,12
,00,E2,12,00,E3,12,00,E4,12,00,E5,12,00,E6,00,00,E7,00,00,E8,00,00,E9,12,00,EA,12,00,EB,E4,00
,EC,E4,00,ED,12,00,EE,E4,00,EF,04,00,F0,E4,00,F1,E4,00,F2,28,00,F3,E4,00,F4,28,00,F5,28,00,F6
,0A,00,F7,E4,00,F8,E4,00,F9,06,00,FA,00,00,FB,06,00,FC,E4,00,FD,00,00,FE,E4,00,FF,00,01,00,0A
,01,01,00,01,02,0A,01,03,00,01,04,00,01,05,00,01,06,00,01,07,00,01,08,00,01,09,00,01,0A,00,01
,0B,00,01,0C,00,01,0D,00,01,0E,00,01,0F,00,01,10,00,01,11,00,01,12,00,01,13,00,01,14,00,01,15
,00,01,16,00,01,17,14,01,18,00,01,19,00,01,1A,09,01,1B,13,01,1C,03,01,1D,03,01,1E,12,01,1F,00
,01,20,14,01,21,00,01,22,03,01,23,05,01,24,05,01,25,E4,01,26,09,01,27,14,01,28,E4,01,29,00,01
,2A,09,01,2B,24,01,2C,E4,01,2D,09,01,2E,14,01,2F,00,01,30,12,01,31,E4,01,32,00,01,33,E4,01,34
,05,01,35,14,01,36,00,01,37,00,01,38,00,01,39,00,01,3A,E4,01,3B,05,01,3C,00,01,3D,00,01,3E,00
,01,3F,00,01,40,00,01,41,00,01,42,00,01,43,00,01,44,00,01,45,00,01,46,00,01,47,00,01,48,00,01
,49,00,01,4A,00,01,4B,00,01,4C,00,01,4D,00,01,4E,00,01,4F,00,01,50,00,01,51,00,01,52,00,01,53
,00,01,54,00,01,55,00,01,56,00,01,57,00,01,58,00,01,59,00,01,5A,00,01,5B,00,01,5C,00,01,5D,00
,01,5E,00,01,5F,00,01,60,14,01,61,00,01,62,00,01,63,00,01,64,00,01,65,00,01,66,05,01,67,14,01
,68,00,01,69,00,01,6A,00,01,6B,00,01,6C,00,01,6D,05,01,6E,14,01,6F,00,01,70,00,01,71,00,01,72
,00,01,73,00,01,74,05,01,75,14,01,76,00,01,77,00,01,78,00,01,79,00,01,7A,00,01,7B,05,01,7C,00
,01,7D,00,01,7E,00,01,7F,14,01,80,00,01,81,00,01,82,00,01,83,00,01,84,00,01,85,00,01,86,00,01
,87,00,01,88,42,01,89,00,01,8A,00,01,8B,00,01,8C,00,01,8D,01,01,8E,01,01,8F,00,01,90,00,01,91
,00,01,92,00,01,93,00,01,94,00,01,95,00,01,96,00,01,97,00,01,98,00,01,99,00,01,9A,00,01,9B,28
,01,9C,00,01,9D,05,01,9E,14,01,9F,05,01,A0,00,01,A1,05,01,A2,00,01,A3,05,01,A4,00,01,A5,00,01
,A6,00,01,A7,00,01,A8,00,01,A9,00,01,AA,00,01,AB,00,01,AC,05,01,AD,00,01,AE,00,01,AF,00,01,B0
,00,01,B1,00,01,B2,00,01,B3,00,01,B4,00,01,B5,5F,01,B6,E4,01,B7,0A,01,B8,00,01,B9,14,01,BA,00
,01,BB,00,01,BC,00,01,BD,00,01,BE,00,01,BF,14,01,C0,00,01,C1,00,01,C2,00,01,C3,02,01,C4,00,01
,C5,14,01,C6,00,01,C7,02,01,C8,42,01,C9,05,01,CA,14,01,CB,00,01,CC,00,01,CD,0F,01,CE,01,01,CF
,0A,01,D0,00,01,D1,05,01,D2,00,01,D3,00,01,D4,00,01,D5,0A,01,D6,0A,01,D7,0A,01,D8,00,01,D9,00
,01,DA,00,01,DB,0F,01,DC,E4,01,DD,0E,01,DE,14,01,DF,00,01,E0,00,01,E1,0F,01,E2,0F,01,E3,0F,01
,E4,0F,01,E5,0F,01,E6,0E,01,E7,0E,01,E8,0F,01,E9,0E,01,EA,0F,01,EB,0E,01,EC,00,01,ED,00,01,EE
,00,01,EF,00,01,F0,00,01,F1,00,01,F2,00,01,F3,00,01,F4,00,01,F5,00,01,F6,00,01,F7,00,01,F8,00
,01,F9,00,01,FA,00,01,FB,00,01,FC,00,01,FD,00,01,FE,00,01,FF,00,02,00,00,02,01,00,02,02,00,02
,03,00,02,04,00,02,05,00,02,06,00,02,07,00,02,08,E4,02,09,00,02,0A,00,02,0B,00,02,0C,00,02,0D
,00,02,0E,00,02,0F,00,02,10,00,02,11,00,02,12,E4,02,13,00,02,14,00,02,15,0A,02,16,00,02,17,00
,02,18,00,02,19,00,02,1A,00,02,1B,E4,02,1C,00,02,1D,E4,02,1E,00,02,1F,00,02,20,00,02,21,00,02
,22,E4,02,23,00,02,24,00,02,25,00,02,26,00,02,27,00,02,28,00,02,29,00,02,2A,00,02,2B,00,02,2C
,00,02,2D,E4,02,2E,00,02,2F,E4,02,30,00,02,31,00,02,32,00,02,33,00,02,34,E4,02,35,00,02,36,00
,02,37,00,02,38,E4,02,39,00,02,3A,0A,02,3B,0A,02,3C,0A,02,3D,0A,02,3E,0A,02,3F,0A,02,40,0F,02
,41,5A,02,42,5A,02,43,1E,02,44,E4,02,45,E4,02,46,E4,02,47,19,02,48,19,02,49,E4,02,4A,E4,02,4B
,E4,02,4C,E4,02,4D,E4,02,4E,0F,02,4F,1E,02,50,E4,02,51,06,02,52,1E,02,53,E4,02,54,00,02,55,00
,02,56,E4,02,57,00,02,58,E4,02,59,E4,02,5A,E4,02,5B,E4,02,5C,E4,02,5D,E4,02,5E,E4,02,5F,00,02
,60,E4,02,61,E4,02,62,E4,02,63,E4,02,64,E4,02,65,14,02,66,E4,02,67,E4,02,68,E4,02,69,0A,02,6A
,E4,02,6B,E4,02,6C,E4,02,6D,E4,02,6E,E4,02,6F,0A,02,70,E4,02,71,E4,02,72,0A,02,73,E4,02,74,E4
,02,75,06,02,76,E4,02,77,14,02,78,14,02,79,E4,02,7A,0A,02,7B,0A,02,7C,0A,02,7D,0A,02,7E,01,02
,7F,E6,02,80,11,02,81,00,02,82,0B,02,83,00,02,84,0A,02,85,0A,02,86,05,02,87,05,02,88,05,02,89
,05,02,8A,0A,02,8B,E4,02,8C,5A,02,8D,E4,02,8E,5A,02,8F,E4,02,90,5A,02,91,E4,02,92,E4,02,93,1E
,02,94,14,02,95,E8,02,96,13,02,97,E4,02,98,09,02,99,E4,02,9A,09,02,9B,00,02,9C,00,02,9D,ED,02
,9E,24,02,9F,5A,02,A0,E4,02,A1,0A,02,A2,00,02,A3,E4,02,A4,12,02,A5,E4,02,A6,E4,02,A7,E4,02,A8
,E4,02,A9,E4,02,AA,E4,02,AB,E4,02,AC,E4,02,AD,05,02,AE,E4,02,AF,E4,02,B0,14,02,B1,E4,02,B2,00
,02,B3,E4,02,B4,00,02,B5,00,02,B6,00,02,B7,0A,02,B8,E4,02,B9,E4,02,BA,0A,02,BB,E4,02,BC,E4,02
,BD,E4,02,BE,0A,02,BF,E4,02,C0,E4,02,C1,0A,02,C2,00,02,C3,00,02,C4,0F,02,C5,0F,02,C6,0E,02,C7
,E4,02,C8,E4,02,C9,00,02,CA,E7,02,CB,0E,02,CC,0A,02,CD,0A,02,CE,E4,02,CF,0A,02,D0,0C,02,D1,06
,02,D2,0C,02,D3,13,02,D4,09,02,D5,1C,02,D6,1A,02,D7,09,02,D8,28,02,D9,E4,02,DA,12,02,DB,E4,02
,DC,12,02,DD,12,02,DE,00,02,DF,00,02,E0,E4,02,E1,E4,02,E2,12,02,E3,E4,02,E4,12,02,E5,24,02,E6
,12,02,E7,16,02,E8,09,02,E9,E4,02,EA,09,02,EB,00,02,EC,00,02,ED,00,02,EE,00,02,EF,E4,02,F0,00
,02,F1,00,02,F2,0A,02,F3,0A,02,F4,00,02,F5,0A,02,F6,00,02,F7,02,02,F8,00,02,F9,00,02,FA,00,02
,FB,00,02,FC,00,02,FD,E4,02,FE,E4,02,FF,0A,03,00,0C,03,01,00,03,02,00,03,03,00,03,04,00,03,05
,00,03,06,03,03,07,05,03,08,00,03,09,00,03,0A,00,03,0B,02,03,0C,00,03,0D,05,03,0E,00,03,0F,00
,03,10,E4,03,11,E4,03,12,E4,03,13,00,03,14,E4,03,15,0F,03,16,0E,03,17,0E,03,18,00,03,19,E4,03
,1A,0F,03,1B,0E,03,1C,00,03,1D,E4,03,1E,E4,03,1F,E4,03,20,00,03,21,0A,03,22,0A,03,23,0A,03,24
,5A,03,25,E4,03,26,E4,03,27,E4,03,28,00,03,29,0A,03,2A,0A,03,2B,0A,03,2C,5A,03,2D,18,03,2E,E4
,03,2F,00,03,30,E4,03,31,00,03,32,E4,03,33,E4,03,34,00,03,35,1F,03,36,E4,03,37,E4,03,38,00,03
,39,E4,03,3A,E4,03,3B,E4,03,3C,00,03,3D,00,03,3E,00,03,3F,00,03,40,00,03,41,00,03,42,00,03,43
,00,03,44,E4,03,45,00,03,46,00,03,47,00,03,48,00,03,49,E4,03,4A,00,03,4B,00,03,4C,00,03,4D,00
,03,4E,E4,03,4F,00,03,50,00,03,51,00,03,52,00,03,53,00,03,54,00,03,55,00,03,56,00,03,57,00,03
,58,00,03,59,00,03,5A,00,03,5B,00,03,5C,00,03,5D,00,03,5E,00,03,5F,00,03,60,23,03,61,00,03,62
,00,03,63,00,03,64,00,03,65,00,03,66,00,03,67,00,03,68,00,03,69,00,03,6A,00,03,6B,00,03,6C,00
,03,6D,0A,03,6E,0A,03,6F,00,03,70,00,03,71,0A,03,72,0A,03,73,05,03,74,32,03,75,0A,03,76,0A,03
,77,00,03,78,E4,03,79,0A,03,7A,E4,03,7B,0A,03,7C,32,03,7D,0A,03,7E,0A,03,7F,E4,03,80,00,03,81
,00,03,82,1E,03,83,00,03,84,00,03,85,00,03,86,00,03,87,00,03,88,00,03,89,00,03,8A,00,03,8B,00
,03,8C,00,03,8D,01,03,8E,18,03,8F,00,03,90,00,03,91,00,03,92,00,03,93,00,03,94,00,03,95,E4,03
,96,00,03,97,00,03,98,00,03,99,E4,03,9A,00,03,9B,00,03,9C,00,03,9D,00,03,9E,00,03,9F,00,03,A0
,00,03,A1,00,03,A2,00,03,A3,0A,03,A4,00,03,A5,00,03,A6,00,03,A7,00,03,A8,00,03,A9,00,03,AA,00
,03,AB,00,03,AC,00,03,AD,00,03,AE,00,03,AF,00,03,B0,00,03,B1,00,03,B2,00,03,B3,00,03,B4,00,03
,B5,00,03,B6,00,03,B7,00,03,B8,00,03,B9,00,03,BA,00,03,BB,00,03,BC,00,03,BD,00,03,BE,00,03,BF
,00,03,C0,0C,03,C1,00,03,C2,00,03,C3,00,03,C4,00,03,C5,00,03,C6,00,03,C7,03,03,C8,01,03,C9,00
,03,CA,00,03,CB,00,03,CC,00,03,CD,00,03,CE,00,03,CF,00,03,D0,00,03,D1,00,03,D2,00,03,D3,00,03
,D4,00,03,D5,00,03,D6,00,03,D7,00,03,D8,00,03,D9,E4,03,DA,00,03,DB,00,03,DC,00,03,DD,00,03,DE
,00,03,DF,00,03,E0,00,03,E1,00,03,E2,00,03,E3,00,03,E4,00,03,E5,00,03,E6,00,03,E7,00,03,E8,00
,03,E9,00,03,EA,00,03,EB,00,03,EC,00,03,ED,00,03,EE,00,03,EF,00,03,F0,18,03,F1,00,03,F2,00,03
,F3,00,03,F4,00,03,F5,00,03,F6,00,03,F7,E4,03,F8,00,03,F9,00,03,FA,E4,03,FB,00,03,FC,00,03,FD
,00,03,FE,00,03,FF,00,04,00,00,04,01,00,04,02,00,04,03,00,04,04,00,04,05,00,04,06,00,04,07,00
,04,08,00,04,09,00,04,0A,00,04,0B,00,04,0C,00,04,0D,00,04,0E,00,04,0F,00,04,10,00,04,11,00,04
,12,00,04,13,00,04,14,00,04,15,00,04,16,00,04,17,00,04,18,00,04,19,00,04,1A,00,04,1B,00,04,1C
,00,04,1D,00,04,1E,00,04,1F,00

[mahoneypat]

At your step that shows the binary text files, you can add a custom column with this expression

= Text.AfterDelimiter(Text.FromBinary([Content]), "RESPONSE_PDU 0x62,FD,02,")

Which should yield this (with more rows than this single file example).

You can then wrap that with Csv.Document or Text.Split to parse the text into a table or list, but you'll have to work out that part to get the expected format.

Pat

[Chaitanya_malir]

Hi @mussaenda I have attached the data

Thank you so much

[mussaenda]

Hi @Chaitanya_malir,

Try to copy and paste this inadvanced editor of  a blank query, so you will have the idea of the steps.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("pZpbj922FUb/ipFnNpB4FR95ER/T1kmfDKMIPGNPenGaeFL355eXvc4o9rQxWuDA2KYkap1vb1Lf2ZpXr7569d39h8f7n19/9Vq9+uqb+3ffP/7wz/sXP99/+MeP7z+M4M19H7h78eqbl+X1i+1fxs7wd9/d/+vx9Yvvf3l8uH//+MObftmP71/e//TLDz/f38253MPbuBtrvj52fffxpxcvzz/+6fz2uz//of6pT7NvajPzvJfc6tvH7x/vX7z/8fHF92/++v7Hj3+7v3snc717eKujtcZ+fXy8u7976Dwvz2//8Ptvvj1lvtBUn9LYefqvvpN79xCt7hQxxk8gtFbbrg79HMfnDH95Z+dEP5u35qdP7+9lKnVsqlZlnXKHKkUddvy7JVV25a2qTu2HOotKfpyzeeWyil7tVhn/Ofu7h81txn99/PTx7lMFO3zbVdy+CN5tD2/vHuZUdx/v3j5DP+dSpv2XzzPabu7tyMn93ce3n+CZfQiyaeV7pq+frlJRZhtajfh4inuQRlmMq9a14xPHv8WqmIZWQqHCyXx6XLe1oeVWlc4z6Ffb8W+Xtqs+pvTqMCpUtTnlz3HJ3i/cZ9H0y895lVGu52TV0LyoZy4ouys7b/L0maz7qfYw7mn0/OwcWvHt45QJyqXryesOckUf8M9f8V8pnwCdVrYp26vuGIc6rHVyh7EkntPnc0X6iN6HoP0CP7Og3biyF7NvQ4NY15ytqFxV6wk51XmMu+1+DPaLQk+gUUfP6lR4BHl+iSCSfnmK3DxhV63xVefJPZjzfT6V3OE/zZeZ738sGNmshhBdI21VqyrEUZFd/eBUO1Tsyzur5sdMYVduVrPfVegndFWcSqfSRp398qRyULGo2kZ2S1SlC5nkK7SxP/TvbfO4z9HF1SP1YyQN3X0c05fWM6K0V+FQPqnqxxrpd9N9pjKzHmdtOBXd2F76/am7pFU6xtgWvnDzcH3T+HzLfW6F614FRZ1xEOs4ijL0vW8bFdH6TpdndZ5DxnyMwumIvZpG0aexBXWxg9TZWVXWY0rvx9esVu1pjJQ+03ndUp7dlt7cffjwGzvS/jSJ3YZcXbeewGpUNmMv7DXdD42sxlHofT+veuS2p7rMMuq52A6VpPR6tZxOHXVM08/a61jWI9lxTLaXsZ7cqXIaoug60pJ6WsKomH7aGcby7WUR5gOhL6WuWl/fqfRsS97CEKpLFOey64XXa6LfVoexRLNTZ9fFfWlKP9y9+fBbKd1/vXU/r/Zv3evT1MiNv8gNPAd+PAPu1nNjm1XdpTv+T8zPyulNp372Abx94QO4Q3+O7WWK8RlfISLDr++/90ufu3vfnL7Mu/QZ+v2fvX2dD9lJ0NfXr5LO+FJ2fCyBm59t7JLnGgxcfiDJ/F/kikSQCQpzVI6ezNFk1p2624Ha9aUM1W5kjpH2eenuZI6xt6wrAsFBANQ4c12eubwI4F6fvsN81EvQnvY5CSDTyKWRSyOXdgReptfhqpKGTEOmkUsjly6iSd86ZORkBCgDlNmvKhnIDGQGMgOZQa7uPNasBqi+M8oIUCYzUq4qGcgMchnI7G2n3eVSC5QFyloOOYJRXbc7WMjsPx/+/u7v79TD4y9jL12Zs9zTck933bGUu60zbuy4sUMNhxpuWoMRLKexjd1/3dxFRhIj+SqCKwLkIHOQOchuD8z+vF7neKC8kVk9avinB/c2H4ZyImXtyZOneDx58hSPLwSkyAPl21WlgGwBsu5eJIAs2PHdR+A45AlIUTclMhLnIu0B9mZSBiqomwUZgezm7AO7QP9JJQE5PJDrIIeHVZcFdZDI7p7WjnFA1n9wyEgUxCMRAHWQwwOo47yqdDR5zkTI4i7bZdQcQq5IdUWgIjmM5DCSwxivtRRJZCSRkURGyCK7QKS6EtWVWGsJuZK5qtTtx2JNkCXIEmQJshQ5GagEVLcoaxdM9apSIpEJssxzIFNd3c+tjSCTyGznk2EbfmZVRvYEQWopH9daypE5WJE5S44zcnWPKYdODjUJCg+V/gtdAn1VqfDDqPtrOe5kxy7IVYJs9uXAgSBXQa6Shb5Iya87FBJZkKsgVyWRlbqvJLIi17DFk2J0FlbAI7nKry4ZPgjYzitklURWnjEVqEp1VaBO5DqHXDeVTs2wIUCu7oolQK6T6jqprv6DQc5JBLIY5ccAZP1XgRyH7GziSxqLsVH3/YfTSlRjMXbLLiPksHn5DlONxjbR2O8b+31DrpYZAaohVwOqLblW3tj5dgbWZpHkB62MWAJH4AkCwUEQCcSyyR0yw4WgEpwEkIm32vFWVP8IgNqB2t3TvrTjrfbhrfb5s3mHbIdseKs4g1X3+/RWK6gEazHuy1bdVNKbzKohG95qXqGX4dvnclvBMgv79FbzhhoofXAoXlXSkOn5A3sEhRMrh07mQK7Vi9lmg2adbJDLGEYwK5PMOJnDIJchkQa5DHKZxByZy8mhIYfTVt1UMpBZEmmRy0JmSaQlkZbqskBZoOxxVclCZvlVYKkuC5mFzFJdFigHlAPKAeXMtZYcZA4yB5mDzCGXA8oB5YByQA3f9aSSg8xB5qkuD5mHzCOXB8oDNXzXTIuX6lp38JB5yDxkHjIPma/MQXV5oAJyBaCCvqoUIAvUfaC6AnIF5ApABaACUIHqGr7rSaVAIgNyhSbTH5AdkB3IdQB1INeBXIe/1tIB2TEbFyOA7IDsQK4DuYb5mlvmMF8rQK4IVNyvKkXIImQRsghZRK4IVESuCFQEqvsufdxUipBFEhlJ5DBfcyRBlnZGgErsXQko8V20dyBLkCXIEmQJsoRcqTArOUzkMCFX3q4qZRKZIcvIlSHr5mssmH2Yr7UvdfO1nlgZqBzly+d0raUMWUauDFmGLFNdBbkKUAWownuAYq8qFeq+IFc3X3Ii1dXN19Kkmy85GagC1PBd8xsWqqu0JyewY772ab7mZBWyilwVuarjKk+AXBW5aryqVEnkMF+To/IQGuZrMlWqq5LIE6hzl6u675LArED8kmXYEXiZdZivFRwciowkRjIjyHWSw/O81tIJWYOskciGXA25GnI1FmMjh42Sb8dVpUbdN+RqJLJB1iBrVJeYr1v7ar1N2nihtNE1w3xpzJfGfGnMl8Z86WG+hqoa88Xv4hFkgkJwaR9pzJfGfGnMl8Z8Tfe8pt+B2oHaV3VpfJdePS25g8Z8acyXpo2mh/mSWSHbKyNA7UBpoMR3iUoaMg2Zhkwjl4ZMI5cGSgOlgdLIpctVJQ2Zhkw3GTGQGeQS86XpaenR05KTgZq+66aSgcyQSAOZSSKwyQSFoBKcBE2C4bvaTSW7TMn8PSuBmRprGluaxpZeja0ZhJk0PcyXBJFDiSA/rWk9zJcEyDXM13wf0c3XuqHb5JBbvyLmuwI5ZDhEDqfvuqnkIHPI5ZDLQeYgc1SXA8oB5U6Cdq0lD5nfCaguD5lHLr+2ej3Ml4wEAqB8lGz4dFXJQ+Yh85B5yDyJDEAFoKTppWl66eG7bq3I+cJv6RogC0FYw0GAXIHqClRXoLoC1RXWQ0hUGp2vOf2xOt8a86Wn+cozoO6H+ZpzHGwTx/KqevquFRwE9JfW/yA7kKubr1W8B3J18yUjLMa4yUhErkgO4yj5m0rRihTdfI2HjZ5/6TAf65FEDvM16z4iV0yMsE1E9q7uu87bO49hvvS6oglQIpFply+W2CYSiUyrLaGH+ZIRcpiASse1lhJkibpPyJWorlRF0kR1JeTKm6iQkSvr64rLkGVWZGYDy+yqYr70MF9yMlCZHGagskCtO2QSmdnAMmQFuQpyFeQqVFexsrkUR7CMRA/CVaUCWWFX7ebrnNasZK6g7gt1X5CrsBiH7yozGHvXTaWqGTZSQsN8zToZna91yM8Hn57max065nNI0/TSw3et9Nd8VambLxmuBDyEKo/HE7lOEilNLz3Ml4xQXd13reI85TvIcJgPcT3Xw0Q8ITup+5O6P6l7MV96vuBdATmcvuumUmObaGxgw3ytgOpqbBON6mrLQOtlvmZADsV3iUoNsgZZo7oaiWwrkat+6PiMeNn5FRgCS3DpLxn5K5fxWRuYofNlMF8G82VkO5Q/hlkjlatORi79JTPM12A1Y2+VQBNAtltGVt2bmbf5ZzJ7IABqXzmUvsaeuCJzImRivqYxkKBJIOZrNZungFoTGAJ5Arkkf58jl3qCQACZjlyaCDJBYZ46v4lZLxRvKknna/7BzZrVkEiDXNL5MrxQNLPpNb+8AcoAJU0vUUneKho6X4a3iobOl6HzZXihaGh6GZpehqaXoenVA3OtJUsipfNl6HwZOl+GzpfBfBmaXoaml6HpZVbT66aSJZEWMgeZg8xB5qguh1wOKAeU+C75Dg4yR907yBxkDjKHXA65HFB+vZY2NL16oK8qecg8ZB4yD5lHLg+UB8oD5YHy5aqSr1J0/iSALCBXoO4DdR+MrONuvsxc4vLG0fDGUVQKkIVDshGo+0B1Beq+my+ZDKgAVGAxHkAd+1WlY7log/kydL4MnS9D58vQ9DLTfK0AuQ7kmk2vm0oHiZTOlxnmay3NA7kiZJFERqorAhWBiu66L0XIImQRskjdR8giiYxARaorUl0RqLRdVUqQJcgSG1iCLCFXAioBlYBKyJXSVaUEWYIsQZYgS5Bl5MpAZaAyconvEpUyZBmyDFmGLEOWkSsDlYHKQGWgcruqtP66awSQFcgKZAW5ClAFqNH0mgu6+65VKyVeVSqQFcgKZAWyAllBropcFagKlDS9RKUKWYWsQlaRqyJXpboqUBWoClQFqp5XlSpkJ2QnZCdkJ3KdQJ1AnUCdQJ3HVaWTRJ6QnZCdkJ2Qnch1AtU2WZ4NKGl6iUoNsgZZg6xB1ng8NuRqQDX2rgZUA6rVq0oNMul8rbtt/M3sCjSBIbAEjsATXPpLFvNlMV8W82XpfFnMl+WNo8V8WZpelqaXpelln5zxGoZsh2yHbIdM/prLYr4sTS9L08tO37WCS39p/kWmBJDJa8fX/wY=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Added Custom" = Table.AddColumn(Source, "For Group", each "A"),
    #"Grouped Rows" = Table.Group(#"Added Custom", {"For Group"}, {{"Count", each _, type table [#"[Tester]"=nullable text, For Group=text]}}),
    #"Added Custom1" = Table.AddColumn(#"Grouped Rows", "Custom", each let GetList = 
Table.Column([Count], "Column1"),

ExtractList = 
Text.Combine(List.Transform(GetList, Text.From), "#(lf)"),

AfterDelimiter = 
Text.AfterDelimiter(
    Text.Upper(ExtractList), "RESPONSE_PDU 0X62,FD,02"),

Split = 
Splitter.SplitTextByDelimiter("#(lf)", QuoteStyle.Csv)(AfterDelimiter)

in Split),
    #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom1", "Custom")
in
    #"Expanded Custom"

i added a column so I can group them and create a list, extracted the list, get the data you only need, then expanded to new rows.

It is better if you will get the files from the folder and you will do the t rasnformation in one file

then it will be applied to all other files.

hope this helps.