Oracle SQL Developer
Select
REGEXP_SUBSTR(Column1,'Name=([^.]+)',1,1,null,1) as Name
, regexp_substr(Column1,'Branch Number=([^.]+)',1,1,null,1) as Branch_Number
, regexp_substr(Column1,'Type of Event=([^.]+)',1,1,null,1) as Type_of_Event
, regexp_substr(Column1,'Date of Event=([^.]+)',1,1,null,1) as Date_of_Event
From table1
Where...