SQL to split a column by delimiter

I'm building a report using direct query rather than import as I would like users to see real time data. This is the first time using this and a few of the functions I would usually use in the query editior to model the data don't work for direct query. The main issue being that I am unable to split a column by a delimiter. I've done some brief research and it would appear that I'm going to use SQL to split the column before it gets to Power BI. The question is how do I do this?

My query so far is;

SELECT [IncidentId]
      ,[IncidentReference]
      ,[AccountNumber]
      ,[CreateDate]
      ,[CreateStaffDetailId]
      ,[ModifyDate]
      ,[CurrentStaffDetailId]
      ,[CurrentIncidentStatusId]
      ,[CurrentProductDescription]
      ,[CurrentClassificationText]
  FROM [***].[dbo].[***]

The column I need to split is CurrentClassificationText, Currently it is stored in the database and then pulled into Power BI like this;

I need to have the data in Power BI like this;