'RE to extract all individual lines not containing
I'm somewhat new to re2 & regexextract, but I'm attempting to extract all lines containing:
FAILED
any attributes (attr#) that are not 0. (attr1, attr2, & attr3 are negligible)
attr8 > 250
Here's my data from cell B2:
/entry_a 0:0:0:0 brand1 SN:7384705 attr1:B2 attr2:[100] attr3:(6) FAILED attr4:0 attr5:0 attr8:255
/entry_b 2:0:0:0 brand2 SN:HS749435 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:33 attr5:0 attr7:0
/entry_c 3:0:0:0 brand2 SN:HS749475 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:0 attr5:0 attr7:0
/entry_d 4:0:0:0 brand2 SN:HS747430 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:16 attr5:0 attr6:212 attr7:212
/entry_e 5:0:0:0 brand2 SN:HS746435 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:14 attr5:0 attr6:1233 attr7:1233
/entry_f 6:0:0:0 brand2 SN:HS74C438 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:0 attr5:0 attr7:0
/entry_g 6:0:1:0 brand2 SN:HS774635 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:135 attr5:0 attr6:3 attr7:3
/entry_h 6:0:2:0 brand2 SN:HS749432 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:60 attr5:0 attr6:12 attr7:12
/entry_i 6:0:3:0 brand2 SN:HS747435 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:0 attr5:0 attr6:842 attr7:842
/entry_j 6:0:4:0 brand2 SN:HS749433 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:0 attr5:0 attr7:0
/entry_k 6:0:5:0 brand2 SN:HS7483F4 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:0 attr5:0 attr7:0
/entry_l 6:0:6:0 brand2 SN:H7D84735 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:1 attr5:0 attr6:190 attr7:190
/entry_m 6:0:7:0 brand2 SN:HS749436 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:0 attr5:0 attr6:11 attr7:11
Here's what I'm looking to get in cell C2:
/entry_a 0:0:0:0 brand1 SN:7384705 attr1:B2 attr2:[100] attr3:(6) FAILED attr4:0 attr5:0 attr8:255
/entry_b 2:0:0:0 brand2 SN:HS749435 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:33 attr5:0 attr7:0
/entry_d 4:0:0:0 brand2 SN:HS747430 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:16 attr5:0 attr6:212 attr7:212
/entry_e 5:0:0:0 brand2 SN:HS746435 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:14 attr5:0 attr6:1233 attr7:1233
/entry_g 6:0:1:0 brand2 SN:HS774635 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:135 attr5:0 attr6:3 attr7:3
/entry_h 6:0:2:0 brand2 SN:HS749432 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:60 attr5:0 attr6:12 attr7:12
/entry_i 6:0:3:0 brand2 SN:HS747435 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:0 attr5:0 attr6:842 attr7:842
/entry_l 6:0:6:0 brand2 SN:H7D84735 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:1 attr5:0 attr6:190 attr7:190
/entry_m 6:0:7:0 brand2 SN:HS749436 attr1:C3 attr2:[3000] attr3:(3) PASSED attr4:0 attr5:0 attr6:11 attr7:11
I've tried different variations of this:
=ArrayFormula(REGEXEXTRACT($B2:B,"(?ms).*"))
which gives me everything or an error, and have yet been able to get everything I need. How do I get there??
++ bonus points if you can inform me how to get this in cell D2:
SN:7384705
SN:HS749435
SN:HS747430
SN:HS746435
SN:HS774635
SN:HS749432
SN:HS747435
SN:H7D84735
SN:HS749436
Thanks in advance!!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
