Spreadsheets | VLOOKUP + REGEXEXTRACT

/* Parsing a string like '0|5|10|0' in Google Spreadsheets */

/* Grab the part after the last pipe: */
=IFERROR(VALUE(REGEXEXTRACT(VLOOKUP(B3,PDs!A16:PDs!D19,3,FALSE),"\|([^|]+)$")),"")

/* Grab the pre-last part: */
IFERROR(VALUE(REGEXEXTRACT(VLOOKUP(B7,Links!A16:Links!D17,3,FALSE),"([^|]+)\|[^|]+$")),"")

/* First: */
=IFERROR(VALUE(REGEXEXTRACT(VLOOKUP(B3,DLs!A16:DLs!D17,3,FALSE),"^[^|]+")),"")