Greetings. I have an issue with getting data converted to some sort of format that would be more friendly to databases than its current form, and I'm wondering if anyone here would have some advice.
It's a big dataset, around 200,000 records, and they are in tab-delimited format. Unfortunately, they are all on one line. That is, the end of line character is also a tab, so it is indistinguishable from the delimiter. There are only five variables. Is there any program or other way, perhaps even using Access, to tell a program that every fifth tab starts a new record? It seems like there should be something, but I don't know what it would be.
Any help with this would be greatly appreciated. Thanks.
It's a big dataset, around 200,000 records, and they are in tab-delimited format. Unfortunately, they are all on one line. That is, the end of line character is also a tab, so it is indistinguishable from the delimiter. There are only five variables. Is there any program or other way, perhaps even using Access, to tell a program that every fifth tab starts a new record? It seems like there should be something, but I don't know what it would be.
Any help with this would be greatly appreciated. Thanks.