I would do something like this if it were my table:

select

ds.Item

from

dbo.YourTable yt

cross apply dbo.DelimtitedSplit8K(yt.YourColumn,'|')ds

where

ds.ItemNumber = 1;

Actually, I would parse the data and put it into a proper table so that I could query it easier.