Dear community,
Is there a formula in xls form to remove the accents?
In our form: data collector enter the names with the accent. As we use the name to generate a unique code read by a database it creates some problems.
Thank you for your answer,
Emma
You could use the translate() function to replace all the different accents with the corresponding non-accented letter. For example translate(${myText},'àáèéôö','aaeeoo')
remove_accents_example.xlsx (8.8 KB)
How many different accented letters are possible?
Dan's solution is very clever, and I love it, but it's fragile.
The likely best fix is to use whatever tool inserts values into your database to strip out non-ASCII characters. For example, if you are using Python, you'd call ascii().
Hi,
Thank you very much for your answers.
We are trying at the moment : 1) using a regex constraint in the form that does not accept accents and maybe we will implement 2) the ascii solution for more security.
