Weird text to .ods convertion

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP











up vote
0
down vote

favorite












I have a list of dates in the 'weekday month day hour:min:s yr' "squeezed" from a log with grep [...] | cut [...]



...
Wed Dec 9 14:42:51 2015
Mon Dec 14 18:16:10 2015
Mon Jan 6 13:16:48 2014
Fri Dec 4 15:42:00 2015
...


redirected to a text file named dates.csv. There are about 3000 lines of text. I have opened this file with libreoffice dates.csv which gave me a spreadsheet with a single cell occupied by a very long string -- thousands of Chinese(?) characters: ㄠ㨴㐵㔺‶〲㔱吊敵䨠湵†′㜱〺㨵㠰㈠㄰ਵ畔⁥畊㈠ㄠ㨷㜴ㄺ″〲㔱吊敵䨠湵†′㠱ㄺ㨳㈲㈠㄰ਵ敗⁤畊㌠ㄠ㨵㔱㐺″〲㔱圊摥䨠湵†″㔱ㄺ㨵㌴㈠㄰ਵ敗⁤畊㌠ㄠ㨵ㄴ㌺″〲㔱圊摥䨠湵†″㜱㔺㨸㈳㈠㄰ਵ桔⁵畊㐠ㄠ㨵㠱ㄺ‵〲㔱吊畨䨠湵†‴㔱㐺㨲㠳㈠㄰ਵ桔⁵畊㐠ㄠ㨶㔳㈺‷〲㔱䘊楲䨠湵†‵㘱㌺㨵㤴㈠㄰ਵ潍畊㠠ㄠ㨴㘳㌺‵〲㔱䴊湯䨠湵†‸㔱㔺㨳㐰㈠㄰ਵ潍畊㠠ㄠ㨷㠴㐺‵〲㔱䴊湯䨠湵†‸㠱㈺㨵㔱㈠㄰ਵ畔⁥畊㤠ㄠ㨵㘰〺‵〲㔱吊敵䨠湵†‹㔱㈺㨵㈵㈠㄰ਵ畔⁥畊㤠ㄠ㨵〵㔺‸〲㔱吊敵䨠湵†‹㘱㈺㨷㤰㈠㄰ਵ畔⁥畊㤠ㄠ㨶㌵㐺‶〲㔱吊敵䨠湵†‹㜱ㄺ㨸㤴㈠㄰ਵ畔⁥畊㤠ㄠ㨸㠲㔺‰〲㔱圊摥䨠湵ㄠ‰㔱㔺㨶㈱㈠㄰ਵ敗⁤畊〱ㄠ㨶.



Any explanation?






character-encoding libreoffice







share|improve this question























  • It's just majibaka. Libreoffice is reading text in wrong encoding. I believe your libreoffice is configured in a strange way that it use a non-ascii encoding as default
    – ç¥žç§˜å¾·é‡Œå…‹
    Sep 10 at 16:12










  • try to cat the file to try, it should display normally. Which can prove the file is not corrupted .
    – ç¥žç§˜å¾·é‡Œå…‹
    Sep 10 at 16:14














up vote
0
down vote

favorite












I have a list of dates in the 'weekday month day hour:min:s yr' "squeezed" from a log with grep [...] | cut [...]



...
Wed Dec 9 14:42:51 2015
Mon Dec 14 18:16:10 2015
Mon Jan 6 13:16:48 2014
Fri Dec 4 15:42:00 2015
...


