Thank you both

I have considered doing it this way (writing an R file). I just felt I was not far from the R solution. I know this is not the best place to be asking an R question but I have had useful advice to all my questions in the past I am always compelled to ask here first

Once again, thank you