Advertisement

11.06.2007 at 12:13PM PST, ID: 22942964
[x]
Attachment Details

Importing Unicode CSV file from Excel

Asked by OdieGiblet in PHP Scripting Language, PHP for Windows, PHP and Databases

Tags: characters, excel, export, foreign

I have a CSV file exported by Exchange which contains address / contact information. Some of these values contain foreign characters so they're encoded in unicode.

If I export the CSV without the unicode flag set, strings that contain foreign characters end up like this, and I don't know what to do with this:
X'a389e39e'

Or when I export with the unicode flag set, I don't know how to read it as PHP just sees garbage data.

So how can I read this CSV file and display the contents on a web page?Start Free Trial
[+][-]11.06.2007 at 12:46PM PST, ID: 20227449

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.06.2007 at 12:59PM PST, ID: 20227574

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.06.2007 at 01:07PM PST, ID: 20227662

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.06.2007 at 01:28PM PST, ID: 20227862

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.06.2007 at 01:30PM PST, ID: 20227890

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.06.2007 at 01:50PM PST, ID: 20228096

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.06.2007 at 01:56PM PST, ID: 20228155

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.06.2007 at 02:26PM PST, ID: 20228454

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.06.2007 at 02:56PM PST, ID: 20228640

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.06.2007 at 03:43PM PST, ID: 20228938

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.06.2007 at 03:48PM PST, ID: 20228959

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.06.2007 at 04:31PM PST, ID: 20229107

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: PHP Scripting Language, PHP for Windows, PHP and Databases
Tags: characters, excel, export, foreign
Sign Up Now!
Solution Provided By: OdieGiblet
Participating Experts: 2
Solution Grade: A
 
 
[+][-]11.06.2007 at 04:33PM PST, ID: 20229113

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628