Forum Discussion
Chaitanya_malir
Helper I
Helper IData Modelling
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 ...
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
MFelix
Super User
Super UserHi 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