Regex expressions

Help Studio
, ,
1

hi ,

i have to extract data from text file and select only those which Starts from BRT. can anyone tell me step by step process on how to extract data from text file through regular expressions .
Eg. first line you can see occupany date and BRT , i want to extract data after BRT

Lease Id: HO5097 Occupancy: 8/1/2014 BRT Base Rent 9,684 8/1/2014 7/31/2015 7/31/2015 36,315.00 435,780.00 45.00
Leasable Sqft: 9,684 Rent Start: 8/1/2014 BRT Base Rent 9,684 8/1/2015 7/31/2016 7/31/2016 37,222.88 446,674.56 46.13
Leased Sqft: 9,684 Expiration: 2/28/2037 BRT Base Rent 9,684 8/1/2016 7/31/2017 8/31/2017 38,153.45 457,841.40 47.28
Pro-Rata Share: 0.0316 Vacate: BRT Base Rent 9,684 8/1/2017 7/31/2018 8/31/2018 39,107.28 469,287.36 48.46
Ann. Mkt. Rent PSF: Sec. Req. BRT Base Rent 9,684 8/1/2018 7/31/2019 8/31/2019 40,084.97 481,019.64 49.67
Insurance Certificate Expiration: BRT Base Rent 9,684 8/1/2019 7/31/2020 8/31/2020 42,102.47 505,229.64 52.17
Occupancy Status: Current BRT Base Rent 9,684 8/1/2020 7/31/2021 8/31/2021 43,155.03 517,860.36 53.48
BRT Base Rent 9,684 8/1/2021 7/31/2022 8/31/2022 44,233.90 530,806.80 54.81
BRT Base Rent 9,684 8/1/2022 7/31/2023 2/28/2023 45,339.75 544,077.00 56.18
Due Day: 1 Late Calculation Method: BRT Base Rent 9,684 8/1/2023 7/31/2024 46,473.25 557,679.00 57.59
Delinquent Day: Delinquent Bill Option: A BRT Base Rent 9,684 8/1/2024 7/31/2025 47,635.08 571,620.96 59.03
Late Fee Rate: Late Fee-Flat: BRT Base Rent 9,684 8/1/2025 7/31/2026 48,825.96 585,911.52 60.50
BRT Base Rent 9,684 8/1/2026 7/31/2027 50,046.61 600,559.32 62.02
BRT Base Rent 9,684 8/1/2027 7/31/2028 51,297.78 615,573.36 63.57
BRT Base Rent 9,684 8/1/2028 7/31/2029 52,580.22 630,962.64 65.16
BRT Base Rent 9,684 8/1/2029 7/31/2030 53,894.72 646,736.64 66.78
BRT Base Rent 9,684 8/1/2030 7/31/2031 55,242.09 662,905.08 68.45
BRT Base Rent 9,684 8/1/2031 7/31/2032 56,623.14 679,477.68 70.16
BRT Base Rent 9,684 8/1/2032 7/31/2033 58,038.72 696,464.64 71.92
BRT Base Rent 9,684 8/1/2033 7/31/2034 59,489.69 713,876.28 73.72
BRT Base Rent 9,684 8/1/2034 7/31/2035 60,976.93 731,723.16 75.56
BRT Base Rent 9,684 8/1/2035 7/31/2036 62,501.35 750,016.20 77.45
BRT Base Rent 9,684 8/1/2036 2/28/2037 64,063.89 768,766.68 79.39
COE CAM Inc-Op Exp9,684 9/1/2016 3/31/2018 9/30/2018 404.62 4,855.44 0.50
COE CAM Inc-Op Exp9,684 4/1/2018 4/30/2019 5/31/2019 102.38 @ 1,228.56 0.13 @
COE CAM Inc-Op Exp9,684 5/1/2019 5/31/2019 6/30/2019 224.32 @ 2,691.84 0.28 @
COE CAM Inc-Op Exp9,684 6/1/2019 12/31/2020 9/30/2021 224.31 @ 2,691.72 0.28 @
COE CAM Inc-Op Exp9,684 1/1/2021 8/31/2022 9/30/2022 3,878.42 @ 46,541.04 4.81 @
COE CAM Inc-Op Exp9,684 9/1/2022 2/28/2023 1,680.71 @ 20,168.52 2.08 @
CRT CAM-Inc-RE Taxes9,684 9/1/2016 3/31/2018 9/30/2018 1,230.91 14,770.92 1.53
CRT CAM-Inc-RE Taxes9,684 4/1/2018 4/30/2019 5/31/2019 1,495.44 @ 17,945.28 1.85 @
CRT CAM-Inc-RE Taxes9,684 5/1/2019 12/31/2020 9/30/2021 2,108.01 @ 25,296.12 2.61 @
CRT CAM-Inc-RE Taxes9,684 1/1/2021 8/31/2022 9/30/2022 2,025.81 @ 24,309.72 2.51 @
CRT CAM-Inc-RE Taxes9,684 9/1/2022 2/28/2023 1,906.72 @ 22,880.64 2.36 @
FR Rent Concessions9,684 8/1/2014 11/30/2014 11/30/2014 -36,315.00 -435,780.00 -45.00
FR Rent Concessions9,684 12/1/2014 7/31/2021 8/31/2021 0.00 0.00 0.00
FR Rent Concessions9,684 8/1/2021 7/31/2022 9/30/2021 -44,233.91 -530,806.92 -54.81
FR Rent Concessions9,684 9/1/2021 7/31/2022 8/31/2022 0.00 0.00 0.00
FR Rent Concessions9,684 8/1/2022 7/31/2023 9/30/2022 -45,339.73 -544,076.76 -56.18
FR Rent Concessions9,684 9/1/2022 12/31/2022 1/31/2023 0.00 0.00 0.00
FR Rent Concessions9,684 2/1/2023 2/28/2023 0.00 0.00 0.00
FR Rent Concessions9,684 8/1/2023 7/31/2024 1/31/2023 -46,473.25 -557,679.00 -57.59Database: CBRE2 Lease Profile Page: 2
Lease Id: GSH001 - HO5097 CBRE2 Date: 2/14/2023
Master Occupant Id: HO003772-1 Time: 2:10 PM
Report ID: CB_PROFILE

