Write a bash script

I would like a script written that can iterate over a list consisting of entries like this.. un1Z1269E9909 rb1Z129098515 : un1B10EEE7667 rb1B109863068 : un1LL38959888 rb1EE12059208 : un1Z1H26969681 mb1H69267119H mb1H6968H626H : un1Z1426969R8G mb1H69267119H mb1H696BH626H : and transform the strings between the delimiter ‘:’ placing them into groups on individual lines, likes so; un1Z1269E9909, rb1Z12909BS15, NULL, NULL, NULL,NULL un1B10EEE7667, rb1B10986B068,NULL, NULL, NULL,NULL un1Z1H2696968, NULL, NULL, NULL, mb1H69267119H, mb1H6968H626H Each line is to have 6 entries. Every line’s first entry/string will always start with the letter u. The next entry/string on the line will start with either rb or mb. From there the script has to loop over the transformed lines placing each entry in to a variable. then into a INSERT statement. echo "INSERT into balcony (prop1, prop2, prop3, prop4, prop5, prop6) VALUES (${SORTEDLIST[0]},${SORTEDLIST[1]},${SORTEDLIST[2]},${SORTEDLIST[3]},${SORTEDLIST[4]},${SORTEDLIST[5]}); Logic must place ‘NULL’ for some entries and the entries beginning with ‘mb’ will always populate the columns on the right.