need to parse dates from a string
Hello,
I need to parse a string to extract date for the sample text(sometime date format changes too) as below:
Need Date that comes after POP or Period of Performance word in 2 columns
Result:
start date:10/1/2018
end date:9/30/2019
Sample Text:
Facility:ASAHSN Location: LaGuardia NY
Lease Number:26DDDKKD-55
Lessor: Edgewater Industrial Park LLC
Period of Performance: 10/1/2018- 9/30/2019
Schedule: region: xyz
OR
Facility:ASAHSN Location: LaGuardia NY
Lease Number:26DDDKKD-55
Lessor: Edgewater Industrial Park LLC
PoP: 10/1/2018- 9/30/2019
Schedule: region: xyz