How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Bhavik Joshi Your Own Question
Bhavik Joshi
Bhavik Joshi, Computer Software Engineer
Category: Email
Satisfied Customers: 472
Experience:  Product Developer at Computer Science Corporation
94617175
Type Your Email Question Here...
Bhavik Joshi is online now
A new question is answered every 9 seconds

I have a text file with all written in Spanish and some

Customer Question

I have a text file with all written in Spanish and some corrupted characters. I want to read it on Excel without any corruption. What is the solution?
JA: What OS X (Operating System, e.g. Sierra, El Capitan, Yosemite, etc.) or iOS are you runninng?
Customer: I recently updated to Sierra.
JA: Have you installed any updates recently?
Customer: No
JA: What troubleshooting have you tried?
Customer: I tried to encode the file in UTF-8. But it does not work well.
JA: Anything else you want the Mac expert to know before I connect you?
Customer: The original is sav.file with the corruption. I output it on text-editor and encode in Unicode(UTF-8) and try to read it on Excel. That's all I have done.
Submitted: 7 months ago.
Category: Email
Expert:  Bhavik Joshi replied 7 months ago.

Hi, I'm Bhavik. Welcome to JustAnswer. I'm reviewing your question now, and will reply back ASAP.

Expert:  Bhavik Joshi replied 7 months ago.

Please share that file with me , I will try to decode it.

Customer: replied 7 months ago.
Thank you for the quick reply!
The file is too large to upload here. What can I do?
Expert:  Bhavik Joshi replied 7 months ago.

You can upload it to google drive or dropbox and send its link to me.

Expert:  Bhavik Joshi replied 7 months ago.

Sorry for delay, I just got your message.

Customer: replied 7 months ago.
https://www.dropbox.com/s/fwlcqp1g9bw2f2z/socioec_encel_98o%20copy.txt?dl=0
Here you are. Please help me out.
Expert:  Bhavik Joshi replied 7 months ago.

Thanks !! ,I will have a look. Can you give me some background about this file ? From where it came etc ?

Customer: replied 7 months ago.
This is taken from http://evaluacion.oportunidades.gob.mx:8010/EVALUACION/en/eval_cuant/p_bases_cuanti.php
You can download the file from "Socioeconomic Characteristics of Household Surveys 1998" => "Socioeconomic October" => "Database".
Expert:  Bhavik Joshi replied 7 months ago.

Okay , I could open that link (the one which ends with database ) which survey file you are looking for ?

Customer: replied 7 months ago.
The one from "Socioeconomic Characteristics of Household Surveys 1998" => "Socioeconomic October" in that page.
Expert:  Bhavik Joshi replied 7 months ago.

I think, I got it. Which all files do you need ?

Customer: replied 7 months ago.
I need the one in the intersection of a row named "Socioeconomic October" with a column named "Database"
Expert:  Bhavik Joshi replied 7 months ago.

I got the solution of it. Which OS do you use ? Windows or Mac ?

Customer: replied 7 months ago.
I am using Mac. Sierra is the current OS.
Expert:  Bhavik Joshi replied 7 months ago.

Okay, I am trying to convert it to excel file, I can now read the data in this file.

Expert:  Bhavik Joshi replied 7 months ago.

Would you like me to remotely connect to your machine and show you what all I did and how can do the same for other similar files in future ?

Customer: replied 7 months ago.
Could you please just tell me how to do so that I can do it myself? That would be more preferred.
Expert:  Bhavik Joshi replied 7 months ago.

Sure, Please open the below document. I have mentioned the simplest option to open this data in it. You can do the same thing with other files as well.

I am opening my rating for you. Please provide your positive rating to me if you are satisfied otherwise please post your concerns here, I will try to answer them.

Related Email Questions