Rif.: When reading from csv file to table indicator unwanted symbols are displaying

[M0han]

Actually I want to read a data from csv file and display to user when reading into table indicator unwanted symbols are displaying and same I rounded with black ink.

[pincpanter]

Unwanted characters are embedded in your files, post one of them as an example. Are the symbols always at the beginning of the file?

[billko]

---

@pincpanter wrote:

Unwanted characters are embedded in your files, post one of them as an example. Are the symbols always at the beginning of the file?

---

You're thinking it might be Unicode BOM?

[pincpanter]

---

@billko  ha scritto:

---

@pincpanter wrote:

Unwanted characters are embedded in your files, post one of them as an example. Are the symbols always at the beginning of the file?

---

You're thinking it might be Unicode BOM?

---

Yes. Probably UTF-8, otherwise the table display would be considerably funnier.

[billko]

---

@pincpanter wrote:

---

@billko  ha scritto:

---

@pincpanter wrote:

Unwanted characters are embedded in your files, post one of them as an example. Are the symbols always at the beginning of the file?

---

You're thinking it might be Unicode BOM?

---

Yes. Probably UTF-8, otherwise the table display would be considerably funnier.

---

I know that sometimes Windows Notepad will add a BOM if it thinks one is needed.  I've seen where I opened up a text file in Notepad and after I closed it, it added the BOM without telling me it did or asking me to save it.

[Yamaeda]

TrimWhitespace will probably solve it, but you should check your .csv and/or how you write to it.

[billko]

---

@Yamaeda wrote:

TrimWhitespace will probably solve it, but you should check your .csv and/or how you write to it.

---

I don't know if it would be considered "white space"

[M0han]

Yes at starting of the row

[LLindenbauer · Accepted solution]

Rename your file from csv to txt and open it in a text editor.

For example, notpad.exe offers you to save a file with or without Byte Order Mark.

Try "Save as" and in "Encoding", choose one without BOM. UTF-8 might work. Try ANSI if it does not.

[Kyle97330]

We've just started putting this (or similar) on our code that opens text files:

While you can make it so individual files or editors will not leave the mark by changing some program somewhere, guaranteeing that every user always does it is impossible.  It's much more practical to just get used to removing/ignoring it than it is to complain about it or try to get all text file users to reconfigure Notepad or whatever they use.