Hey,
I'm having an hard time trying to split a .txt file into several different .txt files with the same layout based on the value in column A. I have 4 columns with sequential values divided by row, in column A there's is the index of rows belonging to the same family from 1 to n (length of this column and of each family could be variable from file to file). Now I would like to save the list of rows by family, each in a new .txt file called Family 1, with also an additional row in A1 cell stating the family name (e.g. "Familiy: 1")
I wish to have this files saved in the same folder from where I read the original file.
Could someone help me with this?
thanks
Family | Plane | (px) | (py) |
1 | 1 | 325.46 | 333.1787 |
1 | 2 | 325.7564 | 333.1844 |
1 | 3 | 325.4642 | 333.2532 |
1 | 4 | 325.8972 | 333.1566 |
1 | 5 | 325.6731 | 333.1571 |
1 | 6 | 325.7746 | 333.1219 |
1 | 7 | 325.5369 | 333.0636 |
1 | 8 | 325.804 | 332.6832 |
1 | 9 | 325.5439 | 332.712 |
1 | 10 | 325.8567 | 332.7454 |
1 | 11 | 325.1862 | 333.006 |
1 | 12 | 325.355 | 332.6938 |
1 | 13 | 325.6257 | 333.2444 |
1 | 14 | 325.7162 | 332.7044 |
2 | 1 | 44.0493 | 102.1343 |
2 | 2 | 44.11892 | 102.02 |
2 | 3 | 44.22305 | 102.0625 |
2 | 4 | 44.17181 | 101.9667 |
2 | 5 | 44.14819 | 102.0195 |
2 | 6 | 44.383 | 102.1337 |
2 | 7 | 44.32208 | 101.9285 |
2 | 8 | 44.30776 | 101.9857 |
2 | 9 | 44.34346 | 101.9649 |
2 | 10 | 44.36405 | 101.9244 |
2 | 11 | 44.50053 | 101.8614 |