Getting text between two special characters as a new line

create  table test (ordernum int, narrative varchar(2000))
insert into test values(1234,'^Parcel shipped^picked^entry passed then returned back^white ford truck number 78455333^freight charges entered^parcel weight entered^parcel supervised^ticketsscannned^broken glass on floor^')



  ;with mycte as (
 Select   ordernum, S.a.value('.', 'VARCHAR(100)') SplitVal
 FROM (
 Select *, CAST (N'<H><r>' + Replace( narrative, '^','</r><r>') + '</r></H>' AS XML) [vals] 
 from test) d   
 CROSS APPLY d.[vals].nodes('/H/r') S(a) 
 )

 select * from mycte 
 Where SplitVal<>''
 
drop table test