jaydee
06-07-2016, 07:01 PM
Hi guys,
I have a list of data and I am trying to filter for certain text. I tried using the wildcards ?, ~, and *, but I can't get it to work properly.
I want to filter for anything with a character, followed by a dash, and 5 numbers (i.e. M-16263, B-16252)
For example, out of the list below, I am trying to filter for "BD BAKER KAUAI LLC/A-16082", "BEAVERS/H-16289", "BLAISDELL/K-16276", "BLANCO-MEDEIROS/B-16288".
Can someone help please? Thank you.
BD BAKER KAUAI LLC/A-16082
BEADEL
BEADEL
BEADEL
BEAVERS/H-16289
BEK - KAANAPALI OCEAN RESORT
BELFOR HAWAII PROPERTY RESTORATION
BENEDICT (MDL 600)
BENJAMIN VERGARA / 25TH
BERARDY RESIDENCE
BETH MCCORMICK
BILL & CHRISTINA BART
BILL KENNEDY
BILL PIAZZE MODEL 1200 HOKULANI
BISHOP
BJ OTT'S
BLAISDELL/K-16276
BLANCO-MEDEIROS/B-16288
BLANKLEY - TOM BRYAN CONSTRUCTION
M/M KEN AKINAKA (MDL 500 KAU'I MOD)
M/M MEL PARK
M/M TOKU ISHIKAWA (MOD 700)
MACIEL HOMES / 4TH AVE. JOB#123
M/M KEN AKINAKA (MDL 500 KAU'I MOD)
M/M MEL PARK
M/M TOKU ISHIKAWA (MOD 700)
MACIEL HOMES / 4TH AVE. JOB#123
I have a list of data and I am trying to filter for certain text. I tried using the wildcards ?, ~, and *, but I can't get it to work properly.
I want to filter for anything with a character, followed by a dash, and 5 numbers (i.e. M-16263, B-16252)
For example, out of the list below, I am trying to filter for "BD BAKER KAUAI LLC/A-16082", "BEAVERS/H-16289", "BLAISDELL/K-16276", "BLANCO-MEDEIROS/B-16288".
Can someone help please? Thank you.
BD BAKER KAUAI LLC/A-16082
BEADEL
BEADEL
BEADEL
BEAVERS/H-16289
BEK - KAANAPALI OCEAN RESORT
BELFOR HAWAII PROPERTY RESTORATION
BENEDICT (MDL 600)
BENJAMIN VERGARA / 25TH
BERARDY RESIDENCE
BETH MCCORMICK
BILL & CHRISTINA BART
BILL KENNEDY
BILL PIAZZE MODEL 1200 HOKULANI
BISHOP
BJ OTT'S
BLAISDELL/K-16276
BLANCO-MEDEIROS/B-16288
BLANKLEY - TOM BRYAN CONSTRUCTION
M/M KEN AKINAKA (MDL 500 KAU'I MOD)
M/M MEL PARK
M/M TOKU ISHIKAWA (MOD 700)
MACIEL HOMES / 4TH AVE. JOB#123
M/M KEN AKINAKA (MDL 500 KAU'I MOD)
M/M MEL PARK
M/M TOKU ISHIKAWA (MOD 700)
MACIEL HOMES / 4TH AVE. JOB#123