Results 1 to 5 of 5
  1. #1
    Full Member
    Join Date
    September 10th, 2005
    Posts
    369
    How do I remove nonstandard characters?
    Is there a good program to remove all the nonprintable/nonstandard characters from a feed? Excel doesn't seem to do the job completely with the TRIM and CLEAN functions. Preferably a free program.

  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
    Ya Try this. It works for me, but I have a procedure with Excel and this.

    http://www.amwso.com/affiliate_tools.php

    It is free too!

    Other good info on that site AMWSO

    Cheers

  3. #3
    Full Member
    Join Date
    March 10th, 2006
    Posts
    466
    For the last few weeks I have been mulling over how to do this:

    "Import Product Data from an XML source file."

    as listed on the page you referenced.

    I need to take a look at that - hopefully it works remotely.

    Thanks!

  4. #4
    Newbie
    Join Date
    January 4th, 2006
    Location
    Berlin
    Posts
    41
    I cant remember which ones they are off hand but you can normalise the data using cpan modules for perl, we use a number of them to correct the data.

    Dont expect anything 100% perfect as a lot of character standardisation is dependant on other factors like encoding of the file and the actual characters within it (charset).

    That will point you in the right direction at least.

  5. #5
    Comfortably Numb John Powell's Avatar
    Join Date
    October 17th, 2005
    Location
    Bayou Country, LA
    Posts
    3,432
    nonprintable/nonstandard characters
    Are you using PHP?

  6. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Bad characters in datafeed
    By knight01 in forum Programming / Datafeeds / Tools
    Replies: 22
    Last Post: November 23rd, 2008, 10:12 PM
  2. How do I remove nonstandard characters?
    By dpl882 in forum Marketing Resources & Power Tools
    Replies: 1
    Last Post: January 20th, 2008, 08:36 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. What's the best way to deal with / , and other characters?
    By pw3909 in forum WebMerge (Fourthworld.com)
    Replies: 12
    Last Post: May 12th, 2004, 10:47 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
  •