Skip to main content
December 18, 2024
Question

Get the encoding (UTF8 vs UTF16) of a file

  • December 18, 2024
  • 2 replies
  • 0 views

Hi Community,

I'm working in a project where data ingestion is very important and we get data from csv files.

The problem I have at the moment is that with the plug in ps-plugin-ExcelTools in particular with the smart service Import CSV to Database I need to set the charset input (e.g UTF-8 default or UTF-16).

Due to the fact that I could receive files in both encoding format, the question is: Is there any solution to get the encoding of a file? 

I find a solution saving the document in Base64 into Db and analyzing the string obtained. Does anyone have a smarter solution?

Thx in Advance.

Bye bye

2 replies

stefanhelzle0001
December 18, 2024

I do not know of any existing way to detect the charset from Appian. This might be a good case for a custom plugin.

December 19, 2024

Thx a lot Stefan I was waiting for your answer :)

Best regards and happy holidays