Special Separater Character as Delimiter in imported .csv file

English
,
#1

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

#2

@qubit1 Thanks for the suggestion. Copying U+00B5 did not work however.

#3

@Blue_bullet1 – did you try to copy this symbol directly → “µ” ?

#4

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.

#5

@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.

#6

@Blue_bullet1 – I gave you a bit more karma so you can comment on my Answer and upload files.

#7

@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!

#8

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.

#9

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.

#10

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’.

#11

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/)

#12

This basically sorted as a file encoding issue thanks to @qubit1 and @Pedro1. Here is my test: $ file -bi file.csv

#13

@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)

#14

Sample .csv file for delimited file using x’B5’. Rename .ods to .csv.

delimit_test.csv.ods

#15

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.

#16

@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.

#17

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.