WikiDer > Yordam: Saralash - Vikipediya

Help:Sorting - Wikipedia

Saralash jadvallaridan foydalanish

Vikipediyani ko'rib chiqayotganda duch kelishingiz mumkin jadvallar qilingan tartiblangan. Saralanadigan jadval bir yoki bir nechta sarlavha kataklaridagi o'qlar bilan aniqlanadi. Ularni bosish jadval satrlarini tanlangan ustun asosida o'sish tartibida tartiblashiga olib keladi. Xuddi shu o'qni ikkinchi marta bosish kamayish tartibida tartiblanadi. Uchinchi marta bosish butun jadvalning asl tartibini tiklaydi. Masalan; uchinchi marta bosish sabab bo'ladi Qasddan odam o'ldirish darajasi bo'yicha mamlakatlar ro'yxati subregion tomonidan asl tartibiga qaytarish.

Haqiqiy saralash jarayoni kompyuteringizda amalga oshiriladi mijoz tomonidagi JavaScript. Shu sababli ushbu funksiyadan faqat sizning veb-brauzeringizda JavaScript yoqilgan bo'lsa foydalanish mumkin. Saralash jarayoni, shuningdek, kompyuteringizga va ma'lumotlar miqdoriga bog'liq. Sekin kompyuterda juda katta stolni saralash uzoq vaqt talab qilishi mumkin.

Misol

Bu kichkintoyning misoli tartiblangan stol.

ismma'lumotlarko'proq ma'lumotlar
mushuklar27353
itlar658,492
sichqonlar1,649548

Murakkab sarlavhali jadvallar

Hozirgiga qaraganda ancha murakkab sarlavhali jadvallarni to'g'ri saralash. Masalan:

ismma'lumotlar ustunlariboshqa ustun
ma'lumotlarko'proq ma'lumotlar
mushuklar273531
itlar658,4922
sichqonlar1,6495483

Ikki yoki undan ortiq sarlavha satrlari yordamida saralash strelkalari sukut bo'yicha pastki sarlavha qatoriga joylashtiriladi. Sozlash orqali ularni maksimal bir qator yuqoriroq joylashtirish mumkin class = "sorttop" pastki satr satrining yuqori qismida.

Odatiy

1-ustunustun 2
37
13
24
{| class = "wikitable sortable" | -! 1-ustun! ustun 2 | -! style = "text-align: left;" | 3! style = "text-align: left;" | 7 | - | 1 | 3 | - | 2 | 4 |}

Foydalanish class = "sorttop"

1-ustunustun 2
37
13
24
{| class = "wikitable sortable" | -! 1-ustun! ustun 2 | - class = "sorttop"! style = "text-align: left;" | 3! style = "text-align: left;" | 7 | - | 1 | 3 | - | 2 | 4 |}

Murakkab datarovli jadvallar

Jadvallarda bir nechta qatorlarni o'z ichiga olgan kataklar bo'lishi mumkin | qatorlar =n. (Qarang Yordam: rowspan).

Satrlar satrini har safar ishlatishda ko'rsatilishi kerak. Har qanday saralashni amalga oshirishdan oldin, qator oralig'ini sozlash to'g'ri bo'lishi kerak. Noto'g'ri rowspan tashkiloti noto'g'ri ma'lumotlarni qoldirib, saralash opsiyasini buzadi.

Quyidagi misollarga qarang.

Tartiblanganda barcha qatorlar to'ldiriladi. Ratsionsiz jadvallarni kamroq tajribali muharrirlar va jadvalni tahrirlash uchun bir martagina to'xtaydigan muharrirlar osonroq saqlab turishadi.

Ish tartibida tartiblash bilan qatorlarni to'g'ri qatorga qo'ying:

ismmashhurlikma'lumotlarko'proq ma'lumotlaryil
mushuklarmashhur uy hayvonlari273532013
itlar658,4922014
sichqonlar1,649548

E'tibor bering, saralashdan so'ng, qatorlarni ajratish katakchalari qatorlarga bo'linadi va ularning tarkibi takrorlanadi (misolda "2014" yil). Agar jadvalning asl tartibi xuddi shu o'qga uchinchi marta bosish orqali tiklansa, u holda hujayralar takrorlanib qoladi va asl qatorga qaytarilmaydi.

Satrlarni buzish va qatorlar va ustunlardagi aralashmalarga olib keladigan noto'g'ri qatorlar:

Qator oralig'idagi tanaffuslarni saralash variantidan noto'g'ri foydalanish
ismmashhurlikma'lumotlarko'proq ma'lumotlaryil
mushuklarmashhur uy hayvonlari273532013
itlar658,4922014
sichqonlar1,649548

Onlayn jadval muharrirlari va rowspan

Bu erda oson wiki jadvali muharriri mavjud:

Jadvalning alohida kataklaridagi matn va havolalarni tahrir qilishni osonlashtiradi. Ayniqsa, stol korpusida qatorlar bo'lmaganda juda oson. Oldingi bo'limga qarang. Qatorsizlar jadvalning pastki ramkasini o'zgartirish va narsalarni aylantirish osonroq. Vikitekst ramkasi soddalashtirilganidan so'ng, onlayn jadval muharriri ham sodda bo'ladi, chunki jadvalni tahrirlash uchun vikitekstni ko'p tahrirlash shart emas.

Tor ekranda ko'proq ustunlar uchun imkoniyatlar

Vertikal sarlavhalar

Qarang: Andoza: Vert header
ism
ma'lumotlar
ko'proq ma'lumotlar
boshqa ustun
mushuklar273531
itlar658,4922
sichqonlar1,6495483

Ushbu shablon shuningdek satrlarni yoki ustunlarni qamrab oluvchi sarlavhalar bilan ishlaydi (yordamida) qatorli va kolspan). Eslatma vertikal chiziq yo'qligini | o'rtasida qator oralig'i = 2 va {{vert header

ism
ma'lumotlar ustunlari
boshqa ustun
ma'lumotlar
ko'proq ma'lumotlar
mushuklar273531
itlar658,4922
sichqonlar1,6495483
{| class = "wikitable sortable" | -! rowspan = 2 {{vert header | stp = 1 | name}}! colspan = 2 {{vert header | ma'lumotlar ustunlari}}! rowspan = 2 {{vert header | stp = 1 | boshqa ustun}} | -! {{vert header | stp = 1 | ma'lumotlar}}! {{vert header | stp = 1 | qo'shimcha ma'lumotlar}} | - | mushuklar | 273 | 53 | 1 | - | itlar | 65 | 8,492 | 2 | - | sichqonlar | 1,649 | 548 | 3 |}

Tugmalarni alohida qatorda saralash

Eslatma: Dan Aprel 2020 muhokamasi kimdir ekran o'quvchi yozgan: "Bo'sh / bosish mumkin bo'lgan qator bilan hali ham o'qish mumkin, bo'sh katakchalardan o'tib ketish juda zerikarli; Men ular boshqa holatlarda ham bo'lishi mumkinligini bilaman. Ehtimol, bu kichik kirish imkoniyatlarini yaxshilashni yo'qotadigan holatlardan biri ekranlarda yaxshiroq namoyish qilish uchun hozircha. " Bor Phabricator vazifasi T35249 saralash belgisining standart joylashuvi sarlavha matni ostida bo'lishini so'rab.

Jadvalni tor ekranlarda ixchamroq qilish uchun saralash tugmachalari matn joylashgan sarlavha katakchalari ostiga qo'shimcha sarlavha qatoriga qo'yilishi mumkin. Saralash tugmasi har doim eng pastki sarlavha hujayrasida tugaydi.

Qator oralig'ini qo'shing <br> yoki bo'sh joy & nbsp; bo'sh sarlavha hujayralaridan birida. Aks holda saralash qatori juda tor bo'ladi. Agar siz foydalanayotgan bo'lsangiz data-sort-type = "..." xususiyati, sarlavha katakchasiga saralash belgisi bilan qo'shilishi kerak.

Saralash tugmachalari markazlashtirilishi mumkin style = "background-position: center;" | har bir hujayrada. Taqqoslash uchun, bu faqat quyida joylashgan oxirgi katak uchun amalga oshiriladi. Mana jadval, keyin sarlavha katakchalari uchun vikitekst.

ismma'lumotlar ustunlariboshqa ustun
ma'lumotlarko'proq ma'lumotlar

