Hello,
In LibreOffice calc how do I specify an other separator that cannot be typed for importing my .csv file? My separator is x’B5’ (micro symbol). I have tried x’B5’ and 181. Neither of those work.
Rob Burness
No, but I just tried it by copying µ from your comment above. That does not work either. The x’B5’ shows as a rectangle in the preview pane for import and again as a rectangle in calc. I have verified the character is x’B5’ in an editor (The Hessling Editor-the). In fact I used the to create the .csv file.
@qubit1 I tried your .csv file with no conversion. I have a snapshot of your file renamed from snapshot1.png to snapshot1.ods but do not know how to post the link as you did for mu-csv.csv.ods. I am running Linux Mint 14 KDE (64 bit) LO 4.0.2.2. file:///home/rob/Documents/snapshot1.ods Character set is Greek (DOS/IOS2-737) on Text Import Screen.
@Blue_bullet1 – can you upload an example of your CSV file? (rename to XYZ.ODS so you can upload the file)
To upload a file, use the paperclip icon in the GUI.
Thanks!
I have a sample file to upload but do not see a paper clip anywhere in the gui. I see a link but no paper clip. edit: I found the paper clip by using Answer instead of Comment.
Hi @Blue_bullet1,
Have you tried copying and pasting-in the unicode symbol? Wikipedia says that U+00B5 is this symbol: µ
Update: Here’s a CSV file separated by the U+00B5 symbol (Note: Please change ODS extension to CSV – the Ask site has a restrictive set of allowed file extensions):
I can import this CSV file into LO 4.0.2.1 on Ubuntu 12.04.2 without any problems.
As I look at your .csv file in the I see two characters, a x’C2’ followed by a x’B5’. x’C2’ is latin capital letter A with circumflex. My file is delimited only by x’B5’.
I don’t know if this helps but @Blue_bullet1’s csv is encoded as ANSI and @qubit1’s as UTF-8. You can use a text editor to change encoding (I use Notepad2-mod http://xhmikosr.github.io/notepad2-mod/)
This basically sorted as a file encoding issue thanks to @qubit1 and @Pedro1. Here is my test: $ file -bi file.csv
@oweng is correct @cubit provided the solution: Hi @Blue_bullet1,
If I set my Character set to "Western Europe (ISO-8859-1), and if I then put the character “µ” into the Other field, I can import your document, split into (I believe) the correct columns.
qubit (15 hours ago)
Hi @Blue_bullet1,
If I set my Character set to "Western Europe (ISO-8859-1), and if I then put the character “µ” into the Other field, I can import your document, split into (I believe) the correct columns.
@cubit You solved my problem. Using the Western Europe (ISO-8859-1) character set loads the file properly. Thank you for your help. I had never paid attention to the Character Set selection box on the Text Import Screen before.