Welcome, this sounds like something that's fairly easy to accomplish using perl, I second thanos1983, an example of your data would make it much easier to help you. See also How do I post a question effectively?. That data doesn't have to be the actual data you're working with if there's anything confidential, but the format should be the same.

Update: please don't be put off by the trolls.