Timeline for Sorting numerically a list
Current License: CC BY-SA 4.0
        27 events
    
    | when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Mar 27, 2021 at 19:13 | history | bounty ended | fich | ||
| S Mar 27, 2021 at 19:13 | history | notice removed | fich | ||
| Mar 27, 2021 at 19:13 | vote | accept | fich | ||
| Mar 25, 2021 at 12:21 | comment | added | Ed Morton | @fich those things aren't hard to handle (my answer handles all of them and also would allow ;s in the title) but they really need to be present in your example so we know to do so and have something we can test with. All of the other answers so far make assumptions that(,volume, etc. can't occur in the title and/or you don't have records before/after the ones you want sorted and/or you don't just want to sort 100 of them, etc. because none of those cases are included in your sample input/output. Just stating they exist isn't adequate, they need to be present in the example. | |
| Mar 25, 2021 at 11:04 | comment | added | fich | @EdMorton yes, titles may have special characters, I edited that. One exception is ;that only act as a separator. I have indeed volumes after Collection one that I do not want to be sorted, or volumes of Collection one beyond those 100 straight volumes of Collections one, but I think if I include those options in the question, it will be almost intractable | |
| Mar 25, 2021 at 10:58 | history | edited | fich | CC BY-SA 4.0 | 
                
                    added 215 characters in body 
                
             | 
| Mar 25, 2021 at 10:51 | comment | added | fich | @αғsнιη sorry for the misunderstanding. I want a new G number for the item that is being relocated (as in the example, La isla del tesoro was 293G and now is 295G). I have deleted the expression because I thought that there may be confusion, as in the final output the G numbers are in the same old position globally (first 292G, second 293G, etc...) | |
| Mar 22, 2021 at 14:40 | answer | added | Ed Morton | timeline score: 1 | |
| Mar 22, 2021 at 13:47 | comment | added | Ed Morton | Are there volumes before and/or after "Collection one" volumnes that you do not want sorted but should just remain as-is with the sorted "Collection one" columns replaced in-situ? If so add some of those other collections to your sample input/output. | |
| Mar 22, 2021 at 13:38 | comment | added | Ed Morton | Those first fields look book titles. Book titles can contain characters and strings such as ;,(,),(volume 3), etc. which would make processing your text much more difficult and probably break all of the answers you have so far. You must be handling that currently (I'd guess by quoting your fields but idk) so please edit your question to include those cases (e.g.296G - Kill Bill; Bury Him (volume 2) ; Collection one (volume 1) ; Tarantino ; ...) and show how you handle them (296G - "Kill Bill; Bury Him (volume 2)" ; Collection...?) so we see how non-trivial input is formatted. | |
| Mar 22, 2021 at 10:10 | comment | added | αғsнιη | why do you deleted " so the primary number (the number with the G) has to be recalculated." part in revision 7 from your question? it was the clarification about how output generates. because you then telling that for given answer unix.stackexchange.com/questions/639814/… | |
| Mar 22, 2021 at 10:09 | history | edited | αғsнιη | 
                
                    edited tags 
                
             | |
| Mar 22, 2021 at 9:35 | answer | added | αғsнιη | timeline score: 0 | |
| Mar 21, 2021 at 10:51 | answer | added | FelixJN | timeline score: 1 | |
| Mar 21, 2021 at 10:43 | history | edited | fich | CC BY-SA 4.0 | 
                
                    added 143 characters in body 
                
             | 
| Mar 21, 2021 at 10:18 | history | edited | fich | CC BY-SA 4.0 | 
                
                    added 2 characters in body 
                
             | 
| Mar 21, 2021 at 2:12 | answer | added | Joce | timeline score: 3 | |
| Mar 20, 2021 at 23:11 | history | edited | fich | CC BY-SA 4.0 | 
                
                    deleted 73 characters in body 
                
             | 
| S Mar 20, 2021 at 22:49 | history | bounty started | fich | ||
| S Mar 20, 2021 at 22:49 | history | notice added | fich | Draw attention | |
| Mar 18, 2021 at 22:38 | history | edited | fich | CC BY-SA 4.0 | 
                
                    added 1 character in body 
                
             | 
| Mar 18, 2021 at 22:33 | history | edited | fich | CC BY-SA 4.0 | 
                
                    edited body 
                
             | 
| Mar 18, 2021 at 22:15 | history | edited | fich | CC BY-SA 4.0 | 
                
                    added 739 characters in body 
                
             | 
| Mar 18, 2021 at 18:26 | review | Close votes | |||
| Mar 19, 2021 at 18:51 | |||||
| Mar 18, 2021 at 12:49 | history | edited | fich | CC BY-SA 4.0 | 
                
                    deleted 1 character in body 
                
             | 
| Mar 18, 2021 at 12:43 | history | edited | fich | CC BY-SA 4.0 | 
                
                    added 431 characters in body 
                
             | 
| Mar 18, 2021 at 0:40 | history | asked | fich | CC BY-SA 4.0 |