FR Rent Concessions9,684 2/1/2024 0.00 0.00 0.00
FR Rent Concessions9,684 8/1/2024 7/31/2025 -47,635.08 -571,620.96 -59.03
PAR PARKING REVENUE9,684 9/1/2016 7/31/2017 8/31/2017 1,962.70 23,552.40 2.43
PAR PARKING REVENUE9,684 8/1/2017 3/31/2019 5/31/2019 1,766.43 21,197.16 2.19
PAR PARKING REVENUE9,684 4/1/2019 3/31/2020 4/30/2020 1,873.98 22,487.76 2.32
PAR PARKING REVENUE9,684 4/1/2020 12/31/2020 2/28/2021 1,930.20 23,162.40 2.39
PAR PARKING REVENUE9,684 1/1/2021 12/31/2021 12/31/2021 1,988.11 23,857.32 2.46
PAR PARKING REVENUE9,684 1/1/2022 12/31/2022 1/31/2023 2,070.00 24,840.00 2.57
PAR PARKING REVENUE9,684 1/1/2023 2/28/2023 2/28/2023 2,109.18 25,310.16 2.61
PAR PARKING REVENUE9,684 3/1/2023 12/31/2023 2,000.00 24,000.00 2.48
PAR PARKING REVENUE9,684 1/1/2024 2,172.46 26,069.52 2.69
PAR PARKING REVENUE9,684 1/1/2025 2,237.63 26,851.56 2.77
PAR PARKING REVENUE9,684 1/1/2026 2,304.76 27,657.12 2.86
PAR PARKING REVENUE9,684 1/1/2027 2,373.90 28,486.80 2.94
PAR PARKING REVENUE9,684 1/1/2028 2,445.12 29,341.44 3.03
UTL Tenant Reimb Utility9,684 9/1/2016 3/31/2018 9/30/2018 74.25 891.00 0.09
UTL Tenant Reimb Utility9,684 4/1/2018 4/30/2019 5/31/2019 890.58 @ 10,686.96 1.10 @
UTL Tenant Reimb Utility9,684 5/1/2019 5/31/2019 6/30/2019 2,664.37 @ 31,972.44 3.30 @
UTL Tenant Reimb Utility9,684 6/1/2019 7/31/2019 7/31/2019 2,664.36 @ 31,972.32 3.30 @
UTL Tenant Reimb Utility9,684 8/1/2019 12/31/2020 12/31/2021 354.42 4,253.04 0.44
UTL Tenant Reimb Utility9,684 1/1/2021 2/28/2023 0.00 0.00 0.00
Suite Information Recurring Charges
Last
Building Id: GSH001 Execution: 6/7/2021 Effective End Bill Sales Monthly Rent Annual Annual
Suite Id: 730 Beginning: 3/1/2022 Cat. Description Sqft. Date Date Date Tax % Amount Tax ID Amount Rate PSF
Lease Id: HO1799 Occupancy: 3/1/2022 BRT Base Rent 2,311 11/1/2022 11/30/2023 2/28/2023 8,955.13 107,461.56 46.50
Leasable Sqft: 2,311 Rent Start: 11/1/2022 BRT Base Rent 2,311 12/1/2023 9,179.00 110,148.00 47.66
Leased Sqft: 2,311 Expiration: 2/28/2037 BRT Base Rent 2,311 11/1/2024 9,408.48 112,901.76 48.85
Pro-Rata Share: 0.0075 Vacate: BRT Base Rent 2,311 11/1/2025 9,643.69 115,724.28 50.08
Ann. Mkt. Rent PSF: Sec. Req. BRT Base Rent 2,311 11/1/2026 9,884.78 118,617.36 51.33
Insurance Certificate Expiration: BRT Base Rent 2,311 11/1/2027 10,131.90 121,582.80 52.61
Occupancy Status: Current BRT Base Rent 2,311 11/1/2028 10,385.20 124,622.40 53.93
BRT Base Rent 2,311 11/1/2029 10,644.83 127,737.96 55.27
BRT Base Rent 2,311 11/1/2030 10,910.95 130,931.40 56.66
Due Day: 1 Late Calculation Method: BRT Base Rent 2,311 11/1/2031 11,183.72 134,204.64 58.07
Delinquent Day: Delinquent Bill Option: A BRT Base Rent 2,311 11/1/2032 11,463.32 137,559.84 59.52
Late Fee Rate: Late Fee-Flat: BRT Base Rent 2,311 11/1/2033 11,749.90 140,998.80 61.01
BRT Base Rent 2,311 11/1/2034 12,043.65 144,523.80 62.54
BRT Base Rent 2,311 11/1/2035 12,344.74 148,136.88 64.10
BRT Base Rent 2,311 11/1/2036 12,653.36 151,840.32 65.70
FR Rent Concessions2,311 11/1/2022 11/30/2023 2/28/2023 -8,955.13 -107,461.56 -46.50
FR Rent Concessions2,311 3/1/2023 3/31/2023 -9,179.00 -110,148.00 -47.66
FR Rent Concessions2,311 4/1/2023 0.00 0.00 0.00
FR Rent Concessions2,311 1/1/2024 1/31/2024 -9,408.48 -112,901.76 -48.85
FR Rent Concessions2,311 2/1/2024 0.00 0.00 0.00
FR Rent Concessions2,311 1/1/2025 1/31/2025 -9,643.69 -115,724.28 -50.08
FR Rent Concessions2,311 2/1/2025 0.00 0.00 0.00

2

Hi,

You can split text by each new line and look for the index of BRT, once you got the index, do a substring as start index of BRT and till the end of line.

3

Hi @poojaskyrathore,
Use below regex pattern
(?<=BRT).*

image
image904×802 103 KB

Regards,
Arivu

1 Like