Format string to replace characters with accents

Support
1

Hi there,

I am working on a format string to replace accents/special characters (mostly from Vietnamese) with normal characters so I can search for them on Piooner devices.

Here is the full format string:

$validate($replace( %title%,ä,a,á,a,à,a,ả,a,ã,a,ạ,a,â,a,ấ,a,ầ,a,ẩ,a,ẫ,a,ậ,a,ă,a,ắ,a,ằ,a,ẳ,a,ẵ,a,ặ,a,ë,e,é,e,è,e,ẻ,e,ẽ,e,ẹ,e,ê,e,ế,e,ề,e,ể,e,ễ,e,ệ,e,í,i,ì,i,ỉ,i,ĩ,i,ị,i,ö,o,ó,o,ò,o,ỏ,o,õ,o,ọ,o,ô,o,ố,o,ồ,o,ổ,o,ỗ,o,ộ,o,ơ,o,ớ,o,ờ,o,ở,o,ỡ,o,ợ,o,ü,u,ú,u,ù,u,ủ,u,ũ,u,ụ,u,ư,u,ứ,u,ừ,u,ử,u,ữ,u,ự,u,đ,d,ñ,n,Ä,A,Á,A,À,A,Ả,A,Ã,A,Ạ,A,Â,A,Ấ,A,Ầ,A,Ẩ,A,Ẫ,A,Ậ,A,Ă,A,Ắ,A,Ằ,A,Ẳ,A,Ẵ,A,Ặ,A,Ë,E,É,E,È,E,Ẻ,E,Ẽ,E,Ẹ,E,Ê,E,Ế,E,Ề,E,Ể,E,Ễ,E,Ệ,E,Í,I,Ì,I,Ỉ,I,Ĩ,I,Ị,I,Ö,O,Ó,O,Ò,O,Ỏ,O,Õ,O,Ọ,O,Ô,O,Ố,O,Ồ,O,Ổ,O,Ỗ,O,Ộ,O,Ơ,O,Ớ,O,Ờ,O,Ở,O,Ỡ,O,Ợ,O,Ü,U,Ú,U,Ù,U,Ủ,U,Ũ,U,Ụ,U,Ư,U,Ứ,U,Ừ,U,Ử,U,Ữ,U,Ự,U,Đ,D,Ñ,N,ç,c,ß,ss,œ,oe,Œ,OE,),)

Here are all the special characters so you can test them:

ä,á,à,ả,ã,ạ,â,ấ,ầ,ẩ,ẫ,ậ,ă,ắ,ằ,ẳ,ẵ,ặ,ë,é,è,ẻ,ẽ,ẹ,ê,ế,ề,ể,ễ,ệ,í,ì,ỉ,ĩ,ị,ö,ó,ò,ỏ,õ,ọ,ô,ố,ồ,ổ,ỗ,ộ,ơ,ớ,ờ,ở,ỡ,ợ,ü,ú,ù,ủ,ũ,ụ,ư,ứ,ừ,ử,ữ,ự,đ,ñ,Ä,Á,À,Ả,Ã,Ạ,Â,Ấ,Ầ,Ẩ,Ẫ,Ậ,Ă,Ắ,Ằ,Ẳ,Ẵ,Ặ,Ë,É,È,Ẻ,Ẽ,Ẹ,Ê,Ế,Ề,Ể,Ễ,Ệ,Í,Ì,Ỉ,Ĩ,Ị,Ö,Ó,Ò,Ỏ,Õ,Ọ,Ô,Ố,Ồ,Ổ,Ỗ,Ộ,Ơ,Ớ,Ờ,Ở,Ỡ,Ợ,Ü,Ú,Ù,Ủ,Ũ,Ụ,Ư,Ứ,Ừ,Ử,Ữ,Ự,Đ,Ñ,ç,ß,œ,Œ.

It works until the last "e"; everything after it will not be replaced.

Could someone help me out? I am not a coder so I don't know if I did something wrong with it or maybe I have exceeded the maximum number of characters that could be replaced.

Thank you!

2

You have to split $replace() into several statements. The one that you present is too long as it exceeds the maximum 64 parameters.
grafik
From:

4

Could you please tell me how to split them into several statements?

5

You have to create an action group with several actions that feature the $replace function.
You have probably already created an action group to house the initial $replace.
Now edit that group and copy the existing action a couple of times.
Then edit each of the copies and delete all the pairs that have been dealt with in another (copy of the) action.
A good measure is to use no more than 30 replace-pairs per action call.
Finally, save the action group with OK.

6

Thank you!

image

I am at this point. Do I have to enter each pair or is there a way to enter 30 pairs at once like you said?

7

If you want to use $REPLACE() then you have to use an action that allows a format string, e.g. "Format value".
Also, I would not use _TAG as target for the replacement but dedicated fields.
The function to copy actions should make that an easy option.