tChangeFileEncoding and UTF8 encoding

[Anonymous]

Hello, 

I have an input_file encoded in ANSI that I want to encode to UTF-8.

So basically, I use the tChangeFileEncoding component and I do get an output_file encoded in UTF-8. While I open it with notepad++, everything is alright. 

But when i open it with Excel, "€" and "é" caracters show me things like "€_" and "é". 

Is there any way to fix this ? 

[Anonymous]

Hello, @JoshyBrown 

You are a Genius !!

Thanks you so much !

[Anonymous]

I'll take the compliment even though this problem gave me quite a hard time 

[Anonymous]

@JoshyBrown, do you know how to convert CSV UTF-8 to UTF-8-BOM please ?

My client need a CSV in UTF-8... with BOM for special caraters... (not "windows-1252" regrettably)

Thanks you

[Anonymous]

Sorry, that I don't know. I didn't have to go through this problem.

[CDol1613983942]

Hi @David Joshua​ ,

Can you please give details for tjava component custom routine?