Format Function Request To Replace Accented Characters

[juancolicchio]

How to Replace Accented Characters (diacritics) with English letters in Google Sheets

The Google Sheets function will convert diacritics letters or characters with accents to their simple Latin equivalent. For instance, á or à will change to 'a', ê or ë will be replaced with e and so on.

www.labnol.org

 

[Pabblymember11]

Hey @juancolicchio

For your concern please check out the following thread to convert the characters -

Gmail: Translate General Language Characters

You can make use of Data Transformer with action event as "Gmail" as shown below in order to change the lanaguage in Gmail readablae format - Once you get the words in Gmail readsable format, you can map them in the next step as shown below -

forum.pabbly.com

 

[juancolicchio]

Hey @juancolicchio

For your concern please check out the following thread to convert the characters -

Gmail: Translate General Language Characters

You can make use of Data Transformer with action event as "Gmail" as shown below in order to change the lanaguage in Gmail readablae format - Once you get the words in Gmail readsable format, you can map them in the next step as shown below -

forum.pabbly.com

Thank you for sharing. I don't understand, by using this function, how can we transform the data back to readable characters so we can update our crm system?

 

[Pabblymember11]

Hey @juancolicchio

Currently their no function available to convert the accented characters to de-accented. Though you can use the spreadsheet formula if available on Google and then can apply it on the "Number Formatter by Pabbly: Spreadsheet Formulas" action step.

 

[juancolicchio]

This won't work at scale. Google sheets has a api call limit that will not work with the amount of api calls required on our end.

 

[Pabblymember11]

Hey @juancolicchio

Currently, there is no function available to convert the accented letters into the normal English alphabets. Though we will try to add the "Normalize Accented Letters" function in the coming Text Formatter's next update.

 

[Pabblymember11]

Hey @juancolicchio

We have added the De-Accented function in the "Text Formatter" action step. Please check out this at your end and let us know if that works for you.