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êsHi @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 Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
