The leftWords, RightWords, and MiddleWords functions ( along with WordCount) come to mind.
You can use them in a looping script to parse them into separate records.
Thank you, however it needs to be dynamic as the Field may have more than 3 possibly even 8.
Which is why you would use a looping script with Middlewords, a Variable and the wordcount function to tell the script how many iterations are needed to get that done.
Set Variable [$Values ; value: YourTable::YourField ]
Set Variable [$Key ; value:YourTable::YourPrimarykeyField ]
Go To Layout ["RelatedTable" (RelatedTable) ]
Set Variable [$K ; value: $K + 1 ]
Exit Loop If [ $K > WordCount ( $Values ) ]
Set Field [RelatedTable::Value ; Middlewords ( $Values ; $K ; 1 ) ]