Please enable JavaScript to use regex101
/
^
r
e
g
e
x
[
\
-
_
]
?
1
0
1
$
/
i
Reg
ular
Ex
pressions
101
Upgrade to Pro
Enterprise
Regular Expression
/
(?i)(.*((\bown(er|re)\b)|(\bocc?up(eir|ier|ire)\b)s?).*)
/
g
Input 1
New
customer_name Miss. amber Lowe Ms. zara scantlebury Mrs. Jacky Kalonda Mrs. Cynthia Williams Mr. Suresh Kotecha Rebecca Bormer Mr. Affan Hashmi Mr. William Dormand Mr. Andrew MacIntosh Mr. Kieran Ross Mrs. rachel pezerovic Mr. David Abbott Mrs. Fazal Jan Butt Owner Occupier Mrs. Barbara Feerick Mr. Gary Rendell Mrs. Natalie Farrell Ms. Sally Janani Mr. Chris Tween Mr. Shahid Ali Mr. Govanmurad saifi Ms. Vera Lucia Nicola Smith Mr. Andrew Jessop Ashley Phoenix Mrs. Rosalie Cross Ms. Patricia Smith Martin Stewart Mr. zakir nazmin Owner Occupier Mr. Leeanne Jasper Owner Occupier . Mr Yousuf Munshi C/O Mrs Zulekhan Munshi Owner Occupier Miss. Gemma Johnson Mr. Michael Brown Owner Occupiers Mr. paul atkins Karen Taylor Mr. Yusuf Hassan Mrs Teresa Geeson Mr. Paul Regan Mrs Pat Robinson Mr. Patrick Jones Mrs. chapanben bava Mr. Nadeem Tariq Mr. Kiran Jayaprakash Kris Henley Mrs. Denise Gouge Mr. Dilip Gurung Owner Occupier Miss Stephanie Hamman Mr. Richard Sneddon Mr. AvtarSingh Chauhan Mr. S
Extraction
customer_name Miss. amber Lowe Ms. zara scantlebury Mrs. Jacky Kalonda Mrs. Cynthia Williams Mr. Suresh Kotecha Rebecca Bormer Mr. Affan Hashmi Mr. William Dormand Mr. Andrew MacIntosh Mr. Kieran Ross Mrs. rachel pezerovic Mr. David Abbott Mrs. Fazal Jan Butt Owner Occupier Mrs. Barbara Feerick Mr. Gary Rendell Mrs. Natalie Farrell Ms. Sally Janani Mr. Chris Tween Mr. Shahid Ali Mr. Govanmurad saifi Ms. Vera Lucia Nicola Smith Mr. Andrew Jessop Ashley Phoenix Mrs. Rosalie Cross Ms. Patricia Smith Martin Stewart Mr. zakir nazmin Owner Occupier Mr. Leeanne Jasper Owner Occupier . Mr Yousuf Munshi C/O Mrs Zulekhan Munshi Owner Occupier Miss. Gemma Johnson Mr. Michael Brown Owner Occupiers Mr. paul atkins Karen Taylor Mr. Yusuf Hassan Mrs Teresa Geeson Mr. Paul Regan Mrs Pat Robinson Mr. Patrick Jones Mrs. chapanben bava Mr. Nadeem Tariq Mr. Kiran Jayaprakash Kris Henley Mrs. Denise Gouge Mr. Dilip Gurung Owner Occupier Miss Stephanie Hamman Mr. Richard Sneddon Mr. AvtarSingh Chauhan Mr. S