XML Import: Ignore invalid characters?

jeffcoleky

Active Member
Joined
May 24, 2011
Messages
274
I mapped an xml table from craigslist using Excel 2010 so I can stay up to date with posts that are created.

It worked great for several days but now I am no longer able to refresh the data due to an error:

"An XML error has occurred. Please correct the problem and try again."
"Click the Details button ..."

Details:

Error Code: -1072896760
URL:
<not-supplied>
Reason: An invalid character was found in text content.
Line: 135
Column: 7
File offset: 8190

Here is a snippet from the line giving the error:

3 beds· 2 baths· 1,950 sqft Beautiful setting & lawn with mature trees and country views.

So it's quite clear it's the "·" Character causing this problem.

Is there a way around this? I could always contact the original poster and ask them to change the text and refresh again, but that seems ridiculous. Besides, yesterday, the post giving the error was different than it was today.

I posted on the craigslist tech support and they said it was likely an invalid character. Thanks for the help, right? :) Well, they can't change it on their end so i'll have to find a way around this.

I considered just downloading the XML file using a macro, search and replace specific invalid characters, then import from a local file. Is this the best way to do this?

PS. Here is the URL for the XML Data:
</not-supplied>http://louisville.craigslist.org/search/reo?format=rss
 
Last edited:

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
One more thing to add: When I download and import the XML document as a local file (instead of directly from the web), it lets me create the XML Table, but won't let me import either.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,040
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top