Replace BOM character from csv

[vkalra]

Hello,
I am getting the special BOM character ZWNBSP (U+FEFF Zero Width No-Break Space (BOM, ZWNBSP) Unicode Character) that I need to replace from my csv before further processing. I went through the following posts already but I am not able to replace using the String.replace(“\uFEFF”, “”); function.

How to replace unicode in string

An alternative solution: text = "Tổng cộng" normalText = String.Join("", text.Normalize(System.Text.NormalizationForm.FormD).ToCharArray().Where(Function(c) System.Globalization.CharUnicodeInfo.GetUnicodeCategory(c) <> System.Globalization.UnicodeCategory.NonSpacingMark).ToArray) [image] [image]

Real's How-to

Any other leads to replace this character ? I still see the ZWNBSP in my file even after trying to replace it.

[Yoichi]

Hi,

How about the following?

strVar.Replce(ChrW(65279),"")

Regards,

[vkalra]

Thanks @Yoichi , Bang on!