1
=IFERROR(VALUE(TRIM(MID(SUBSTITUTE(B2,"|",REPT(" ",100)),1,100))),"")