Top.Mail.Ru
Ответы

Сортировка по числам

У меня есть несколько строк, как их отсортировать не по алфавиту а по числам в конце?(это цены)

stonebutton: 3.0
wood: 0.50
arrow: 3.50
diamondpickaxe: 610.0
rawfish: 5.0
minecart: 23.0
leatherchestplate: 80.0
storageminecart: 30.0
feather: 3.0
goldchestplate: 400.0
mushroomsoup: 4.5
bread: 5.0
stationarywater: 1.0
workbench: 2.5
stonehoe: 2.5
brownmushroom: 2.0
mossycobblestone: 90.0
diamondhoe: 410.0
woodsword: 1.0
torch: 4.0
grass: 1.0
poweredminecart: 32.0
snowball: 1.0
goldenapple: 500.0
leatherleggings: 70.0
diamondaxe: 610.0
slimeball: 50.0
fence: 1.0
stonespade: 1.5
claybrick: 5.0
noteblock: 36.0
ironaxe: 76.0
coalore: 5.0
clayball: 3.0
fishingrod: 10.0
ironhoe: 54.0
goldrecord: 100.0
ironpickaxe: 76.0
irondoor: 44.0
bucket: 22.0
redrose: 2.0
grilledpork: 7.0
gravel: 1.0
wooddoor: 3.0
chainmailhelmet: 40.0
ironchestplate: 198.0
diamondblock: 1800.0
diamondhelmet: 1000.0
goldhelmet: 250.0
redstonetorchon: 32.0
ironspade: 32.0
furnace: 8.5
ironsword: 54.0
dispenser: 58.0
woodaxe: 2.0
seeds: 2.0
painting: 25.0
woodplate: 1.0
redstoneore: 30.0
diamondspade: 210.0
waterbucket: 40.0
water: 1.0
bedrock: 100.0
irondoorblock: 15.0
goldhoe: 110.0
sand: 1.0
goldsword: 110.0
stoneaxe: 3.0
bookshelf: 140.0
ironblock: 198.0
jackolantern: 56.0
boat: 3.0
diamondchestplate: 1800.0
redstonewire: 30.0
redmushroom: 2.0
string: 5.0
stoneplate: 6.0
wallsign: 1.0
cactus: 10.0
sulphur: 20.0
rails: 22.0
ironore: 12.0
leatherhelmet: 50.0
stone: 3.00
egg: 1.0
diamondore: 210.0
woodhoe: 2.0
goldleggins: 350.0
chainmailleggings: 50.0
yellowflower: 2.0
ironhelmet: 110.0
obsidian: 130.0
dirt: 1.0
leather: 10.0
leatherboots: 40.0
lever: 1.0
cobblestone: 1.0
cake: 180.0
woodstairs: 1.0
ironingot: 22.0
goldore: 40.0
pumpkin: 50.0
bed: 30.0
watch: 6.0
ironleggings: 154.0
sign: 1.5
doublestep: 1.0
woodpickaxe: 2.0
stonepickaxe: 4.0
chainmailboots: 30.0
diamondleggings: 1400.0
cookedfish: 7.0
saddle: 100.0
cobblestonestairs: 1.5
tnt: 100.0
glowingredstoneore: 30.0
apple: 10.0
woodspade: 1.0
goldingot: 50.0
diode: 110.0
soil: 1.0
clay: 12.0
goldblock: 450.0
stick: 0.25
paper: 10.0
brick: 21.0
stationarylava: 1.0
chest: 4.0
sandstone: 3.0
goldpickaxe: 160.0
compass: 22.0
sugarcane: 10.0
diamondsword: 410.0
goldboots: 200.0
sponge: 80.0
stonesword: 2.5
coal: 5.0
coalblock: 135.0
goldaxe: 160.0
bone: 2.0
diamond: 200.0
glass: 3.00
goldspade: 60.0
lapisblock: 950.0
lavabucket: 40.0
wheat: 9.0
ladder: 0.5
sugarcaneblock: 15.0
bowl: 0.50
chainmailchestplate: 40.0
diamondboots: 800.0
lapisore: 100.0
lavabucket: 25.0
milkbucket: 40.0
redstone: 3.0
greenrecord: 100.0
inksack: 10.0
glowstonedust: 10.0
book: 45.0
bow: 15.0
ironboots: 88.0
step: 1.5
sugar: 10.0

По дате
По Рейтингу
Аватар пользователя
Искусственный Интеллект

