if as OP was specific about "spaces"...heres a first cut ....may be a start??;-)

--drop table #tempcall

SELECT

ID = IDENTITY(INT, 1, 1),

RTRIM(LTRIM(REPLACE(REPLACE(REPLACE(REPLACE(SUBSTRING(calldata,0,7),'-',''),'%',''),'+',''),'/','-'))) as cDate,

RTRIM(LTRIM(SUBSTRING(calldata,7,9))) as cStartTime,

RTRIM(LTRIM(SUBSTRING(calldata,19,9))) as cDuration,

RTRIM(LTRIM(SUBSTRING(calldata,29,6))) as callingparty,

RTRIM(LTRIM(SUBSTRING(calldata,41,6))) as origCall,

RTRIM(LTRIM(SUBSTRING(calldata,47,19))) as cDestination,

REPLACE(RTRIM(LTRIM(SUBSTRING(calldata,34,7))),'*','') as cTimetoAnswer,

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(RTRIM(LTRIM(SUBSTRING(calldata,41,28))),'A',''),'B',''),'I',''),'E',''),'T',''),'*','') as cDigitsDialed,

RTRIM(LTRIM(SUBSTRING(calldata,69,6))) as calledparty,

RTRIM(LTRIM(SUBSTRING(calldata,108,3))) as cSystemID,

RTRIM(LTRIM(SUBSTRING(calldata,112,19))) as cANI,

RTRIM(LTRIM(SUBSTRING(calldata,124,21))) as cDNIS,

RTRIM(LTRIM(SUBSTRING(calldata,148,15))) as cCallID,

RTRIM(LTRIM(SUBSTRING(calldata,162,2))) as cCallIDSeq

into #tempcall

FROM [dbo].[MitelCallTrace]

WHERE len(calldata) <> 0 AND SUBSTRING(calldata, 0, 7) <> ''

;

--select * from #tempcall

WITH cdsplit as (

SELECT ID

, MAX(CASE WHEN ItemNumber = 1 THEN Item END) p1

, MAX(CASE WHEN ItemNumber = 2 THEN Item END) p2

, MAX(CASE WHEN ItemNumber = 3 THEN Item END) p3

, MAX(CASE WHEN ItemNumber = 4 THEN Item END) p4

FROM #tempcall

CROSS APPLY dbo.DelimitedSplit8K(cDestination, ' ') split

GROUP BY ID

)

SELECT tc.ID

, tc.cDate

, tc.cStartTime

, tc.cDuration

, tc.callingparty

, tc.origCall

, tc.cdestination

, ISNULL(cdsplit.p1, '') AS cd1

, ISNULL(cdsplit.p2, '') AS cd2

, ISNULL(cdsplit.p3, '') AS cd3

, ISNULL(cdsplit.p4, '') AS cd4

, tc.cTimetoAnswer

, tc.cDigitsDialed

, tc.calledparty

, tc.cSystemID

, tc.cANI

, tc.cDNIS

, tc.cCallID

, tc.cCallIDSeq

FROM [#tempcall] AS tc

INNER JOIN cdsplit

ON tc.ID = cdsplit.ID