sponsored links

Collapse

Announcement

Collapse
No announcement yet.

Finding records with illegal characters

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Finding records with illegal characters

    Not sure if this should go here or in DDS, but I'm trying to find all records in a table that include illegal characters in any of their fields. There are a little over 1 million records in this table, so hand checking all of them isn't very practical. Does anyone know of a way to detect all illegal characters in a table? Please respond if you need more information.

    Thanks

  • #2
    Re: Finding records with illegal characters

    Ended up just using a SQL query comparing string fields with the 'LIKE' function to find certain hex values. Won't find all illegal characters, but I think I found most of what I was looking for.

    Comment


    • #3
      Re: Finding records with illegal characters

      Hi WarrenN:

      See if this can help:
      http://www.code400.com/forum/showthr...rom-Data-Entry

      Illegal characters probably have a value less than x'40'

      Best of luck
      GLS
      The problem with quotes on the internet is that it is hard to verify their authenticity.....Abraham Lincoln

      Comment

      Working...
      X