P
P
Pavel Mikhalovsky2017-11-28 02:44:22
csv
Pavel Mikhalovsky, 2017-11-28 02:44:22

What editors for csv in UTF-8 encoding are there?

I'm trying to process and correct a csv file with answers to one question (received in Google forms) utf-8 encoding
An example of a change, in the age column, for example, they write me not a number, but the text 20 years. Fortunately, there are only one out of a hundred such cases, it is easier for me to correct the file than to process it in pandas.
But I ran into the problem of finding an adequate csv editor.
Ordinary text editors are not very suitable due to the fact that it is easier for me to walk through the columns, and manually walking through the separators is quite difficult.
Excel refuses to save me in UTF-8 encoding adequately and corrupts my file.
Google search returns paid programs or freeware, which also refuses to work with UTF-8

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
SOTVM, 2017-11-28
@sotvm

using the same notepad++ search by mask (with a regular expression)
select the desired / found in separate lines,
for example:
find (regular expressions and new lines.)
replace with
for display convenience, mark with markers found and hide unmarked rows.
then editing,
then in the same way (search / replace),
delete \n (new lines that you yourself added)
5a1cda5f72a22417098257.png

C
cicatrix, 2017-11-28
@cicatrix

And what exactly spoils Excel? Works fine with UTF-8 for me.
There is also Libre/Open Office Calc

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question