Hi there,
I am creating automated invoices for Paypal Payments.
For each purchase, I get the data of the customer from Paypal : Name, adresse, zip, City ( which I need for the invoice) and upload it into a google sheet.
The problem is we french people have accents everywhere, and we want to keep them, for exemple :
Laura Maroudé, 39 rue du Théâtre, 75019 Paris
will become in my google sheets :
Laura Maroud%E9, 39 Th%E9%E2tre, 75019 Paris
How can I tell make to keep the accents, or to revert them back ?
The issue is also, it’s not in every name so either I find a way to tell make to get the data as it is, or in find a way to revert back IF there is an accent.
Problem is, there are a lot of différent accents, I can’t imagine to use the replace function with every possibility to cover everything.
Thanks !
Hi @Alexandra_P ,
That’s strange, I have tried to reproduce your problem, my result is different.
My test scenario is the following:
.
Variable feeding:
In Google Sheet:
Here is the corresponding blueprint:
accent.json (22.4 KB)
Could you add some more information, the blueprint of your scenario, some screenshots?
BR,
PBI
Hello Philippe,
Thanx for taking the time 
So the data comes from paypal, this is the scenario :
and the output data looks systematicaly like this :
I’m currently trying something like this to replace a few of the most common accents (I still have to test it), I’ll see if it works but there are too much accents to cover them all !
Any ideas ?
Thank you !
That’s an interesting (and courageous) option.
But according to your screenshot, the output values of the PayPal module are “corrupted”, you should contact the support here, they may help you.
2 Likes
