Hi,
I think the plugins here will help you:
The SPLIT plugin is what you needed.
BTW, @ComplexPoint, I think it'll be good if you could add this sample macro link to the plugins post. so that users may easily find the sample post from the Plugin posts.