Extract Date from SQL field

Does anyone know a function I can use to extract the date after the last ',' or last '|' in a field?

Values are in the below format:

ON24_NEW_LEADS_29032020 Newsletter|20210803

Many thanks,

JD