Results 1 to 4 of 4
  1. #1
    Affiliate Manager PetsWarehouse.com's Avatar
    Join Date
    January 17th, 2005
    Location
    Long Island, New York
    Posts
    1,616
    Removing special characters
    I'm working with a Access DB I'm trying to remove <br> from a text field.

    The problem is I don't see them in Access only when I export to CSV I see a little square box.

    I need to update in Access how can I fix this or any other special characters at the same time.
    Bob Pets Warehouse
    Worlds Largest Pet Supply DataBase
    Join our Share-A-Sale Program [since 2003] Twitter



  2. #2
    SEO: A Specialty - Web Design: Slow or outsourced andbeyond's Avatar
    Join Date
    June 18th, 2006
    Location
    The Call is coming from Inside the House!
    Posts
    1,332
    Look in AMWSO.com they have a cleaner that is on the left nav I believe. It is very useful.

    O and its totally free. Thanks AMWSO

  3. #3
    Full Member
    Join Date
    September 10th, 2005
    Posts
    369
    http://www.notetab.com/ also works well for a search and replace. It also lets you use a wild card.

  4. #4
    Full Member iolaire's Avatar
    Join Date
    October 3rd, 2006
    Location
    Arlington, VA
    Posts
    229
    If it is in Visual Basic you might try vbCr. Or in a search ^p or /n or /r or \n or \r (I rarely remember which way the slash is supposed to go.). Another option is to paste the string into word, select the line ending and hit find, usually it will transpose to Microsoft formatting in the find box.

  5. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. WP - Special Characters in Title
    By superCool in forum Blogging, Mobile and Social Media
    Replies: 3
    Last Post: March 12th, 2010, 02:58 PM
  2. LS Moderator - Concerns Of Tracking With Special Characters
    By Trust in forum Rakuten LinkShare - LS
    Replies: 0
    Last Post: July 5th, 2007, 01:40 PM
  3. MySQL + English Characters + Mandarin Characters
    By popdawg in forum Programming / Datafeeds / Tools
    Replies: 2
    Last Post: October 8th, 2006, 01:05 PM
  4. Special Characters in Datafeeds
    By dogdecor in forum ShareASale - SAS
    Replies: 2
    Last Post: April 5th, 2006, 09:34 AM
  5. Help with special characters (not goofy or mickey)
    By Heyder in forum Programming / Datafeeds / Tools
    Replies: 5
    Last Post: February 27th, 2004, 08:00 AM

Posting Permissions

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