n8g, question is how do I determine the delimiter when a file is given so I can do what you suggested.

agreed its very tricky to replace a delimiter. that's why wanted to do something similar to what excel does.