locked
Finding Records with ? Symbol RRS feed

  • Question

  • What is the best way to find records that have ' ? ' symbol in them? We had some records with UTF-8 issues be imported and I want to find learn how to find them and correct those records where a ' ? ' symbol appears.
    Monday, January 24, 2011 10:47 PM

Answers

  • You can use 'Advanced Find' to do searches for specific characters and/or character sequences.  Eg.

    1. Advanced Find
    2. Entity Type 'Account'
    3. Selection Criteria 'Account Name' / 'Contains' / ?

     


    --pogo (pat)
    • Proposed as answer by Donna EdwardsMVP Tuesday, January 25, 2011 2:28 AM
    • Marked as answer by Supplyside Tuesday, January 25, 2011 2:30 AM
    Tuesday, January 25, 2011 1:52 AM

All replies

  • You can use 'Advanced Find' to do searches for specific characters and/or character sequences.  Eg.

    1. Advanced Find
    2. Entity Type 'Account'
    3. Selection Criteria 'Account Name' / 'Contains' / ?

     


    --pogo (pat)
    • Proposed as answer by Donna EdwardsMVP Tuesday, January 25, 2011 2:28 AM
    • Marked as answer by Supplyside Tuesday, January 25, 2011 2:30 AM
    Tuesday, January 25, 2011 1:52 AM
  • In addition to pat's suggestion, you can also query the filtered views directly.


    Regards, Donna

    Tuesday, January 25, 2011 2:29 AM
  • Thank you for your reply.

     

     

    Tuesday, January 25, 2011 2:43 AM