stick: 0.25
wood: 0.50
ladder: 0.5
bowl: 0.50
stationarywater: 1.0
woodsword: 1.0
grass: 1.0
snowball: 1.0
fence: 1.0
gravel: 1.0
woodplate: 1.0
water: 1.0
sand: 1.0
wallsign: 1.0
egg: 1.0
dirt: 1.0
lever: 1.0
cobblestone: 1.0
woodstairs: 1.0
doublestep: 1.0
woodspade: 1.0
soil: 1.0
stationarylava: 1.0
stonespade: 1.5
sign: 1.5
cobblestonestairs: 1.5
step: 1.5
brownmushroom: 2.0
redrose: 2.0
woodaxe: 2.0
seeds: 2.0
redmushroom: 2.0
woodhoe: 2.0
yellowflower: 2.0
woodpickaxe: 2.0
bone: 2.0
workbench: 2.5
stonehoe: 2.5
stonesword: 2.5
stonebutton: 3.0
feather: 3.0
clayball: 3.0
wooddoor: 3.0
stoneaxe: 3.0
boat: 3.0
stone: 3.00
sandstone: 3.0
glass: 3.00
redstone: 3.0
arrow: 3.50
torch: 4.0
stonepickaxe: 4.0
chest: 4.0
mushroomsoup: 4.5
rawfish: 5.0
bread: 5.0
claybrick: 5.0
coalore: 5.0
string: 5.0
coal: 5.0
stoneplate: 6.0
watch: 6.0
grilledpork: 7.0
cookedfish: 7.0
furnace: 8.5
wheat: 9.0
fishingrod: 10.0
cactus: 10.0
leather: 10.0
apple: 10.0
paper: 10.0
sugarcane: 10.0
inksack: 10.0
glowstonedust: 10.0
sugar: 10.0
ironore: 12.0
clay: 12.0
irondoorblock: 15.0
sugarcaneblock: 15.0
bow: 15.0
sulphur: 20.0
brick: 21.0
bucket: 22.0
rails: 22.0
ironingot: 22.0
compass: 22.0
minecart: 23.0
painting: 25.0
lavabucket: 25.0
storageminecart: 30.0
redstoneore: 30.0
redstonewire: 30.0
bed: 30.0
chainmailboots: 30.0
glowingredstoneore: 30.0
poweredminecart: 32.0
redstonetorchon: 32.0
ironspade: 32.0
noteblock: 36.0
chainmailhelmet: 40.0
waterbucket: 40.0
leatherboots: 40.0
goldore: 40.0
lavabucket: 40.0
chainmailchestplate: 40.0
milkbucket: 40.0
irondoor: 44.0
book: 45.0
slimeball: 50.0
leatherhelmet: 50.0
chainmailleggings: 50.0
pumpkin: 50.0
goldingot: 50.0
ironhoe: 54.0
ironsword: 54.0
jackolantern: 56.0
dispenser: 58.0
goldspade: 60.0
leatherleggings: 70.0
ironaxe: 76.0
ironpickaxe: 76.0
leatherchestplate: 80.0
sponge: 80.0
ironboots: 88.0
mossycobblestone: 90.0
goldrecord: 100.0
bedrock: 100.0
saddle: 100.0
tnt: 100.0
lapisore: 100.0
greenrecord: 100.0
goldhoe: 110.0
goldsword: 110.0
ironhelmet: 110.0
diode: 110.0
obsidian: 130.0
coalblock: 135.0
bookshelf: 140.0
ironleggings: 154.0
goldpickaxe: 160.0
goldaxe: 160.0
cake: 180.0
ironchestplate: 198.0
ironblock: 198.0
goldboots: 200.0
diamond: 200.0
diamondspade: 210.0
diamondore: 210.0
goldhelmet: 250.0
goldleggins: 350.0
goldchestplate: 400.0
diamondhoe: 410.0
diamondsword: 410.0
goldblock: 450.0
goldenapple: 500.0
diamondpickaxe: 610.0
diamondaxe: 610.0
diamondboots: 800.0
lapisblock: 950.0
diamondhelmet: 1000.0
diamondleggings: 1400.0
diamondblock: 1800.0
diamondchestplate: 1800.0

Аватар пользователя
Просветленный

Вставьте в эксель разделитель двоеточие. И затем сложная сортировка

Аватар пользователя
Профи

в excel наверное есть нужные инструменты для это, гугли