redirected to a text file named dates.csv. There are about 3000 lines of text. I have opened this file with libreoffice dates.csv which gave me a spreadsheet with a single cell occupied by a very long string -- thousands of Chinese(?) characters: ㄠ㨴㐵㔺‶〲㔱吊敵䨠湵†′㜱〺㨵㠰㈠㄰ਵ畔⁥畊㈠ㄠ㨷㜴ㄺ″〲㔱吊敵䨠湵†′㠱ㄺ㨳㈲㈠㄰ਵ敗⁤畊㌠ㄠ㨵㔱㐺″〲㔱圊摥䨠湵†″㔱ㄺ㨵㌴㈠㄰ਵ敗⁤畊㌠ㄠ㨵ㄴ㌺″〲㔱圊摥䨠湵†″㜱㔺㨸㈳㈠㄰ਵ桔⁵畊㐠ㄠ㨵㠱ㄺ‵〲㔱吊畨䨠湵†‴㔱㐺㨲㠳㈠㄰ਵ桔⁵畊㐠ㄠ㨶㔳㈺‷〲㔱䘊楲䨠湵†‵㘱㌺㨵㤴㈠㄰ਵ潍畊㠠ㄠ㨴㘳㌺‵〲㔱䴊湯䨠湵†‸㔱㔺㨳㐰㈠㄰ਵ潍畊㠠ㄠ㨷㠴㐺‵〲㔱䴊湯䨠湵†‸㠱㈺㨵㔱㈠㄰ਵ畔⁥畊㤠ㄠ㨵㘰〺‵〲㔱吊敵䨠湵†‹㔱㈺㨵㈵㈠㄰ਵ畔⁥畊㤠ㄠ㨵〵㔺‸〲㔱吊敵䨠湵†‹㘱㈺㨷㤰㈠㄰ਵ畔⁥畊㤠ㄠ㨶㌵㐺‶〲㔱吊敵䨠湵†‹㜱ㄺ㨸㤴㈠㄰ਵ畔⁥畊㤠ㄠ㨸㠲㔺‰〲㔱圊摥䨠湵ㄠ‰㔱㔺㨶㈱㈠㄰ਵ敗⁤畊〱ㄠ㨶.



Any explanation?






character-encoding libreoffice







share|improve this question























  • It's just majibaka. Libreoffice is reading text in wrong encoding. I believe your libreoffice is configured in a strange way that it use a non-ascii encoding as default
    – ç¥žç§˜å¾·é‡Œå…‹
    Sep 10 at 16:12










  • try to cat the file to try, it should display normally. Which can prove the file is not corrupted .
    – ç¥žç§˜å¾·é‡Œå…‹
    Sep 10 at 16:14












up vote
0
down vote

favorite









up vote
0
down vote

favorite











I have a list of dates in the 'weekday month day hour:min:s yr' "squeezed" from a log with grep [...] | cut [...]



...
Wed Dec 9 14:42:51 2015
Mon Dec 14 18:16:10 2015
Mon Jan 6 13:16:48 2014
Fri Dec 4 15:42:00 2015
...


redirected to a text file named dates.csv. There are about 3000 lines of text. I have opened this file with libreoffice dates.csv which gave me a spreadsheet with a single cell occupied by a very long string -- thousands of Chinese(?) characters: ㄠ㨴㐵㔺‶〲㔱吊敵䨠湵†′㜱〺㨵㠰㈠㄰ਵ畔⁥畊㈠ㄠ㨷㜴ㄺ″〲㔱吊敵䨠湵†′㠱ㄺ㨳㈲㈠㄰ਵ敗⁤畊㌠ㄠ㨵㔱㐺″〲㔱圊摥䨠湵†″㔱ㄺ㨵㌴㈠㄰ਵ敗⁤畊㌠ㄠ㨵ㄴ㌺″〲㔱圊摥䨠湵†″㜱㔺㨸㈳㈠㄰ਵ桔⁵畊㐠ㄠ㨵㠱ㄺ‵〲㔱吊畨䨠湵†‴㔱㐺㨲㠳㈠㄰ਵ桔⁵畊㐠ㄠ㨶㔳㈺‷〲㔱䘊楲䨠湵†‵㘱㌺㨵㤴㈠㄰ਵ潍畊㠠ㄠ㨴㘳㌺‵〲㔱䴊湯䨠湵†‸㔱㔺㨳㐰㈠㄰ਵ潍畊㠠ㄠ㨷㠴㐺‵〲㔱䴊湯䨠湵†‸㠱㈺㨵㔱㈠㄰ਵ畔⁥畊㤠ㄠ㨵㘰〺‵〲㔱吊敵䨠湵†‹㔱㈺㨵㈵㈠㄰ਵ畔⁥畊㤠ㄠ㨵〵㔺‸〲㔱吊敵䨠湵†‹㘱㈺㨷㤰㈠㄰ਵ畔⁥畊㤠ㄠ㨶㌵㐺‶〲㔱吊敵䨠湵†‹㜱ㄺ㨸㤴㈠㄰ਵ畔⁥畊㤠ㄠ㨸㠲㔺‰〲㔱圊摥䨠湵ㄠ‰㔱㔺㨶㈱㈠㄰ਵ敗⁤畊〱ㄠ㨶.



Any explanation?






character-encoding libreoffice







share|improve this question















I have a list of dates in the 'weekday month day hour:min:s yr' "squeezed" from a log with grep [...] | cut [...]



...
Wed Dec 9 14:42:51 2015
Mon Dec 14 18:16:10 2015
Mon Jan 6 13:16:48 2014
Fri Dec 4 15:42:00 2015
...


