I have a log file from equipment at my job that I am trying to organize to make it a more useful to me. I want to look through over 5000 rows in column A and when it finds a cell with the words "BHS ASSOCIATION FULLY AVAILABLE", it cuts it out and then paste it 3 rows up and one column over in B. Basically in column B directly across from the row in column A that has "REPT:CELL" in it.
Here is an example of the output from my log file that I pasted into column A.
<tbody>
</tbody>
Here is an example of the output from my log file that I pasted into column A.
58 REPT:CELL 945 CDM 2, CRC, HEH |
SUPPRESSED MSGS: 0 |
ERROR TYPE: ONEBTS MODULAR CELL ERROR |
SET: MLG-BHS ASSOCIATION FULLY AVAILABLE |
MLG 1 DCS 2, SM 14, PSU 0, BHS 1 |
01 05 02 00 00 01 01 00 |
01 00 00 00 02 0E 01 00 |
00 00 00 00 01 10 20 03 |
00 00 00 |
10/11/18 02:58:41 #239639 |
59 REPT:CELL 1025 CDM 1, CRC, HEH |
SUPPRESSED MSGS: 0 |
ERROR TYPE: ONEBTS MODULAR CELL ERROR |
SET: MLG-BHS ASSOCIATION FULLY AVAILABLE |
MLG 1 DCS 2, SM 12, PSU 0, BHS 1 |
01 05 02 00 00 01 01 00 |
01 00 00 00 02 0C 01 00 |
00 00 00 00 01 10 10 01 |
00 00 00 |
10/11/18 02:59:02 #240536 |
<tbody>
</tbody>