0 - 1 of 1 tags for looping

Hi Guys,
I need some info on looping in Teradata with below requirement. Anny help will be appriciated. Thanks in advance,
 
source field is string which is having below format,