Forum Discussion

AoJueMing's avatar
AoJueMing
Helper I
9 years ago
Solved

Identical values counted as distinct. Why?

Hi guys   Here's a list of distinct values in a column I have: I can't make head nor tail of it.  I am fascinated to find out why there are two distinct blanks, and two distinct versions of ...
Need Help
  • AoJueMing's avatar
    AoJueMing
    9 years ago

    Hi Marcel

     

    Thanks very much.  I should have stated in the initial post that I had already checked for trailing spaces - though I didn't know about impossible characters.

     

    Just to complete the thread, what I have ended up doing is c+p the two distinct versions into Word, and switch on 'Show formatting Marks'.  This came back with:

    So at least now I can sleep peacefully :)

MarcelBeug's avatar
MarcelBeug
Community Champion
9 years ago

Typically this is due to trailing spaces and/or unprintable characters.

You can try and use trim and clean in the query editor, transform tab, format.

AoJueMing's avatar
AoJueMing
Helper I
9 years ago

Hi Marcel

 

Thanks very much.  I should have stated in the initial post that I had already checked for trailing spaces - though I didn't know about impossible characters.

 

Just to complete the thread, what I have ended up doing is c+p the two distinct versions into Word, and switch on 'Show formatting Marks'.  This came back with:

So at least now I can sleep peacefully :)

  • MarcelBeug's avatar
    MarcelBeug
    Community Champion
    9 years ago

    Maybe you can mark your previous post as answer first.

    • AoJueMing's avatar
      AoJueMing
      Helper I
      9 years ago

      Pardon?

       

      edit: Thanks for Kudo - feels like a bit of a cheat though (:

      Will close thread.