I have group of text files in a folder . where each file consists of so much of Data like this
But i need data that starts from the line containing "51sdcss RESPONSE_PDU 0x62,FD,02". i cannot just do it by simply removing top rows since . in another text files in folder the number of top rows might be different.
Could any one help me with this.
Thanks in Advance.
You can find data here
| [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 |
1 ACCEPTED SOLUTION
Hi @Chaitanya_malir ,
If you want to always get the text from the line that starts by "51sdcss RESPONSE_PDU 0x62,FD,02" what you can do is:
- Create a new column with the following code:
if Text.Start ([Column1],20) = "51sdcss RESPONSE_PDU" then 1 else null
- Do a fill down on the new column
- Filter all blank on thenew column
- Delete the new column and setup all the rest of your data
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
Hi @Chaitanya_malir ,
If you want to always get the text from the line that starts by "51sdcss RESPONSE_PDU 0x62,FD,02" what you can do is:
- Create a new column with the following code:
if Text.Start ([Column1],20) = "51sdcss RESPONSE_PDU" then 1 else null
- Do a fill down on the new column
- Filter all blank on thenew column
- Delete the new column and setup all the rest of your data
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
Helpful resources
Power BI Monthly Update - April 2026
Check out the April 2026 Power BI update to learn about new features.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
FabCon &SQLCon Highlights
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
