Find the answer to your Linux question:
Results 1 to 1 of 1
Hi Linux Folks! I have a question regarding sorting out the unique entry rows in a Microsoft XL file using shell scripting. Please find attached the file Example_1_linux_forums My requirement ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Aug 2011
    Posts
    1

    How to sort unique rows in a Microsoft XL file using shell scripting?


    Hi Linux Folks!
    I have a question regarding sorting out the unique entry rows in a Microsoft XL file using shell scripting.
    Please find attached the file Example_1_linux_forums
    My requirement goes like this:
    Out of the 25 rows that are mentioned, I want only those rows to be filtered and listed in an output file which are unique in their sense w.r.t succeeding numbers after the site name mentioned. For example,
    I dont want any entries starting with "DVG_Road" because they have DVG_Road_1, DVG_Road_2 and DVG_Road_3 listed twice, which is not an unique entry. But I want entries like "Richmod_Road_1", "Basavanagudi_2" which are unique entries, because there is no other similar duplicate entry of these. Also I want the row entries JPNagar_2, JPNagar_3 because they are also unique entries which dont have duplicate entries.
    I hope my explanation of the requirement is good enough for your understanding.
    Could you kindly help me out in getting an output file with only the kind of unique entries that I have asked for?
    Thanks in advance,
    Prasanna
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •