Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2004
    Location
    Cary, NC
    Posts
    264

    Unanswered: Searching for special characters

    I know this topic must have been covered but I have not had any luck finding a useful thread.

    Some of the records in the database have a carriage return in the field which is showing up as a small square. This is breaking an application further down the line which is not under my direction. I need to remove all the returns in the field prior to sending the data down the line to the next application.

    Does anyone know how to find these characters without having to dump the entire table out to word or excel?

    Steve

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    These are likely to be CHR(10) & CHR(13). Replace these with "" and you should be sorted.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Aug 2004
    Location
    Cary, NC
    Posts
    264
    Using chr(10) and chr(13) in a query will find the records but using chr(10) and chr(13) in the search/replace screen does not.

    How would I do the replacement in a query while preserving the rest of the field?

    Steve

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Works fine for me.
    Code:
    UPDATE myTable 
    SET the_data = Replace(Replace(the_data,Chr(10),""),Chr(13),"");
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Aug 2004
    Location
    Cary, NC
    Posts
    264
    Thank you, that worked wonderfully.

    I didn't think to use the replace function inside the query. For some reason my mind got stuck thinking I needed to use the ctrl-h replace, which did not work.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •