How to sort accented data in form fields

Forum|Forum|6 years ago
October 19, 2019
5 replies
1887 views

I want to sort the data into form fields. The fields are arranged in a simple table with 10 rows and 3 columns with the headings "Number", "Name" and "Reward". I have the fields "pNum.0" ... "pNum.9", "name.0" ... "name.9" and "rew.0" ... "rew.9".
After filling in the fields I want to click on the "sort" button and sort the filled rows alphabetically according to the "Name" column. Names are also accented, eg "Šimon", "Čeněk" ...

vyplata-odmen.pdf

This topic has been closed for replies.

try67

Community Expert

You can edit the "compare" function to replace all accented characters with non-accented ones before comparing the two strings.

I believe that will solve your problem.

For example:

var names = ["Simon", "Šimon", "Simona", "Šimona", "Albert", "Zazie"];
names.sort(compare)
console.println(names)

function compare(a, b) {
  a = replaceAccentedChars(a);
  b = replaceAccentedChars(b);
  if (a[0] < b[0]) {
	return -1;
  }
  if (a[0] > b[0]) {
	return 1;
  }
  return 0;
} 

function replaceAccentedChars(s) {
	s = s.replace(/Š/g, "S");
	return s;
}

The output is:

Albert,Simon,Šimon,Simona,Šimona,Zazie

Without replacing the accented chars the output is:

Albert,Simon,Simona,Zazie,Šimon,Šimona

try67

Community Expert

PS. Your compare function is not very good, in my opinion, as it only compares the first letter. That means that if you compare "Simon" with "Simona" it won't actually compare them but just return the first value each time.

I recommend you change it to comparing the full strings.