redirected to a text file named dates.csv. There are about 3000 lines of text. I have opened this file with libreoffice dates.csv which gave me a spreadsheet with a single cell occupied by a very long string -- thousands of Chinese(?) characters: ㄠ㨴㐵㔺‶〲㔱吊敵䨠湵†′㜱〺㨵㠰㈠㄰ਵ畔⁥畊㈠ㄠ㨷㜴ㄺ″〲㔱吊敵䨠湵†′㠱ㄺ㨳㈲㈠㄰ਵ敗⁤畊㌠ㄠ㨵㔱㐺″〲㔱圊摥䨠湵†″㔱ㄺ㨵㌴㈠㄰ਵ敗⁤畊㌠ㄠ㨵ㄴ㌺″〲㔱圊摥䨠湵†″㜱㔺㨸㈳㈠㄰ਵ桔⁵畊㐠ㄠ㨵㠱ㄺ‵〲㔱吊畨䨠湵†‴㔱㐺㨲㠳㈠㄰ਵ桔⁵畊㐠ㄠ㨶㔳㈺‷〲㔱䘊楲䨠湵†‵㘱㌺㨵㤴㈠㄰ਵ潍畊㠠ㄠ㨴㘳㌺‵〲㔱䴊湯䨠湵†‸㔱㔺㨳㐰㈠㄰ਵ潍畊㠠ㄠ㨷㠴㐺‵〲㔱䴊湯䨠湵†‸㠱㈺㨵㔱㈠㄰ਵ畔⁥畊㤠ㄠ㨵㘰〺‵〲㔱吊敵䨠湵†‹㔱㈺㨵㈵㈠㄰ਵ畔⁥畊㤠ㄠ㨵〵㔺‸〲㔱吊敵䨠湵†‹㘱㈺㨷㤰㈠㄰ਵ畔⁥畊㤠ㄠ㨶㌵㐺‶〲㔱吊敵䨠湵†‹㜱ㄺ㨸㤴㈠㄰ਵ畔⁥畊㤠ㄠ㨸㠲㔺‰〲㔱圊摥䨠湵ㄠ‰㔱㔺㨶㈱㈠㄰ਵ敗⁤畊〱ㄠ㨶.



Any explanation?






character-encoding libreoffice




character-encoding libreoffice






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Sep 10 at 16:16









Jeff Schaller

33.1k849111




33.1k849111










asked Sep 10 at 16:08









Mihai Pește

1




1











  • It's just majibaka. Libreoffice is reading text in wrong encoding. I believe your libreoffice is configured in a strange way that it use a non-ascii encoding as default
    – ç¥žç§˜å¾·é‡Œå…‹
    Sep 10 at 16:12










  • try to cat the file to try, it should display normally. Which can prove the file is not corrupted .
    – ç¥žç§˜å¾·é‡Œå…‹
    Sep 10 at 16:14
















  • It's just majibaka. Libreoffice is reading text in wrong encoding. I believe your libreoffice is configured in a strange way that it use a non-ascii encoding as default
    – ç¥žç§˜å¾·é‡Œå…‹
    Sep 10 at 16:12










  • try to cat the file to try, it should display normally. Which can prove the file is not corrupted .
    – ç¥žç§˜å¾·é‡Œå…‹
    Sep 10 at 16:14















It's just majibaka. Libreoffice is reading text in wrong encoding. I believe your libreoffice is configured in a strange way that it use a non-ascii encoding as default
– ç¥žç§˜å¾·é‡Œå…‹
Sep 10 at 16:12




It's just majibaka. Libreoffice is reading text in wrong encoding. I believe your libreoffice is configured in a strange way that it use a non-ascii encoding as default
– ç¥žç§˜å¾·é‡Œå…‹
Sep 10 at 16:12












try to cat the file to try, it should display normally. Which can prove the file is not corrupted .
– ç¥žç§˜å¾·é‡Œå…‹
Sep 10 at 16:14




try to cat the file to try, it should display normally. Which can prove the file is not corrupted .
– ç¥žç§˜å¾·é‡Œå…‹
Sep 10 at 16:14















active

oldest

votes











Your Answer







StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













 

draft saved


draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f468056%2fweird-text-to-ods-convertion%23new-answer', 'question_page');

);

Post as a guest






















active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes















 

draft saved


draft discarded















































 


draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f468056%2fweird-text-to-ods-convertion%23new-answer', 'question_page');

);

Post as a guest
































































-