|151||7-19-2010 0:31 PM - Data Export|
|153||7-19-2010 0:31 PM - Report for Voice System name: xyz-123 ANYWEHRE USA - list usage exten 20063|
|160||7-19-2010 0:31 PM - Data Export|
|162||7-19-2010 0:31 PM - Report for Voice System name: xyz-123 ANYWEHRE USA - list usage exten 20064|
|167||7-19-2010 0:32 PM - Data Export|
|169||7-19-2010 0:32 PM - Report for Voice System name: xyz-123 ANYWEHRE USA - list usage exten 20070|
|175||7-19-2010 0:32 PM - Data Export|
I have this data shown below, I import it from a .csv file into Excel. Each line which begins with the date stamp and ends with "list usage exten XXXXX" is considered the start of a new record and the rows that follow until the next similar line are all part of that one record. **Note this file might be 30000 rows or greater. list usage extnesion all
2) Now with the data like this, I need to look through the file for any record which contains only one row (for example the record on row 159) . I want only to show those records (possibly copy them to another worksheet).
Any guidance/help would would be greatly appreciated.
Thanks in advance,