How to filter excel for rows containing certain row strings?


(Sebastian Cheung Cqf) #1

Date Time Variable value
08/01/2017 06:00:05 O_T4CHK_zoneA_1_Live 83
08/01/2017 06:00:05 O_T4CHK_totalConcourse_1_Live 510
08/01/2017 06:00:05 ProjQueueTime_T4CHK_zoneA_1_Live 919.048
08/01/2017 06:00:05 Flow_T4CHK_zoneA_1_Live 0
08/01/2017 06:00:05 ExpQueueTime_T4CHK_zoneA_1_Live 357.688
08/01/2017 06:00:05 F_T4CHK_zoneB_1_Live 0
08/01/2017 06:00:05 PTime_T4CHK_zoneC_1_Live 114.911
08/01/2017 06:00:05 F_zoneC_1_Live 0
08/01/2017 06:00:05 ETime_T4CHK_zoneC_1_Live 355.909
08/01/2017 06:00:05 Flow_T4CHK_zoneD_1_Live 0
08/01/2017 06:00:05 Flow_T4CHK_zoneE_1_Live 0
08/01/2017 06:00:05 Flow_T4CHK_zoneF_1_Live 0
08/01/2017 06:00:05 Flow_T4CHK_zoneG_1_Live 0
08/01/2017 06:00:05 Flow_T4CHK_zoneH_1_Live 0
08/01/2017 06:00:10 O_T4CHK_zoneA_1_Live 81
08/01/2017 06:00:10 P_T4CHK_totalConcourse_1_Live 499
08/01/2017 06:00:10 PTime_T4CHK_zoneA_1_Live 736.277
08/01/2017 06:00:10 F_T4CHK_zoneA_1_Live 0
08/01/2017 06:00:10 Exp_T4CHK_zoneA_1_Live 404

So that the output would be

Date Time Variable value
08/01/2017 06:00:05 Flow_T4CHK_zoneD_1_Live 0
08/01/2017 06:00:05 Flow_T4CHK_zoneE_1_Live 0
08/01/2017 06:00:05 Flow_T4CHK_zoneF_1_Live 0
08/01/2017 06:00:05 Flow_T4CHK_zoneG_1_Live 0
08/01/2017 06:00:05 Flow_T4CHK_zoneH_1_Live 0

08/01/2017 06:00:10 Flow_T4CHK_zoneD_1_Live 0
08/01/2017 06:00:10 Flow_T4CHK_zoneE_1_Live 0
08/01/2017 06:00:10 Flow_T4CHK_zoneF_1_Live 0
08/01/2017 06:00:10 Flow_T4CHK_zoneG_1_Live 0
08/01/2017 06:00:10 Flow_T4CHK_zoneH_1_Live 0


etc

(Mark Walkom) #2

Use the CSV filter.


(system) #3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.