mushuklar273531
itlar658,4922
sichqonlar1,6495483
{| class = "wikitable sortable" | -! satr oralig'i = 2 | ism! colspan = 2 | ma'lumotlar ustunlari! satr uzunligi = 2 | yana bir ustun | -! ma'lumotlar! ko'proq ma'lumotlar | -! 

!! !! !! style = "background-position: center;" | | -

Ikkilamchi kalitAgar ustun qiymatni bir necha marta o'z ichiga oladigan bo'lsa, ustunni saralash har bir kichik to'plam ichidagi satrlarning tartibini shu ustunda bir xil qiymatga ega bo'lgan holda saqlaydi (barqaror saralash

). Shunday qilib, birlamchi, ikkilamchi, uchinchi va hokazo kalitlarga asoslanib saralash birinchi navbatda eng kam ahamiyatli tugmachani saralash orqali amalga oshirilishi mumkin va hokazo. Masalan, quyidagi jadvalni Matn ustunida, so'ngra Raqamlar ustunida saralash uchun avval tugmachani bosing. "Raqamlar" ustun sarlavhasi (ikkilamchi saralash klavishi), so'ngra "Matn" ustun sarlavhasi (asosiy saralash klavishi).

Bir nechta saralash tugmachalari yordamida jadvalni saralashning yana bir usuli bu keyingi tugmachalar uchun ustun sarlavhalarini bosish paytida shift tugmachasini bosib ushlab turishdir. Masalan, quyidagi jadvalni Matn ustunida, so'ngra Raqamlar ustunida saralash uchun avval "Matn" ustun sarlavhasini (asosiy saralash klavishi) bosing, so'ngra shift tugmachasini bosib ushlab turing va "Raqamlar" ustun sarlavhasini bosing ( ikkilamchi saralash kaliti).RaqamlarMatnSanalarValyuta
4Qo'shimcha matna4.2001. Yanvar 2005
5qator 105/12/20067.15a
1qator 202-03-20045.00b
1qator 303-02-20045.00a
2qator 4x13-aprel-2005 yil
2qator 5a13-aprel-2005 yil
3qator 6a6.5017. 2006 yil
3qator 7z2.3025. 2006 yil
3qator 8z5.5028. 2006 yil
39-qatorz3.7731. 2006 yil
3qator 10z1.5001. 2006 yil
25qator 11z1.5001. 2006 yil
qator 12

Pastki

Saralash jadvallarini yaratish

VisualEditor-dagi jadvalning xususiyatlar paneli jadvalni saralash mumkin deb belgilashga imkon beradi.Jadvallar amalga oshirilishi mumkintartiblangan orqalimijoz tomonidagi JavaScript qo'shibclass = "wikitable sortable" ularning yuqori qatoriga. Ushbu jadvallar kerakli miqdorda katakchalar bilan to'g'ri formatlanishi kerak. Bundan tashqari, ustuningiz sarlavhalari to'g'ri ko'rsatilganligiga ishonch hosil qilishingiz kerakVikikod !. Buning uchun

belgi jadval sintaksisida ishlatiladi. Agar siz foydalanayotgan bo'lsangizVizual muharrir

, jadvalning xususiyatlar dialogini ochishingiz va saralash imkoniyatini tanlashingiz mumkin.

Oddiy misol Bu jadvalning vikisursidirko'rsatilgan

 birinchi bo'limda va jadvallarni saralashni yoqishning odatiy usuli ko'rsatilgan:

{| class = "wikitable sortable" | -! ism! ma'lumotlar! ko'proq ma'lumotlar | - | mushuklar | 273 | 53 | - | itlar | 65 | 8,492 | - | sichqonlar | 1,649 | 548 |} !The sarlavha hujayralari bo'lgan hujayralarni bildiradi. Jadval saralanishi uchun jadvalning birinchi satrlari to'liq shu sarlavha kataklaridan tuzilishi kerak. Siz jadval jadvalining asosiy sintaksisini bilib olishingiz mumkin.

Jadvallarga kirish

Qatorlarning dastlabki tartib tartibi Dastlab foydalanuvchilarga jadval taqdim etilganda, satrlar har doim vikitekstdagi kabi tartibda ko'rinadi. Agar jadval ma'lum bir ustun bo'yicha tartiblangan ko'rinishini istasangiz, vikitekstning o'zini shu tartibda saralashingiz kerak. Bu odatda birinchi ustun uchun amalga oshiriladi. TheVisualEditor jadvalning alohida ustunlari va qatorlari bo'ylab harakatlanishni osonlashtiradi. Bu haqda, shuningdek jadvalni boshlang'ich alifbo tartibida qo'yish haqida ma'lumot olish uchun qarang.

§ Dastlabki alifbo tartibida

Cheklovlar va istisnolar

Jadvallar faqat vertikal ravishda pastga qarab saralash uchun tugmachani bosishi mumkin (eng ustun ustun nomini bosish jadval satrlarini yuqoriga va pastga qarab o'zlarini qayta tartiblashlariga olib keladi). Sichqoncha bo'ylab gorizontal ravishda saralash mumkin emas (jadvalning ustunlari o'zlarining chapdan o'ngga pozitsiyalarida o'zlarini qayta tartiblashlariga olib kelishi uchun eng chap satrdagi katakchani bosish imkoniyati yo'q).

Tanlangan ustunlarni yaroqsiz holga keltirish Agar ma'lum bir ustun tartiblanmasligini xohlasangiz, belgilangclass = nomaqbul

uning sarlavhasi xujayrasining atributlarida.

Wiki belgisi{| class = "wikitable sortable"! Raqamlar !! Alfavit !! Sanalar !! Valyuta !!class = sortortable |

Saralash mumkin bo'lmagan | - | 1 || Z || 02-02-2004 || 5.00 || Bu | - | 2 || y || 13-aprel-2005 |||| Ustun | - | 3 || X || 17 .aug.2006 || 6.50 || Is | - | 4 || w || 01.Jan.2005 || 4.20 || Tartibsiz | - | 5 || V || 05/12/2006 || 7.15 || Qarang ? | -! Jami: 15 !!!!!! Jami: 22.85 !! |}

Sizning brauzeringizda qanday ko'rinishga egaRaqamlarAlifboSanalarValyuta
1Saralash mumkin emas02-02-20045.00Z
2Buy13-aprel-2005 yil
3UstunX6.5017. 2006 yil
4Shundayw4.2001. Yanvar 2005
5Saralash mumkin emas05/12/20067.15V
Qarang?Jami: 15

Jami: 22.85

Yakuniy qatorlarni saralashdan tashqari

Ba'zan jadvalning oxirgi qatorini saralash jarayonidan chiqarib tashlash foydali bo'ladi. Bunga erishish uchun ikkita usul mavjud.

Altbilgi sifatida sarlavha

Siz pastki qismida sarlavhani takrorlashni xohlaysiz. Siz buni yordamida amalga oshirasiz! (Undov belgisi) jadvalning oxirgi qatoridagi barcha kataklar uchun sintaksis. Bu altbilgi sifatida tan olinadi va qator saralashning bir qismi bo'lmaydi.

Wiki belgisi

{| class = "wikitable sortable"! Ism !! Familiya !! Balandlik | - | Jon || Smit || 1.85 | - | Ron || Rey || 1.89 | - | Mario || Byanki || 1.72 | -! Ism !! Familiya !! Balandlik |}

Sizning brauzeringizda qanday ko'rinishga egaIsmFamiliya
BalandligiJon1.85
SmitRon1.89
ReyMario1.72
ByankiIsmFamiliya

Balandligi

Bu jadval oxiridagi ketma-ket va sarlavha kataklaridan to'liq hosil bo'lgan barcha qatorlarga tegishli.

Oddiy altbilgi Bunga erishish orqali erishish mumkinclass = "sortbottom" |-).

kerakli jadval qatorida (boshlanadigan satr

Wiki belgisi

{| class = "wikitable sortable"! Ism !! Familiya !! Balandlik | - | Jon || Smit || 1.85 | - | Ron || Rey || 1.89 | - | Mario || Byanki || 1.72 | - sinf = "sortbottom" | colspan = "2" | O'rtacha: || 1.82 |}

Sizning brauzeringizda qanday ko'rinishga egaIsmFamiliya
BalandligiJon1.85
SmitRon1.89
ReyMario1.72
Byanki1.82

O'rtacha: Agar chiziqlar ketma-ket bo'lsa, pastki qismida bir nechta chiziqlarni ushlab turish mumkin. Agar jadvalning asl tartibi bir xil o'qga uchinchi marta bosish bilan tiklansa, u holda qatorlar qatoriga o'tingclass = "sortbottom"

ular dastlab pastki qismida bo'lmagan taqdirda ham pastki qismida qoladi.

Saralashdan yuqori qatorlarni chiqarib tashlash Bu yuqoridagi tekis (sarlavhasiz) qatorlar uchun yuqoridagi kabi ishlaydi. Bunga erishish orqali erishish mumkinclass = "sorttop" |- kerakli jadval qatorida (boshlanadigan satr

). Agar chiziqlar ketma-ket bo'lsa, yuqori qismida bir nechta chiziqlarni ushlab turish mumkin.

Saralashni sozlash

Odatiy bo'lib, tizim har bir ustundagi ma'lumotlar turini taxmin qilishga harakat qiladi. Buni dastlabki beshta qatorga qarab va ularning tarkibini baholash orqali amalga oshiradi. Ushbu jarayon ko'pincha ishlaydi, ammo agar siz mos kelmaydigan qiymatlar yoki tizim bilmagan qo'shimcha ko'rsatkichlar bo'lsa, ularni osonlikcha chalkashtirib yuborish mumkin. Ushbu noaniqlikni oldini olish uchun siz ma'lum bir ma'lumot turini majburlashingiz yoki katakning qiymatini bekor qilishingiz mumkin.

meta: Yordam: Saralash # Ustun uchun tartiblash tartibini majburlash Thedata-sort-type = "..."

atributini ustun sarlavhasi ichiga qo'shib, ostidagi kataklarning hammasi ma'lum bir ma'lumot turi sifatida ko'rib chiqilishini ta'minlashi mumkin. Saralash katakchasi bilan sarlavha katakchasiga kirishi kerak. Saralash katakchasida saralash belgisiz ishlamaydi. Masalan; ikki qator sarlavha bo'lganda, pastki satrda har doim saralash piktogrammasi bo'ladi. Quyidagi (harfga sezgir bo'lmagan) qiymatlar uchun amal qiladi:

  • ma'lumotlar saralash turi
  • matn
  • raqam
  • valyutaurl
  • veb-sayt manzillari uchunIP-manzil raqamli uchun
  • Internet protokoli manzillarisana
  • tilga xos standart sana formati uchunisoDate sanalar uchunISO 8601
  • format (masalan, YYYY-MM-DD)usLongDate
  • AQSh formatidagi sanalar uchun (bir oy oldin)

vaqt

Masalan:Vikiteks Hechqisi yo'qma'lumotlar saralash turi Bilan
data-sort-type = matn
{| class = "wikitable sortable" | -! ma'lumotlar-sort-type = matn | Albom | - ... va boshqalar ... |}
21
193
215
21
19
21
Albom
21
19
Matine
Hammasi yangi
Sevgi va urush
21
193
215
21
19
21
Albom
21
19
Matine
Hammasi yangi

Sevgi va urush Yo'qdata-sort-type = matn

sarlavhada, jadvalator butun ustunni raqamli deb hisoblash uchun birinchi qatorlardagi raqamlar bilan chalkashib ketadi. Natijada raqamli bo'lmagan sarlavhalar matnlarining alifbo tartibidan qat'iy nazar nolga teng ravishda noto'g'ri tartiblashtiriladi. E'tibor bering, agar e'lon qilingan sort turiga ega bo'lmagan ustun faqat sonli qiymatlarni o'z ichiga olsa, <ref>...</ref>lekin ma'lumotnoma bilan 1 12 2 27 289 3[17] 4 5 ... kamida bitta raqamning oxirgi raqamidan so'ng, bu ustun sukut bo'yicha matn (alfasayısal) sifatida tartiblanishiga olib kelishi mumkin, Saralash turini e'lon qilish orqali bunga yo'l qo'ymaslik mumkin:! data-sort-type = "number" | Elev. (ft) o'rniga.

! Elev. (ft)

Standart ma'lumot turi ustun Agar siz ko'rsatmasangiz ama'lumotlar saralash turi , tartiblash tartiblari (thema'lumotlar turlari

, "ko'tarilish" yoki "tushish" tanlovidan tashqari, saralash tartibini belgilaydi) quyidagilar:
  • sana (shuningdek quyida ko'ring)
  • mezon: birinchi bo'sh bo'lmagan element "DD-MM-YYYY", "DD-MM-YY" yoki "DD mmm YYYY" ko'rinishida
tartib: YYYYMMDD raqamli qiymati; 10-uzunlikdagi DDsMMsYYYY (agar s-da joylashgan belgilar bir-biriga teng bo'lsa va '/' yoki '-' ajratuvchi bo'lsa) YYYYMMDD, 8-uzunlikdagi DDsMMsYY (agar s-da joylashgan belgilar bir-biriga teng bo'lsa va '/' yoki '-' separator) 19YYMMDD bo'lsa YY> = 50 va aks holda 20YYMMDD, va "DD mmm YYYY" qatori mmm an (qisqartirilgan) oy nomi bilan.
  • isoDate (ISO 8601)
  • mezon: "± YYYY-MM-DD" formati, "YYYY" yili uchun 1-4 ta raqam bilan -9999 dan 9999 gacha, oy faqat "± YYYY-MM-DD" formati bilan, soat: mm: ss.sss ± TH: TM "soat soati" hh ", daqiqalar" mm ", soniyalar" ss.sss "va vaqt zonasi ofset" TH: TM bilan, to'g'ri qiymatlar ixtiyoriy.
tartib: raqamli, vaqt UTC bilan 1970 yil 1 yanvardan keyin millisekundlarda.
  • valyuta (ushbu rejim boshqa ma'lumotlar uchun ham foydali bo'lishi mumkin)
  • mezon: birinchi bo'sh bo'lmagan element $, £, € yoki ¥ bilan boshlanadi
tartib: raqamli, bu belgilarga va barcha oddiy harflar va vergullarga e'tibor bermaslik, lekin bo'shliqlarni hisobga olmaganda; ilmiy yozuvlardan foydalanish mumkin emasligiga e'tibor bering, chunki e va E o'chiriladi
), element -∞ kabi joylashtirilgan.
Taklif etilayotgan xalqarolashtirish: Nemis tilida va boshqalarda vergulni o'nli nuqta sifatida ko'rib chiqing.

va oddiy bo'sh joylar)

Agar bir nechta mumkin bo'lgan turlar mos keladigan bo'lsa, yuqoridagi tartibda birinchi tur tanlanadi. Masalan, "24-12-2007" sana sifatida mos keladi, shuning uchun raqam sifatida ko'rib chiqilmaydi. Moslashtirish turini aniqlashda formatlash va belgilash teglari e'tiborga olinmaydi. Saralash tartibi sahifani yuklagandan so'ng sarlavha ostidagi birinchi 5 bo'sh qator bilan belgilanadi. Bu qatorni o'chirgandan yoki ustun qo'shgandan keyin ham o'zgarishi mumkin. Shuning uchun har bir element kerakli ma'lumotlar turi mezoniga mos kelishiga ishonch hosil qilish maqsadga muvofiqdir. A dan foydalanishqator shablon

bu juda qulay tarzda amalga oshirilishi mumkin. Har bir ustunning saralash rejimi kerakli darajada ekanligiga ishonch hosil qilish usuli a ni belgilaydima'lumotlar saralash turi , qarang.

yuqoriga

Hujayra uchun saralash tugmachasini ko'rsatish {{Ba'zan katakning qiymati to'g'ri tahlil qilinmaydi yoki qatorni maxsus usulda saralashni xohlaydi. (masalan, "Jon Dou" ni o'z ichiga olgan katak "Jon" deb emas, "Doe" deb saralanishi kerak). Bunga osongina foydalanish orqali erishish mumkin}}tartib nomi {{, shunga o'xshash:tartib nomi| birinchi | oxirgi | ixtiyoriy havola maqsadi | ixtiyoriy tartiblash kaliti}} . Shu bilan bir qatorda, siz o'rnatishingiz mumkinma'lumotlar saralash qiymati

xususiyat.

Wiki belgisi{| class = "wikitable sortable"! Ism va familiya !! Balandlik | - |data-sort-value = "Smit, Jon"| Jon Smit || 1.85 | - |data-sort-value = "Rey, Ian"| Yan Ray || 1.89 | - |data-sort-value = "Byanki, Zaxari"

| Zakari Byanki || 1.72 | -! O'rtacha: || 1.82 |}

Bu quyidagilarni beradi:Ism va familiya
Balandligi1.85
Jon Smit1.89
Yan Rey1.72
Zakari Byanki1.82

O'rtacha:

Harbiy unvonlarni martabali yoshi bo'yicha tartiblash juda qulaydir.

Wiki belgisi{| class = "wikitable sortable"! Ism va familiya !! Rank | - |data-sort-value = "Smit, Jon"| Jon Smit ||data-sort-value = "16"| [[Kapital | Cpl]] | - |data-sort-value = "Rey, Ian"| Yan Rey ||data-sort-value = "8"| [[Kapitan (OF-2) | Kapitan]] | - |data-sort-value = "Byanki, Zaxari"| Zakari Byanki ||data-sort-value = "10"

| [[2-leytenant | 2 Lt]] |}

Bu quyidagilarni beradi:Ism va familiya
RankJon Smit
CplYan Rey
KapitanZakari Byanki

2 Lt Shuningdek qarang.

mw: Yordam: Saralash # Saralash kalitini ko'rsatishAgar sizda barcha yozuvlar tirnoq (") bilan boshlanadigan ro'yxat bo'lsa, va yozuvlardan biri uchun saralash tugmachasini o'rnatmoqchisiz, keyin foydalanishingiz kerak bo'ladiHTML nomi yoki raqami saralash tugmachasi boshidagi tirnoq uchun. QarangBu yerga

ham. Masalan, ba'zida qo'shiq sarlavhalarining ro'yxatlari har bir qo'shiqning sarlavhasini tirnoqlarda keltiradi. Shunday qilib, qo'shiq sarlavhasidagi ma'lum bir so'zga ko'ra saralash uchun quyidagilardan birini foydalaning:

data-sort-value = "& quot; WORD"

data-sort-value = "& # 34; WORD"

Bir qator qatorlarni saqlashma'lumotlar saralash qiymati

 ma'lum qatorlarni birgalikda saqlash uchun ishlatilishi mumkin. Ushbu qatorlarning belgilangan tartibi saqlanib qoladi. Masalan, "Niderlandiya" dan keyin "South Holland" ni qanday tartibda yoki ustunda bo'lishidan qat'iy nazar ushlab turish:
{| class = "wikitable sortable"! Mamlakat / viloyat !! Poytaxt | - | Frantsiya || Parij | - | Niderlandiya || Amsterdam | - | data-sort-value = Netherlands | South Holland || data-sort-value = Amsterdam | Gaaga | - | Buyuk Britaniya || London |}Mamlakat / viloyat
PoytaxtFrantsiya
ParijGollandiya
AmsterdamJanubiy Gollandiya
GaagaPolsha
VarshavaBuyuk Britaniya

London Agar sizda kolspanlar bo'lgan qatorlar bo'lsa, bu biroz qiyinlashishi mumkin. Siz ham foydalanishingiz mumkinclass = "kengaytirish-bola"

 bir qatorda; u har doim jadval satrida saralanishi mumkin bo'lgan har doim jadval manbaidagi satrdan pastda bo'ladi.
{| class = "wikitable sortable"! style = "width: 9.3em" | Country !! Capital | - | '' 'France' '' | Parij | - class = "spread-child" | colspan = "2" | Parijda Eyfel minorasi joylashgan. | - | '' 'UK' '' | London | - class = "spread-child" | colspan = "2" | Buyuk Britaniyada siz evro bilan to'lay olmaysiz, | - class = "spread-child" | colspan = "2" | va siz chap tomonda harakatlanasiz. | - | '' 'Germaniya' '' | Berlin | - class = "spread-child" | colspan = "2" | Germaniya tarkibiga sobiq DDR kiradi. |}Mamlakat
PoytaxtFrantsiya
Parij
Parijda Eyfel minorasi joylashgan.Buyuk Britaniya
London
Buyuk Britaniyada siz evro bilan to'lay olmaysiz,
va siz chap tomonda harakatlanasiz.Germaniya
Berlin

Germaniya sobiq DDRni o'z ichiga oladi.

Ma'lumot turini avtomatik aniqlashga misollar. Dastlab ustundagi 5 katak Ssenariyda ustunning dastlabki 5 katakchasi nimani o'z ichiga olganligi ko'rinadi. Saralash rejimi bo'ladiraqamli agar birinchi 5 katakka ega bo'lsafaqat raqam (raqamlarni formatlashda ishlatiladigan vergul va nuqta raqam sifatida qabul qilinadi). Raqamli tartiblash tartibi 5-katakchadan keyingi kataklarda matn topilgan taqdirda ham saqlanib qoladi. 123,564,589.7e12 ichidailmiy yozuv

va raqam sifatida ko'rib chiqiladi. Bo'sh katak raqamli tartiblashda raqamsiz sifatida ko'rib chiqiladi. Dastlab quyida joylashgan 2 ta jadvalning har birining pastki qismida dastlab bo'sh katak mavjud.Ma'lumotlar turini avtomatik aniqlash mos kelmaydi. Buhar doim qo'shish yaxshiroq ama'lumotlar saralash turi uchun

ustun sarlavhasi.
Saralash tartibi
avtomatik aniqlandi
matn sifatida
9
70
80 123,564,589.7e12
-80
taxminan
abc 80
600
300,000,000
3,000,000
aaa
Saralash tartibi
avtomatik aniqlandi
raqam sifatida
9
70
-80
600
80 123,564,589.7e12
taxminan
abc 80
300,000,000
3,000,000

aaa Yagona valyuta belgisi yoki bitta alfavit belgisi hozirda ustunning dastlabki 5 katakchasi orqali skript belgilaydigan narsani o'zgartirmaydi:

Raqamli tartib.
$ 9
$ 80
$ 70
$ 600
valyutalar
€ 9
€ 80
€ 70
€ 600
valyutalar
£ 9
£ 80
£ 70
£ 600
valyutalar
¥ 9
¥ 80
¥ 70
¥ 600
valyutalar
a
a 9
80
70
600
e
e 9
e 80
e 70

e 600 Foiz belgisi belgilanishdan o'zgarmaydiraqamli tartib.

Ularning ichida minus yoki bo'linish belgilari bo'lgan raqam birikmalari hali ham raqam sifatida aniqlanadi. Ularning raqamli tartiblanishi minus yoki bo'linish belgisidan oldingi raqam bilan belgilanadi.
7%
2
4
22
111
Foiz
7-4
2
4
22/7
111

Raqamli birikmalar Aplyus belgisi ichidabo'sh hujayra dastlabki 5 katak orasida standart raqamlash tartibini buzadi. A kabiraqamdan keyin ortiqcha belgi

agar u ustundagi dastlabki 5 katakchalardan birida bo'lsa.
Saralash tartibi
avtomatik aniqlandi
400
40,000
+
60,000
20,000
6,000
5,000
matn sifatida
Saralash tartibi
avtomatik aniqlandi
400
40,000
300+
60,000
20,000
6,000
5,000

matn sifatida

Raqamli tartiblash muammolariEslatma:

Ustundagi dastlabki 5 katak orqali ma'lumotlar turini avtomatik aniqlash haqida yuqoridagi bo'limga qarang. Ushbu muammolarning aksariyati endi qo'yish orqali ustun tartiblash rejimini qo'lda belgilash orqali hal qilinishi mumkindata-sort-type = raqam ustun sarlavhasida. Yuqoridagi va quyida keltirilgan jadval jadvallariga qarang. Shuningdek qarangmeta: Yordam: Saralash # Saralash rejimlarini saralash

va ustunni tartiblash tartibini majburlash haqidagi bo'lim. Ishlamoqdata-sort-type = raqam ichida bo'lishi keraksarlavha katakchasi busaralash belgisini o'z ichiga oladi.

Ko'p qatorli sarlavhali jadvallarda saralash belgisi eng pastki sarlavha hujayralarida bo'ladi. <ref>...</ref>Adabiyotlar

har qanday katakchadagi raqamdan keyin (birinchi beshta katakchani ham qo'shganda) endi raqamli tartiblash buzilmaydi.

Agar ustun ustidagi birinchi 5 katakchalardan biridagi raqamdan oldin yoki keyin bo'lsa, matn standart raqamlash tartibini buzadi. Hatto foydalanishda hamdata-sort-type = raqam ustun sarlavhasida, har qanday katakdagi raqam oldidagi matn, bu katakning raqamli tartibini buzadi. Agar ustun yordamida tartiblash tartibi ko'rsatilgan bo'lsa, raqamdan keyingi matn muammo bo'lmaydi.

"data-sort-type = raqam" (v.taxminan , "taxminan" degan ma'noni anglatadi) ko'pincha raqamlar ustunlarida uchraydi. Raqamli tartiblash ishlashi uchun uni raqamdan keyin qo'yish kerak. Shu bilan bir qatorda, uni boshqa ustunga o'tkazish mumkin. Ning qo'shilishidata-sort-type = raqam

ustun sarlavhasiga ruxsat bermaydi. raqamning oldiga qo'yish. Ustunni raqamli tartiblash uchun etakchi nollar shart emas. Agar shunday ko'rinadigan bo'lsa, demak, ustun alifbo tartibida tartiblangan. Dastlabki 5 katakchadan raqamlardan boshqa narsani qidirib toping va ushbu katakchalarga binoan tuzating. Yaxshisi, qo'shingdata-sort-type = raqam

ustun sarlavhasiga. Keyinchalik boshqa tahrirlovchilar tomonidan tahrir qilish raqamli tartiblashni buzmaydi.

Ustundagi dastlabki 5 katakchalardan biridagi bo'sh katakchadagi har qanday chiziqcha, ustunni sukut bo'yicha tartiblashni buzadi.

Raqam oldidagi chiziq sonli tartiblashni buzmaydi. Chiziqlarga katakchalarning istalgan joyida ruxsat beriladidata-sort-type = raqam

ustun sarlavhasida ishlatiladi.{{Yo'q }} ustunning dastlabki beshta katakchasidagi shablon ma'lumotlar turini avtomatik aniqlashda ta'siriga mos kelmaydi. A ni har doim belgilash yaxshiroqdirma'lumotlar saralash turi

ustun sarlavhasida.

Raqamli diapazonlarEslatma: Ko'pgina muammolar qo'shilish yo'li bilan hal qilinadidata-sort-type = raqam

ustun sarlavhasiga. Bundan tashqari, keyinchalik tahrirlash natijasida yuzaga keladigan muammolarning oldini oladi.

Raqamdan keyingi chiziq endi ustunning standart tartibini buzmaydi. Shuning uchun (30-40) diapazon endi ishlaydi.

Raqamdan keyin plyus belgisi ustundagi dastlabki 5 katakchalardan birida bo'lsa, sukut bo'yicha tartiblashni buzadi.

Aks holda bo'sh katakchadagi ortiqcha belgisi ustunni sukut bo'yicha tartiblashni buzadi. Agar hujayra ustundagi birinchi 5 katakdan biri bo'lsa.

Agar pastki yoki yuqori diapazon bo'yicha saralashni xohlasangiz, diapazon uchun 2 ta ustunni ishlatishingiz mumkin. Agar siz yuqori diapazonni eng yaxshi tartibda bo'lishini istasangiz, barcha katakchalar raqamlar bilan to'ldirilishi kerak. Masalan; pastki va yuqori diapazonda bir xil raqamdan foydalanishingiz mumkin. Bundan tashqari, yuqori diapazondagi raqamdan keyin ortiqcha belgisini qo'shishingiz mumkin.Quyidagi jadvallarning birinchi to'plami to'g'ri tartiblanmagan, "400+" murakkablashtiruvchi omillarga ega bo'lmagan pastki diapazondan tashqari. Yozib oling "400 +" va ularning ustunlarida to'g'ri tartiblashtirmang. Ushbu jadvallarda yo'qdata-sort-type = raqam

ularning ustun sarlavhalarida.
Bitta ustun
Taxminiy
400 +
40,000+
200,000–400,000
400,000+
60,000–350,000
40,000
40,000–50,000
20,000–100,000
10,000–100,000
6,000–7,000
5,000–10,000
davomat
Bitta ustun
Taxminiy
400+
40,000+
200,000–400,000
400,000+
60,000–350,000
40,000
40,000–50,000
20,000–100,000
10,000–100,000
6,000–7,000
5,000–10,000
davomat
Ikki ustun
Taxminiy
davomat(pastki)
400400+
40,00040,000+
200,000400,000
400,000+
60,000350,000
40,000
40,00050,000
20,000100,000
10,000100,000
6,0007,000
5,00010,000

(yuqori)data-sort-type = raqam borsaralashni quyidagi jadvallarda o'rnatdi. 400+ Ning saralashiga e'tibor bering 400 +.

va
Bitta ustun
Taxminiy
400 +
40,000+
200,000–400,000
400,000+
60,000–350,000
40,000
40,000–50,000
20,000–100,000
10,000–100,000
6,000–7,000
5,000–10,000
davomat
Bitta ustun
Taxminiy
400+
40,000+
200,000–400,000
400,000+
60,000–350,000
40,000
40,000–50,000
20,000–100,000
10,000–100,000
6,000–7,000
5,000–10,000
davomat
Ikki ustun
Taxminiy
davomat(pastki)
400400+
40,00040,000+
200,000400,000
400,000+
60,000350,000
40,000
40,00050,000
20,000100,000
10,000100,000
6,0007,000
5,00010,000

(yuqori)

Sana tartibida muammolar

Oy nomlari "Ingliz tili" ning sukut bo'yicha sozlamalarini o'zgartirgan ro'yxatdan o'tgan foydalanuvchilar uchun oy nomlarini o'z ichiga olgan barcha tartiblash muvaffaqiyatsiz bo'lishi mumkinMaxsus: afzalliklar

. Bu inglizcha Vikipediyada nisbatan kam foydalanuvchilarga ta'sir qiladi va ularni e'tiborsiz qoldirish mumkin.

Faqat yil QarangDaromadlar tengligi bo'yicha mamlakatlar ro'yxati . Yilni saralash, agar hech qanday matn ustun ichidagi katakchada birinchi narsa bo'lmasa, ishlaydi. Yil birinchi bo'lishi kerak. Qo'shilmoqdadata-sort-type = sana

ustun sarlavhasiga buni o'zgartirmaydi. Matn yaxshikeyin kamerada bir yil. "FY" (moliyaviy yil

), masalan, yildan keyin ketishi kerak. Yildan keyingi ma'lumotnomalar yaxshi. "C" belgisini qo'ying. yildan keyin yoki "est" dan foydalaning. o'rniga yil keyin.

Bo'sh katakchadagi har qanday chiziqcha ustunni yil tartibini buzadi. Yildan keyingi chiziqlar yaxshi.Raqamli tartiblashdan farqli o'laroq {{Yo'q }} yil ustunidagi istalgan katakchadagi shablonemas

ushbu ustunning tanaffus yilini saralash.

Yilni saralash bilan bog'liq muammolar mavjud bo'lsa, katakchadagi birinchi narsa sifatida matn yoki chiziqcha (har qanday turdagi) bo'lgan ustundagi biron bir katakchani tekshiring. Ushbu matnni yoki chiziqchani olib tashlang va ustun to'g'ri saralanishi kerak.

Yil va oy Sana saralashishlamaydi faqat oydan bir yil oldin (kun yo'q) ustunlar uchun. Qo'shilmoqdadata-sort-type = sana yokidata-sort-type = isoDate ustun sarlavhasigayordam bermaydi. Ko'rish uchun har bir ustun sarlavhasini quyidagi jadvallarda bir necha marta bosing. Belgilangan ustunga e'tibor beringdata-sort-type = isoDate
ba'zi brauzerlarda to'g'ri tartiblanishi mumkin, ammo bu ishonchli emas. Yil va oy raqamli shaklda (YYYY-MM) bilan ishlaydidata-sort-type = isoDate

(pastroqda tegishli bo'limga qarang).
Yil va oy
1999 yil dekabr
1999 yil yanvar
2004 yil may
2004 yil avgust
Yil va oy
1999 yil dekabr
1999 yil yanvar
2004 yil may
2004 yil avgust
Yil va oy
data-sort-type = sana
1999 yil dekabr
1999 yil yanvar
2004 yil may
2004 yil avgust
Yil va oy
data-sort-type = sana
1999 yil dekabr
1999 yil yanvar
2004 yil may
2004 yil avgust
Yil va oy
data-sort-type = isoDate
1999 yil dekabr
1999 yil yanvar
2004 yil may

2004 yil avgust

Oy va yil Sana saralashishlamaydi ustunlar uchun faqat yil oldin oy (kun yo'q). Qo'shilmoqdadata-sort-type = sana ustun sarlavhasiga

yordam bermaydi.
Oy va yil
1999 yil dekabr
1999 yil yanvar
2004 yil may
2004 yil avgust
Oy va yil
1999 yil dekabr
1999 yil yanvar
2004 yil may
2004 yil avgust
Oy va yil
data-sort-type = sana
1999 yil dekabr
1999 yil yanvar
2004 yil may
2004 yil avgust
Oy va yil
data-sort-type = sana
1999 yil dekabr
1999 yil yanvar
2004 yil may

2004 yil avgust

Oy, kun va yil

Saralash quyidagi jadvallarning barchasida to'g'ri ishlaydi. 100 yil oldin (masalan, 99 yil) tanaffuslarni saralash. Agar bir kun uchun raqam yo'qolsa, tartiblash buzilgan.
Oy, kun, yil
1999 yil 5-dekabr
1999 yil 7-yanvar
2004 yil 14-may
2004 yil 4-avgust
Oy, kun, yil
1999 yil 5-dekabr
1999 yil 7-yanvar
2004 yil 14-may
2004 yil 4-avgust
Oy, kun, yil
data-sort-type = sana
1999 yil 5-dekabr
1999 yil 7-yanvar
2004 yil 14-may
2004 yil 4-avgust
Oy, kun, yil
data-sort-type = sana
1999 yil 5-dekabr
1999 yil 7-yanvar
2004 yil 14-may

2004 yil 4-avgust

Kun, oy va yil

Saralash quyidagi barcha holatlarda to'g'ri ishlaydi. 100 yil oldin (masalan, 99 yil) tanaffuslarni saralash. Agar bir kun uchun raqam yo'qolsa, tartiblash buzilgan.
Kun, oy, yil
1999 yil 5-dekabr
1999 yil 7-yanvar
2004 yil 14-may
2004 yil 4-avgust
Kun, oy, yil
1999 yil 5-dekabr
1999 yil 7-yanvar
2004 yil 14-may
2004 yil 4-avgust
Kun, oy, yil
data-sort-type = sana
1999 yil 5-dekabr
1999 yil 7-yanvar
2004 yil 14-may
2004 yil 4-avgust
Kun, oy, yil
data-sort-type = sana
1999 yil 5-dekabr
1999 yil 7-yanvar
2004 yil 14-may

2004 yil 4-avgust

100 yildan oldin. Har qanday sana formatiEslatma:

Ushbu qismdan keyin tegishli bo'limga qarang. Saralash maxfiy orqali amalga oshirilishi mumkinma'lumotlar saralash qiymati yordamidaISO sanasi . Bilan birga

data-sort-type = isoDateEslatma: Saralash vikitekti quyidagi 2 jadval uchun bir xil.

Har qanday sana formati o'quvchilarga namoyish etilishi mumkin.
Sana
5 dekabr 111
7 yanvar 35
5 dekabr 207
Miloddan avvalgi 111 yil
Miloddan avvalgi 35-yanvar, 7-yanvar
Miloddan avvalgi 207 yil dekabr

{|| - style = vertical-align: top; | {| class = "wikitable sortable" | -! data-sort-type = isoDate | Sana | - | data-sort-value = "111-12-05" | 5 dekabr 111 | - | data-sort-value = "35-01-07" | 7 yanvar 35 | - | data-sort-value = "207-12-05" | 5 dekabr 207 | - | data-sort-value = "- 111" | Miloddan avvalgi 111 yil | - | data-sort-value = "- 35-01-07" | Miloddan avvalgi 7-yanvar, 35-yanvar | - | data-sort-value = "- 207-12" | Miloddan avvalgi 207 yil dekabr |} Quyidagi jadval uchun xuddi shu isoDate qiymatlari ishlatiladima'lumotlar saralash qiymati

yuqoridagi jadval sifatida. Ammo o'quvchiga sanalarni ko'rsatish uchun bir nechta formatlardan foydalaniladi.
Sana
5 dekabr 111
7 yanvar 35
207 yil 5-dekabr
miloddan avvalgi 111 yil
Miloddan avvalgi 35-yil 7-yanvar
Miloddan avvalgi 207 yil dekabr

{| class = "wikitable sortable" | -! data-sort-type = isoDate | Sana | - | data-sort-value = "111-12-05" | 5 dekabr 111 | - | data-sort-value = "35-01-07" | 7 yanvar 35 | - | data-sort-value = "207-12-05" | 207 yil 5-dekabr | - | data-sort-value = "- 111" | taxminan miloddan avvalgi 111 yil | - | data-sort-value = "- 35-01-07" | Miloddan avvalgi 35-yil 7-yanvar | - | data-sort-value = "- 207-12" | Miloddan avvalgi 207 yil dekabr |}

Yil, oy, kun. Raqamlardan foydalanish. ISO sanasi YYYY-MM-DD Misollar uchun; jadvallarni ko'ringAndroid One

. Kunduzi YYYY-MM dan foydalanadi. Qarang:.ISO sanasi "± YYYY-MM-DD", -9999 dan 9999 gacha "YYYY" yili uchun 1 dan 4 gacha raqam. Yilning o'zi yaxshi. Agar oy ishlatilsa, unda ikkita raqam ishlatilishi kerak. Agar oy oldingi nolsiz bitta raqamdan foydalansa, saralash buziladi. Bitta raqam kun uchun yaxshi. Sanadan oldin va keyin ba'zi narsalarga ruxsat beriladi. Kabi "v. " (uchuntaxminan |-) sanadan oldin, va sanadan keyin ma'lumotnomalar. Yil oldin vikitekstda salbiy raqam bo'lgan bo'sh joy qoldirishni unutmang. Aks holda,

jadvalni formatlash sifatida ishlatiladi. Saralash eng yaxshi ishlaydidata-sort-type = isoDate

ustun sarlavhasiga qo'shildi. Miloddan avvalgi yoki miloddan avvalgi davrni ham qo'shish mumkin. Sanadan oldin va keyin boshqa qo'shimchalarni sinab ko'ring. Bir necha oylar davomida bitta raqamlar ba'zi jadvallarda muammo bo'lib qolishi mumkin.
Sana
(yil-oy-kun)
Noto'g'ri. M ga qarshi MM.
-90
Saralash buzilgan
90-1-13
90-12-5
1011-08-01[2]
v. 90[1]
v. 207-11
Sana
(yil-oy-kun)
isoDate to'g'ri.
-90
Saralash ishlari
90-01-13
90-12-5
1011-08-1[2]
v. 90[1]
v. 207-11
Sana
(yil-oy-kun)
isoDate to'g'ri,
ammo miloddan avvalgi tartiblash to'xtaydi
Miloddan avvalgi -90 yil
90-01-13
90-12-5
1011-08-1[2]
v. 90[1]
v. 207-11
Sana
(yil-oy-kun)
bilan yaxshiroq ishlaydi
data-sort-type = isoDate
Saralash BCE bilan ishlaydi
Miloddan avvalgi -90 yil
90-01-13
90-12-5
1011-08-1[2]
v. 90[1]

v. 207-11

Sana jadvalini saralash shabloni: kun va oy, boshqa ko'plab sana formatlari {{Ushbu misol jadvallarida}}Sana jadvalini saralash

shablon. Ularning barchasi to'g'ri tartiblangan. Vikipediya matniga qarang ("manbani tahrirlash"). Har bir jadvalda birinchi kirish uchun vikitekst jadval sarlavhasida ko'rsatilgan.Eslatma: Jadval ustunlaridan hech biridata-sort-type = modifikator. Foydalanishdata-sort-type =

ba'zida saralashni buzishi mumkin.{{Sana jadvalini saralash }} shablonidan ko'plab sana formatlari bilan foydalanish mumkin. QarangAndoza: Sana jadvalini saralash

yana ko'plab variantlar uchun.
Sana
(Faqat kun va oyda)
{{Sana jadvalini saralash | 4-yanvar}}
4-yanvar
28 avgust
3-yanvar
29 avgust
14 dekabr
1 yanv
Sana
(Faqat oy va kun)
{{Sana jadvalini saralash | 4-yanvar}}
4-yanvar
28 avgust
3 yanvar
29 avgust
14 dekabr
1 yanvar
Sana
(Oy, kun, yil)
{{Sana jadvalini saralash | 1990 | 4 | 27}}
1990 yil 27 aprel
1989 yil 8-avgust
2006 yil 3-fevral
2006 yil 4 oktyabr
2004 yil 1-noyabr

2004 yil 11 yanvar

Saralangan sarlavhalardagi fon ranglari Umumiy bilan rang qo'shish"fon: ...;" sarlavhadagi xususiyat ushbu ustunni saralash tugmachasini yo'qotishiga olib kelishi mumkin - qarangphab: T33755

. Misol:IsmFamiliya
BalandligiJon1.85
SmitRon1.89
ReyMario1.72
Byanki1.82

O'rtacha: Keyinchalik aniqroq foydalaningstyle = "background-color: ...;"

 narsalarni to'g'ri ishlashi uchun. Misol:{| class = "wikitable sortable" | -! style = "background-color: navajowhite" | Ism! style = "background-color: navajowhite" | [[Familiya]]! style = "background-color: navajowhite" | [http://example.com Balandligi]

| - | Jon | Smit | 1.85 | - | Ron | Rey | 1.89 | - | Mario | Byanki | 1.72 | - class = "sortbottom" | colspan = "2" | O'rtacha: | 1.82 |}

Ushbu tartiblangan jadvalni ishlab chiqaradi:IsmFamiliya
BalandligiJon1.85
SmitRon1.89
ReyMario1.72
Byanki1.82

O'rtacha:

Maslahatlar va fokuslar

To'ldirish

Ba'zan hizalamak uchun yozuvlar chap tomonga to'ldiriladi. Bu ularning tartiblanishiga salbiy ta'sir ko'rsatishi mumkin.

Bo'sh joylar Chap to'ldirishning ta'siribo'sh joy kodlar& nbsp;

bo'sh bo'shliq sifatida ko'rsatiladigan brauzerga bog'liq: IE-da ular (bo'sh bo'shliqlardan farqli o'laroq) etakchi bo'sh joy sifatida saralash uchun hisoblanadi, shuning uchun matnli raqamlar ro'yxatida (alfavit tartiblash tartibi qo'llaniladi) ular ishlatilishi mumkin. aniq yoki yopiq o'nlik ajratuvchisidan oldin belgilar sonini tenglashtirish. Biroq, Firefox-da ularni saralash maqsadida e'tiborga olinmaydi. Saralash yordamida& nbsp; IE-da ishlaydi, ammo Firefox-da ishlamaydi
Ism100.3 FM
Uchinchidan 89.5 FM
Birinchidan107.3 FM
To'rtinchi 95.3 FM

Ikkinchi Shuningdek qarang.

Muhokama: Aholisi bo'yicha AQSh shtatlari va hududlarining ro'yxati / Arxiv 1 # Saralash jadval

Nol bilan to'ldirish

  • 000156

Misol:

Formatnum padleft bilan birlashtirilishi mumkin:

Butun son:

  • 0,000,000,299,792,458

{{formatnum: {{padleft: 299792458 | 16 | 0}}}} beradi:

Haqiqiy:

  • 0,000,000,299,792,458.056000

{{formatnum: {{padleft: {{# expr: ((299792458.056 - .5) 0-tur)}} | 16 | 0}}}}. {{padleft: {{# expr: (1000000 * (299792458.056 -) (299792458.056 - .5) 0-tur))) tur 0}} | 6 | 0}} beradi:

SanalarJadvalda tartiblanadigan sanalarni formatlashning eng oddiy usuli bu {{Sana jadvalini saralash }} shablon. Ga muvofiquslubiy qo'llanma

  • , shablon quyidagi format yordamida chaqiriladi:

{{Sana jadvalini saralash | 1776 yil 4-iyul}}Please see the documentation of the template {{Date table sorting

}} for full details on how to use this.

Muammolar
2006-12-032006-12-03
-0000-03-27-0000-03-27
2006-12 String sort mode
!9936-04 2006 yil dekabr
!9900-07-13-0099-07-13
!9937-09-23-0062-09-23
!9937-10-08-0062-10-08
!9998-12-21-0001-12-21
2006-11-082006-11-08
0304-12-310304-12-31
2005-05-152005-05-15

April 64 BC

  • Date sorting works by formatting dates so they can be sorted numerically. For example:

yyyy mm dd

  • 2001 07 21

yoki...for 21 July 2001. The "display:none" style can be used to hide a sortable numeric date before the displayed date. {{Date table sorting

}} does this automatically, and is recommended in most cases. You can use 2012 yil 7-iyul

etc. to get sortable dates. Example, including one date with a different display format:
Sana
2012 yil 7-yanvar
2012 yil 7-may
2012 yil 4-iyul

2012 yil 7-iyul !9937-09-23For years BC,

  • can be used for -0062-09-23 (62 BC): Simply subtract the year BC from 10,000. Shuningdek qarang:

bugzilla:8226

Numeric sort for BC/AD years

In certain circumstances the following sort technique may be used to provide a simple intuitive numeric sort for BC/AD years which are often surrounded by qualifying text. The sort in the BC/AD column (the fourth column in the example) is forced to be numeric (just as the other columns are forced to be alphabetic) by the inclusion of the first two hidden rows. These rows contain extreme values which will mean that these rows will ALWAYS be sorted to the top and bottom of the table, regardless of which column is sorted. As the sort mechanism determines the sort type to be used by examining the first cell in the column to be sorted the hidden rows ensure that a purely numeric value is always found in the first or last cell. The mechanisms used here are explained in the current article at: #Forcing proper sort type and positioning rows with a hidden sort key va.

#ExamplesWith numeric sorting guaranteed all that is needed is to precede the BC/AD text with a positive or negative year number in a hidden sort key ( {{Hs|-9999 ! }} ) which suitably represents the cell text. As this number will be the first thing the sort code sees it will sort it as a number, in the order large negatives -> zero -> large positives

, or the opposite. Once the sort type is fixed at the start of a sort the presence of alphabetic values in subsequent rows is ignored. The sort is done numerically on the first text in each row. The detail of the exclamation mark after the positive/negative year number in the hidden sort key is to clearly mark an end to the number which the sort mechanism must consider. In certain circumstance, if the exclamation mark is not present, and the hidden sort key is immediately followed by another number, that number may be treated as a continuation of the hidden sort key number, to produce an incorrect sort. The tables in the article: Doimiy yashash vaqti bo'yicha shaharlar ro'yxati

 have been modified to used this sort. The following example is modified (maintaining some defects in the content which will need resolving in the original!) from one of those tables:
{| class = "wikitable sortable" | -! Name! Historical region! Location! Continuously inhabited since! class = "nomaqbul" | Notes|-style="display:none;"|!a||!a||!a||-9e99|-style="display:none;"|~z||~z||~z||9e99|-| [[Ife]] || || {{Hs|Nig}}[[Osun State]], [[Nigeria]] || {{Hs|-500 !}}c. 500 BC |||-| [[Axum]] || [[Kingdom of Axum]] || [[Ethiopia]] || {{Hs|-400 !}}c. 400 BC || Ancient capital of the Kingdom of Axum...|-| [[Mogadishu]] || || [[Somalia]] || {{Hs|900 !}}c. 900 || settled by Arab traders|-| [[Dar es Salaam]] || || [[Tanzania]] || {{Hs|1865 !}}1865 || Founded by the Sultan of [[Zanzibar]].|}IsmTarixiy mintaqaManzilContinuously inhabited since
Izohlar!a!a!a
-9e99~ z~ z~ z
9e99Agar, Osun shtatiNigeriya
v. Miloddan avvalgi 500 yilAgar, Osun shtatiNigeriyav. 8-asr
earliest traces of habitation date to the 4th century BC.HaYo'qEfiopiyav. Miloddan avvalgi 700 yil Oldest site of continuous habitation in .
Afrikaning Sahroi osti qismiAxumAxum qirolligiEfiopiyav. Miloddan avvalgi 400 yil
Ancient capital of the Kingdom of AxumIgodomigodoBenin qirolligiNigeriyav. Miloddan avvalgi 400 yil
City of Benin, one of the oldest cities in NigeriaDjenné-JenoMaliv. Miloddan avvalgi 200 yil oldest known city in
Saxaradan AfrikagaMogadishuSomaliv. 900
settled by Arab tradersKeyptaunKeyp koloniyasi1652Janubiy Afrika
Founded by Jan van Riebeeck of the Dutch East India CompanyMonroviya1822Liberiya Settled by freed American slaves through the
Amerika mustamlakachilik jamiyatiDar es Salom1865Tanzaniya Founded by the Sultan of .

Zanzibar

Controlling sorting and display

  • Text undesired for sorting but needed for display: Yildaraqamli
  • sorting mode, text breaks numerical sorting whether the text is before or after the number. Sorting then becomes alphanumeric. Empty cell is treated as "zero" when sorting numerically. Yildasana
  • sorting mode, this text needs to be put in a separate column; in the case of a cell containing a range of dates or numbers (e.g. from .. to ..), text in surplus of what is required for sorting is put in the extra column. If the first part of the text is used for sorting, then the extra column needs to be the following one; conversely, if the last part of the text is used for sorting, then the extra column needs to be the previous one; depending on the table format, this dividing of an item over two cells may look ugly. Yildaalifbo

sorting, any footnotes etc. do not require a separate column; they can simply be put at the end of the element.

  • Text undesired for display but needed for sorting:

can be put as hidden text in the column to be sorted

Combining the two, we can have displayed text independent of text used for sorting, by fully hiding the latter, and fully putting the former in a separate column (in date sorting mode and numeric sorting mode) or in the same column after the hidden text (in alphabetic sorting). Fully putting the displayed text in a separate column may look ugly if it is not done consistently for a whole column, but only for elements that require this (e.g. if most entries in a column are single numbers, but some are ranges).

Static column

A static column, e.g. with row numbers, can be obtained with two side-by-side tables with for each row the same height set in both tables:
1
2
RaqamMamlakat
PoytaxtNederlandiya
Amsterdam (although The Hague is the seat of government)Frantsiya

Parij

The style can be adjusted to make it appear as a single table. If for some row the height of that row is too small for the text in a cell on one of the sides, the browser increases it, and there is no longer a match.A static column can also be created by enclosing the sortable table with the templates {{static column begin}} and {{oxiri}}. See the documentation of {{static column begin

}} tafsilotlar uchun.

Maintaining tables sorted by rank

Tables in rank order may become difficult to maintain as the list is updated. People keep adding more rows to the table, but fail to renumber all the ranks each time a new one is added. With Visual Editor it is much easier now. QarangYordam: Jadval

and the section at the end on the Visual Editor. It is easy to add or remove a column of rank numbers. See the section on copying a column from one table to another. Copy a rank column from another table, or an older version of the same table. Masalan; copy from.Bu yerga

It is a rank column from 1 to 250.

Click on the first cell (with number 1) of the rank column. Then shift-click on the highest number you need. Click "copy" from the edit menu of your browser. Then click on the first cell of the blank column that needs rank numbers. Click "paste" from the edit menu of your browser.

Putting a table in initial alphabetical orderEslatma: For more info see the Visual Editor sections at the end of Yordam: Jadval . Shuningdek qarang::Phab:T240114

"Enhance the VisualEditor table editor to allow sorting and saving sorted content." There are fast and slow ways to do this. Scroll down for fast ways. AfsuskiVizual muharrir

does not have a fast way to quickly alphabetize a table. You can manually move rows around one at a time. Click on a cell in a row. Then click on the arrow that shows up at the left of the row. Then click on "move above" or "move below" as needed.

If this is buggy or is not working, the rows can be moved around in the wikitext by cutting and pasting rows in the wikitext. A fast way is to launch free ,LibreOffice Calc or another spreadsheet program. QarangElektron jadval dasturlari ro'yxati

. Go to the Wikipedia page or user sandbox with the table. Select and copy the table right off the page (do not go into the wikitext or the HTML). Paste it into a new Calc page. In Calc click on any cell in the column you want sorted, and then click on one of the sort options in the data menu at the top of the Calc window. Click on "ascending" or "descending" to sort alphabetically or numerically depending on the column contents. Click on "sort" for more options. Then convert the Calc table back to wikitext by pasting it into .

tab2wiki Or copy directly from the spreadsheet, and then paste directly into a new Visual Editor table where the first header cell has been selected. It may take up to a minute. You can copy the whole table or selected columns. Qo'shimcha ma'lumot uchun qarang.


Commons:Convert tables and charts to wiki code or image files There is another way to alphabetize a table. Biri foydalanishi mumkinNoteTab Engil ||.

(freeware version of NoteTab). It installs quickly and easily. But the wikitext must be in compressed table format. All the wikitext for a row must be on one line. That means the cells in that row are separated by double bars

To alphabetize the list by the first column paste the table wikitext into a new NoteTab Light page. Select the rows you want to alphabetize. Then click on the "modify" menu, then "lines", then "sort", and then "ascending". That will put "A" at the top and "Z" at the bottom. |-Then put back (wikitext for row) between each line. Do that via find-and-replace by replacing ^ p bilan

^p|-^p^ p
|- is the underlying text editor code for line breaks in NoteTab.

is the wikitext for a table row. If there are blank lines between the entries replace ^p^p bilan

^p|-^p

Copy the wikitext and paste it back into the article. Save the page.

[[Help:Sorting#Initial alphabetical sort versus initial sort by rank order]]

It is a good idea to keep lists and tables in some kind of initial non-random sort order. Numbered rank order can be difficult to maintain as the list is updated, and as the rankings change. Masalan; in a nation list, updating the info for a single nation may require changing the rank numbers of many nations. This discourages people from updating the list. If they do update the list, they may not bother to update the rank order. So the list becomes more and more incorrect over time. See lists of country data. QarangCategory:Lists of countries by per capita values va.

Category:Lists of countries

It is much easier to keep a list in rank order if the numbered rank column (1,2,3) is removed from the table, and then put next to the table in a separate column. See how-to sections below. Just removing or separating the rank column (1,2,3) can greatly ease future updating of the table, whether the table is initially in rank order or alphabetical order.

It can be even easier maintenance and updating in some cases if the list is initially in alphabetical order, especially if the sources and references are also in alphabetical order. Readers can be instructed to use the sort button to order a number column.

Removing a rank column (1,2,3) from a table You can remove the rank column cells quickly. It is much easier now with the table editor in the VisualEditor

. Click on the header in the column you want to delete. An arrow will show up at the top of the column. Click the arrow, and then "delete column".

Kategoriya: qatordagi qatordagi raqamli jadvallar bilan maqolalar Lar borPhabricator threads asking for a way to easily add static row numbers to tables. Qarang.phab:T42618 U orqaga qaytadi.phab:T42634 If a solution is implemented in the MediaWiki software, then it will be much easier to use wide tables, and wide note columns, in tables with row numbers. An integrated static row number column would be very helpful in a wide table initially sorted by region and subregion such as this wider version ning:Qasddan odam o'ldirish darajasi bo'yicha mamlakatlar ro'yxati Versus this .

tor versiyasi

A row number column never has to be updated, except to add more numbers at the end if necessary. Masalan; when adding more nations. This allows any initial sort order for the table. It allows any column to be sorted later via the sort button, and still see the same row numbering.List of U.S. states by incarceration and correctional supervision rate

is an example of a table that needs a separate row number column. Because there are 3 separate columns that are important enough that people want to be able to see the rank order. That can't be done with an integrated rank order column. It can only be done with a static row number column.

New method is much easier

This is a much easier method for adding a fixed row number column to a table.

Andoza: Stol qatori hisoblagichi <!-- -->Go to those template pages to see the documentation on how to use those templates. Note that you will need to temporarily add nowiki tags, or hidden comment tags , to the {{daraja }} template line at the top of a table if you want to edit the table in the Visual Editor. Qarang Phabricator: .

T245277

Old method Adding a separate column of row numbers with this method requires some complicated wikitext, and does not work well with wide tables. Note the width of the tables here:

Kategoriya: qatordagi qatordagi raqamli jadvallar bilan maqolalarQamoqqa olish darajasi bo'yicha mamlakatlar ro'yxati may or may not need a separate row number column. It depends on whether one believes there is more than one column that people want to see in rank order for. Its editing using the old method is explained in detail at Commons:Convert tables and charts to wiki code or image files (section about list of countries by incarceration rate). Shuningdek qarang:.

Aholi jon boshiga sog'liqni saqlash xarajatlarining umumiy miqdori bo'yicha mamlakatlar ro'yxatiFlag icons are not currently a problem in country lists.

It depends on the current state of the MediaWiki software, and the current state of the flag templates. Sometimes they mess up row alignment more and more as the text size used is smaller and smaller. The row alignment is more and more messed up the farther down one scrolls down the table. At the time this is written the flag icons are formatted in such a way that they are not causing a problem.

Click column heads to sort alphabetically or numerically. O'sish yoki tushish tartibida saralashi mumkin. The row number column on the left sorts independently from the columns to the right of it. Or: "The row number column is static and does not sort." To make it static add class=unsortable

to the column head for the row numbers.A separate row number column only works when there is only one line per row in the table. So wide tables, or tables with a notes column are problematic. There could be 2 lines in some rows, depending on screen width, and the length of notes. Rows will wrap from being one line to two lines. Decrease your browser width to see. Masalan; see notes column here:Mintaqalar bo'yicha mamlakatlar va qaramliklar ro'yxati <br>. Wide tables can be narrowed in some cases by using breaks in the header titles:

. Also, the sorting icons can be put in a separate header row.Tables with references within the table are not currently a problem. Reference numbers are in ,yuqori belgi and this may or may not increase the line height of the row. It depends on the current state of the MediaWiki software, and whether it increases line height for rows with references. So a separate row number column may not work, especially when multiple cells in a column have references. The more rows with references, the more the misalignment as one goes down the table. One solution is to point to a notes section below the table. Qarang:Qasddan odam o'ldirish darajasi bo'yicha mamlakatlar ro'yxati

. The notes are in a notes section below the table.Italics within the table are not currently a problem.

It depends on the current state of the MediaWiki software, and whether it changes the line height for rows with italics. Note: Copy separate row number table (1,2,3) from Bu yerga . It is 1 to 250. Use as much as is needed. Shuningdek qarangushbu ro'yxat

of just the numbers.

Example tables. Old method

Here is how to put a main table adjacent to a separate row number table.ismma'lumotlar
more data27353
mushuklar658,492
itlar1,649548

1
2
3

sichqonlar <br>The two tables are combined by wrapping them within a 3rd table that does not have a border. Look at the wikitext to understand. See examples below. It is not necessary to put text in the header cell above the number column. You can leave it blank, but sortable. Qo'shish so it is not too narrow. You can also choose to leave the number column unsortable. Specify class=unsortable in the attributes of its header cell. For more info see the section higher up called .


1
2
3
Making a column unsortableismma'lumotlar
more data27353
mushuklar658,492
itlar1,649548

sichqonlarAlign the multiple headers <br> across the tables below by adding (multiple times if necessary) to the header cells of the row-number column. See the wikitext for the table below. Shuningdek qarang:List of U.S. states by incarceration and correctional supervision rate va.Qasddan qotillik darajasi bo'yicha mamlakatlar ro'yxati # Mamlakatlar bo'yicha

 Those tables have several header rows.



1
2
3
{| class = "wikitable sortable" | -! |-!
|-| 1

ism27353
ma'lumotlar658,492
Ko'proq1,649548

ma'lumotlarmushuklar itlarsichqonlar

You can remove the space between the 2 tables qo'shib



1
2
3
style="margin-right: -8px;" to the top line of the wikitext of the row number table. It may not be a good idea to do this though in many cases. Fixed row numbering is more intuitive when there is a space between tables. Otherwise people may not understand why the numbers are not sorting along with the rest of the table. {| class="wikitable sortable"
style="margin-right: -8px;"

ism27353
ma'lumotlar658,492
Ko'proq1,649548

ma'lumotlar mushuklaritlar

sichqonlar With wider tables the rows only line up between the table and the row-number column if all the rows below the headers only use one line each. So it is a good idea to avoid tables that are too wide. For that reason avoid note columns, too. See the problem in the table below. Increase your text size, or narrow your browser window to see the problem with wider tables such as the one below.





1
2
3
Another problem is that the row-number column can drop down out of sight when the tables are viewed on a narrow screen, or when the browser width is narrowed.Qo'shilmoqdastyle=vertical-align:top; will keep the tops aligned between the 2 tables at all browser widths. The row-number column will not drop down.
ism
mashhurlikdata columns
boshqaustun
yil

eslatmalarma'lumotlar2735312013Ko'proq
ma'lumotlarmushuklar658,49222014popular pet
To align headers add breaks to the header cells of the row-number column.itlar1,6495483popular pet

This does not align the tops of the 2 tables at narrow browser widths.

sichqonlar

less popular Adding CSS for vertical alignment will keep the tops aligned.

For the above table here is the wikitext at the top of the wrapping table, followed by the header wikitext for the row-number column: {||- style=vertical-align:top;|{| class = "wikitable sortable" | -! |-!

|-!

|-| 1 Adding row numbers with Template:Row numbers QarangTemplate:Row numbers for a very fast way to add a column of row numbers to a table. The row numbers are not fixed though as with the previous methods. This method is not affected by screen width as with the method used in the previous section. The row numbers stay aligned with the table rows. Qarang

this page with a column of 300 rows containing _row_count . The column can be copied with Visual Editor into any table. In order to quickly set up any table to useTemplate:Row numbers

. Qarang


this old version ningVoyaga etganga to'g'ri keladigan boylik bo'yicha mamlakatlar ro'yxati
1. It uses the template to add the row numbers.27353
2Qarang658,492
3Yordam: Jadval1,649548


and its section at the end on the Visual Editor. It explains how to copy a column from one page to a table on another page.

Remove the template code at the beginning of the table in order to edit the table in Visual Editor. Otherwise, use the wikitext editor. Leave a note on the talk page, and add a hidden note above the table. See wikitext and note of the table below. ismma'lumotlar

more data

mushuklar

itlar
9
12
11

sichqonlar

Sorting the wikitext of a table

One difficult way to sort the

vikitekst
12
11
9

itself by a certain column is to use the following 'trick'. You can make an auxiliary sortable table containing the wikitext for the original table, and sort it. You can then replace the original wikitext by this sorted wikitext.Unfortunately this method is anything but quick and easy. The heavy modifications needed make it unsuitable for larger tables, while small tables generally are sorted faster by hand.

Misol:Original table:demo
Auxiliary table:Andoza: Vikipediya qayd yozuvlari101010
{|class="wikitable sortable"!demo{|class="wikitable sortable"!header|-||-| 9|-||-|12|-||-|11|}|}Andoza: Botnav222
Now you can sort the above table, and copy the rendered text to the edit box. After deleting the "header" line, this renders as a new defaultly sorted table:Andoza: Vikipediyaga havola1-11
demoAndoza: iqtibos metama'lumotlari navbox0

Sorting with increase/decrease/steady templates Misol, Without keyWith key olmaBanan gilosDurian To enable sorting of cells with Template:Increase

Template:Decrease yoki
Template:Steady$1|$3$2$3
, add a sort key, e.g. {{increase|2}}2, {{decrease|-1}}1 or {{steady|0}}. To fix an existing table, use $1|-$3$2$3
Search and replace$1|0$2

(right icon in the Advanced toolbar) with

Treat search string as a regular expression selected to do the following replacements:

Qidirish

Replace with
!
"
#
$
%
&
'
(
)
*
+
,
-
.
/
0
9
:
;
<
=
>
?
@
[
\
]
^
_
'
({{increase)(}})([0-9]*)
({{decrease)(}})([0-9]*)
({{steady)(}})
Alphabetic sorting order
data-sort-type:text
- Sort the following table to see an example of the alphabetic sort order.
Note that sorting is case-insensitive: the two-character entries such as A1 demonstrate that A and a are at the same position.
Sinov
{
|
}
~
A
Z
a
z

A1

Z1a1

z1
É
é
1000000000000000000
-1000000000000000000
.0000000000000000001
-.0000000000000000001
É1
é1
Numerical sorting order examples
89 123 456 788
89,123,456,789
14
-14
11
data-sort-type:number
- Sort the following table to see an example of the numerical sort order.
12 (?)
mixed notations
Sinov
?
333
1.4285714285714E+17
-1.4285714285714E+17
1.4285714285714E-13
-1.4285714285714E-13
-12 (retrograde)
12 yoki 13
v. 12
12 (approx.)
1e10
e 9
e 80
e 70
e 600
999e9
88e80
7e270
999e-9
88e-80
7e-270
-999e9
−999e9
-88e80
-7e270
-999e-9
-88e-80
-7e-270

e3