Loading ...
Sorry, an error occurred while loading the content.

528Re: [NTS] sort R2L, count dupes

Expand Messages
  • milan.boran@gmail.com
    Apr 7, 2012
    • 0 Attachment
      > if you say right to left, do you mean sorting as if the string was reversed in each record?
      Yes, either that, or as if read from the right.

      > I'd suggest you write a script that creates a new file
      > with the records (=lines) reversed, then sort that.
      Just need the count of dupes per string/line/entry.

      > Regarding the duplicates: do you just need the count.
      Only the count. If there is a sorted output, fine, better than not.

      > or do you want to eliminate them?
      No. Notetab already would do that.

      > If you really just want the count that doesn't help for the sort exercise of course.
      Exactly :)

      Many thanks for your help,
      Milan





      On Sat, Apr 7, 2012 at 16:10, Thomas Gruber <computerhusky@...> wrote:
      >
      >
      >
      > Hi,
      > if you say right to left, do you mean sorting as if the string was reversed in each record? I'd suggest you write a script that creates a new file with the records (=lines) reversed, then sort that.
      >
      > Regarding the duplicates: do you just need the count, or do you want to eliminate them? If you want to eliminate them, you could do that first, by sorting normally, finding the duplicates, and removing them - duplicate is duplicate, whether it is reversed or not. If that reduces the record count significantly, you'd save time for the reversing exercise.
      > If you really just want the count that doesn't help for the sort exercise of course.
      > Kind regards
      > Tom
      >
      > Am 07.04.2012 um 13:03PM schrieb milanboran:
      >
      >
      >
      > > Hi NTB-Scripters!
      > >
      > > Using NoteTab, right now I try to crack a problem re a large list, ca
      > > 2mio records, stripped all other stuff away, so that only the strings
      > > that need sorting remain. But I need to sort backwards, from right to
      > > left. Then the duplicates need to be counted. Right now only the
      > > R2L-sorting and the dupe-counting remain. Any ideas? Is there a plugin
      > > for this?
      > >
      > > So far spread sheets or database programs seam not to do it per se or I
      > > simply do not know how to, yet ;) But it would be much easier, if
      > > NoteTab could do it right with the text file in it, so no export/import
      > > would be necessary.
      > >
      > > Any help is much appreciated. This is not an Easter Egg, but you can
      > > count it as an Easter Greeting :)
      > >
      > > Thank you in advance and best wishes,
      > > Milan
      > >
      > > --
      > >
      > > ----------
      > > Legal Note
      > > This message, incl. potential attachments, is of confidential or
      > > privileged nature and intended solely for individual/organization
      > > addressed. If received in error, please notify sender at once and
      > > destroy. Unintended use of message is forbidden/potentially illegal.
      > > Salvatory and severance apply, estoppel is void, e.g. in that any
      > > message or any part thereof shall be valid in their own context.
      > > ----------
      > >
      > >
      >
      > [Non-text portions of this message have been removed]
      >
      >




      --




      ----------
      Legal Note
      This message, incl. potential attachments, is of confidential or
      privileged nature and intended solely for individual/organization
      addressed. If received in error, please notify sender at once and
      destroy. Unintended use of message is forbidden/potentially illegal.
      Salvatory and severance apply, estoppel is void, e.g. in that any
      message or any part thereof shall be valid in their own context.
      ----------
    • Show all 11 messages in this topic