I’m trying out n8n but I’m having issues with special characters in french.
As far as I understand, it’s an issue related to encoding.
My csv comes from phantombuster and is read in a spreadsheet note like this:
As you can see, the csv gets read using the wrong encoding.
How could I fix that?
I have many files like that with many columns in each.
Is it possible to set encoding for the whole workflow?
I’m running on the cloud instance created today.
Hi @Joachim_Brindeau, welcome to the community
Have you tried out the Read As String option of the Spreadsheet File node? This works fine for me for the example dataset from your screenshot:
Thank you very much @MutedJam !
May I bother you with one more question?
I’m having trouble understanding what blocks to use in the following case (the one from original post above):
- A csv with record set A + record set B with field URL
- An airtable with record set A with field URL and field ID
How can I check whether to append or update into airtable depending if the URL exists or not?
I thought a simple switch would suffice but apparently not.
Kind of lost on this.
Thanks a lot