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
/
^\|[^\|]*\|[^\|]*\|[^\s\|]
/
gm
Input 1
New
| 17255|Sumner Highlands |4507 Sangamore Rd |Bethesda |20816 |177569|-77.118822124|38.948172261|2023-04-04T10:00:00|3|1| 125| 31| 0.48| 0.88| 21| 0| 0|compliant| | 17547|The Birches |1532 Heather Hollow Cir |Silver Spring |20904 |178105|-76.980971525|39.040723373|2023-04-11T10:22:48|3|1| 227| 49| 0.42| 0.34| 34| 0| 0|compliant| | 17772|Glenville Road, 8812 |8812 Glenville Rd |Silver Spring |20901 |177597|-76.997005506|39.000266646|2023-05-08T12:41:39|3|1| 4| 6| 4.83| 1.92| 0|0.33| 0|troubled | |151598|Westchester West Apartments |3020 HEWITT AVE |SILVER SPRING |20906 |178118|-77.064392607|39.079760287|2023-06-29T10:34:44|2|1| 345| 64| 2.64| 1.17| 22|0.06| 0|at-risk | |122536|Inigo's Crossing |5405 TUCKERMAN LN |ROCKVILLE |20852 |177638|-77.108192429|39.02
Extraction
| 17255|Sumner Highlands |4507 Sangamore Rd |Bethesda |20816 |177569|-77.118822124|38.948172261|2023-04-04T10:00:00|3|1| 125| 31| 0.48| 0.88| 21| 0| 0|compliant| | 17547|The Birches |1532 Heather Hollow Cir |Silver Spring |20904 |178105|-76.980971525|39.040723373|2023-04-11T10:22:48|3|1| 227| 49| 0.42| 0.34| 34| 0| 0|compliant| | 17772|Glenville Road, 8812 |8812 Glenville Rd |Silver Spring |20901 |177597|-76.997005506|39.000266646|2023-05-08T12:41:39|3|1| 4| 6| 4.83| 1.92| 0|0.33| 0|troubled | |151598|Westchester West Apartments |3020 HEWITT AVE |SILVER SPRING |20906 |178118|-77.064392607|39.079760287|2023-06-29T10:34:44|2|1| 345| 64| 2.64| 1.17| 22|0.06| 0|at-risk | |122536|Inigo's Crossing |5405 TUCKERMAN LN |ROCKVILLE |20852 |177638|-77.108192429|39.02