March
February
January
 | 
|
 | A workaround for encoding problems in ExcelCategory: Software | |
When I download a file from one of the data tables in BigMachines I want to modify it in some way and then upload it back again. If there are hundreds or thousands of rows I need this data manipulation to be in Excel. Sometimes there are Swedish characters like å, ä or ö in the file and they need be be preserved this way. However when opening a csv-file encoded with UTF-8 in Excel these characters are displayed as very odd characters instead. If I replace the odd characters with the correct ones and save it, it is saved as ANSI and uploading it will instead make it look strange and cause errors in the system. Here is a little workaround to make it work. 1. Open the csv-file in Notepad++ and convert it to ANSI and save. 2. Import to excel and modify and save. 3. Open again in Notepad++ and convert to UTF-8 |  | |
| Tags: excel, encoding, bigmachines, ansi, utf-8, notepad | |||||
| Related blog entries: - How to change the comment line color in Notepad++ - Copying a Salesforce object instance and keeping the id? - Getting unique rows in an Excel sheet - Login error when logging into BigMachines - A look at BigMachines - Paste copied cells from Excel into a Lotus Notes document - When special characters are saved as odd characters in a MySQL database - Swedish characters become strange characters during upsert with the Salesforce dataloader - Creating a link to a Notes document in Excel or Word - Where to set the charset of a web application - A tip on how to fit data in excel - How to get web data into excel | |||||
| Created by Niklas Waller - 2009-10-22 00:01:00 |
| ||||
|
|
Comments: | |
| Comment posted 2009-10-22 08:42:40 by Beds Melbourne As you noticed, the Mac side of things is OK. Most likely the Windows users have not installed the latest service pack updates on their computers. | |
| Comment posted 2009-10-24 09:05:14 by mortgage loans It's better If you feel like directing your art-piece in a special way, or want your viewer to look at a special part of the piece first – think of what you want it to say, or what feeling you are going for. For example, this time I have a skull in the middle and the surrounding letters give you the whole piece. | |
| Comment posted 2009-10-24 11:48:20 by cheap car insurance for young drivers nice thinking u have that's really different from other thanks for creations. | |
| Comment posted 2009-10-24 11:50:51 by Cameras Most likely the Windows users have not installed the latest service pack updates on their computers. | |
| Comment posted 2009-10-24 13:30:23 by SEO Services really nice post and nice info.... u have | |
| Comment posted 2009-10-26 09:20:20 by r4 nintendo ds A workaround for encoding problems in Excel that' s a nice post and useful also. thanks for creations. | |
| Comment posted 2009-10-28 06:27:30 by shopsite templates nice post really that' s nice thinking thanks for sharing with us. | |
| Comment posted 2009-10-28 09:15:36 by sell your car A workaround for encoding problems in Excel that' s a nice post and useful also. thanks for creations. | |
| Comment posted 2009-10-29 12:32:00 by liposculpture Most likely the Windows users have not installed the latest service pack updates on their computers thanks man. | |
| Comment posted 2009-10-31 06:40:26 by Strand-by-Strand the Windows users have not installed the latest service pack updates on their computers. very informative post thanks keep posting. | |
| Comment posted 2009-11-03 07:58:05 by Massage Brisbane Window7 has launched. And it is best of all. So STOP Talking about anything else. | |
