SQL Language (MOSC)

MOSC Banner

need to parse dates from a string

in SQL Language (MOSC) 6 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center