The idea is:
Hi,
we search a solution it to be possible to automatically detect the encoding and delimiter in csv files as it happens with other platforms and languages.
Nowadays, it is possible to manually indicate this information, but we do not always know what we are receiving. So for now, we use Python to try to find out by trying
- Read the file in UTF-8
- Check in Python if there are invalid characters in the read data
- If it doesn’t exist, everything is ok, if it does, read again but in Latin-1
A native solution would be more correct and there would be no need to read the same file twice
Thanks
I think it would be beneficial to add this because:
It was not necessary to know this information beforehand.
It avoided multiple readings of the file.