I need help in writing an ITERATE fuction to loop through PID;11 field until it finds HOME and when i find a match, I can copy the address fields from source to the destination.
E.g.
London^^^””^””^””^TEMPORARY^^””~Flat 6 Rowan Court^112A Coombe Lane^London^””^SW20 0BA^GBR^HOME^Raynes Park^””