Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 Excel Encoding Problem

views
     
TSbebe2231
post Jan 29 2019, 02:06 PM, updated 6y ago

New Member
*
Newbie
12 posts

Joined: Sep 2018
When I scrape data from a page and export it as CSV file, inside the csv some of the values show ▪� weird character.
I have change it to export as UTF-8 , but the problem still there. Any IT master know how to solve this?

user posted image

This post has been edited by bebe2231: Jan 29 2019, 02:07 PM


Attached thumbnail(s)
Attached Image
cassian948
post Jan 29 2019, 02:22 PM

Enthusiast
*****
Junior Member
889 posts

Joined: Jan 2017
From: Kuala Lumpur
QUOTE(bebe2231 @ Jan 29 2019, 02:06 PM)
When I scrape data from a page and export it as CSV file, inside the csv some of the values show ▪� weird character.
I have change it to export as UTF-8 , but the problem still there. Any IT master know how to solve this?

user posted image
*
There are non-printable characters is included, save as ANSI.

 

Change to:
| Lo-Fi Version
0.0127sec    0.33    6 queries    GZIP Disabled
Time is now: 29th March 2024 - 01:17 AM