Timeline for Parse text file add semicolons before and after numbers; join all other words that are before/ between numbers with hyphens
Current License: CC BY-SA 4.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 1, 2023 at 23:07 | comment | added | jubilatious1 | +1 for catching/correcting output so that "...every output line has the same number of fields...". :-) | |
| Nov 1, 2023 at 22:09 | comment | added | Ed Morton | You're welcome. I added a version that will output the failed rows to stderr and write that to a file. If you need any additional changes then please ask a new question. | |
| Nov 1, 2023 at 22:08 | history | edited | Ed Morton | CC BY-SA 4.0 | added 422 characters in body |
| Nov 1, 2023 at 21:09 | comment | added | tgkprog | Thank you a few rows it ignored, is there a way to tell awk to report how many rows it did not process or give it an error stream/file to report to? i made the first column unique by joining a column with an id number after the word using spreadsheet. Then compared the col1 unparsed and parsed by awk to know which rows were not processed, corrected the data oin those (just 3 rows) and it worked fine. Next time should leave col1 as line numbers. just FYI. Your awk command was super helpful. Thank you :-) | |
| Nov 1, 2023 at 21:06 | vote | accept | tgkprog | ||
| Nov 1, 2023 at 14:26 | comment | added | Ed Morton | I updated it to make it a bit more robust to handle input other than the example in your question. | |
| Nov 1, 2023 at 14:24 | history | edited | Ed Morton | CC BY-SA 4.0 | added 42 characters in body |
| Nov 1, 2023 at 14:18 | history | edited | Ed Morton | CC BY-SA 4.0 | added 47 characters in body |
| Nov 1, 2023 at 14:03 | history | edited | Ed Morton | CC BY-SA 4.0 | added 47 characters in body |
| Nov 1, 2023 at 13:55 | history | edited | Ed Morton | CC BY-SA 4.0 | added 47 characters in body |
| Nov 1, 2023 at 13:50 | history | edited | Ed Morton | CC BY-SA 4.0 | added 10 characters in body |
| Nov 1, 2023 at 12:54 | history | edited | Ed Morton | CC BY-SA 4.0 | added 379 characters in body |
| Nov 1, 2023 at 11:15 | history | edited | Ed Morton | CC BY-SA 4.0 | deleted 4 characters in body |
| Oct 31, 2023 at 23:50 | comment | added | tgkprog | Swell I was trying thing with awk but was no where near. And your right would be good to have 4 fields std | |
| Oct 31, 2023 at 23:10 | history | answered | Ed Morton | CC BY-SA 4.0 |