SELECT split_part(split_part(split_part(sighting_report,' (Entered',1),'Occurred : ',2),'Reported',1) as occurred ,split_part(split_part(sighting_report,')',1 ...