Replace BOM character from csv

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.

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

1 Like

Hi,

How about the following?

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

Regards,

1 Like

Thanks @Yoichi , Bang on!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.