Save list of rows as .txt based on their index in column A

  • 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
  • Hi and Welcome to the Forum :)


    If my understanding is correct, the process you could follow is to Filter your Database using Column A as your criteria ...


    For each Unique Family id, you would get the respective file which you require ...


    Does this make sense ?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!