Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

5
  • 3
    It is unclear what the output should look like when there are more than one range of non-zero width. Commented Oct 23, 2024 at 6:53
  • hi, Didnt get your query. the duplicate entries should be removed and data should be unique. better if we get the count for duplicate values as well Commented Oct 23, 2024 at 14:30
  • I'm not talking about any duplicated entries. I asked what the output should look like if there's a third line in the input, TMI=012813 FCI=00 low=093760 up=093796 sor=0E. Commented Oct 23, 2024 at 18:28
  • Hi @Kusalananda thanks for your time. The output should have only the count of lines as stated above in the query. I just need the count of lines which are unique, next the count of the lines having low and up in range, and then the count of range expanded to some figure. Commented Oct 24, 2024 at 4:38
  • 1
    "count of range expanded to some figure" does not make much sense to me. It would probably help if you expanded your sample to something that includes duplicates and more than one line with a range along with the expected output. Please edit your question to add the requested details. Commented Oct 24, 2024 at 5:17