How to retrieve data between pipes (delimiter) in string

I have a single table called #ParsedBlocks that contains one column called [BlockData].
This column contains a string that's pipe delimited.
I need to return the data between the pipe characters into separate columns.

So I've figured out how to extract the first column with the below script but I can't figure out how to extract from the second column onwards

select * 
    ,SUBSTRING(BlockData, 1, CHARINDEX('|',BlockData) -1)
    ,SUBSTRING(BlockData, CHARINDEX('|', BlockData) + 1, LEN(BlockData))
from 
    #ParsedBlocks

The result of the above script:

Source Dataset:

Required Result:

I have a couple of these ParsedBlocks tables that I need to apply this logic to and each table has a different number of pipe delimiters (columns) so it would be great if there was a way to have a single script to easily apply to each table.
For example:
Having a script that "automatically" finds each pipe (column) and returns the data accordingly, if that makes sense...

Just another option using a bit of JSON

 Select Pos1 = JSON_VALUE(JS,'$[0]')
       ,Pos2 = JSON_VALUE(JS,'$[1]')
       ,Pos3 = JSON_VALUE(JS,'$[2]')
       ,Pos4 = JSON_VALUE(JS,'$[3]')
 From  YourTable A
 Cross Apply (values ('["'+replace(string_escape([BlockData],'json'),'|','","')+'"]') ) B(JS)

Results

Pos1        Pos2        Pos3    Pos4
Sitecode1   ItemCode1           CostPrice1
Sitecode1   ItemCode2           CostPrice2