Import correctly a very large text file in Excel
Posted on 2013-01-11
I have a very big text file containing data (space separated) about people.
I need to order all those people in excel but then I import it in excel I have no line break so I get one single very big row.
I saw that each record is separated by the letters RP but before RP there's a numeric code of different lenght.
So the final solution would be an automation to automatically put a ^p at the beginning of every word in the txt file that contains RP
How can I achieve that?
(if possible I'd love to do it using linux command line otherwise any kind of solution for any kind of operating system is ok: also including microsoft office and or other tools)