Data Modelling

[Chaitanya_malir]

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

[Chaitanya_malir]

@MFelix Thank you so much

[MFelix · 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