Timeline for Changing non-standard date timestamp format in CSV using awk/sed
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 4, 2023 at 17:34 | history | edited | Stéphane Chazelas | CC BY-SA 4.0 |
added 519 characters in body
|
| Jul 4, 2023 at 16:40 | comment | added | annahri | After understanding the sed, that's so genius! | |
| Jul 4, 2023 at 16:36 | comment | added | Stéphane Chazelas | See also pass arguments to the date command in LHS of sed. This is a common technique in sed, not limited to month name translation. | |
| Jul 4, 2023 at 16:32 | comment | added | Stéphane Chazelas | @ehammer, see edit. | |
| Jul 4, 2023 at 16:32 | history | edited | Stéphane Chazelas | CC BY-SA 4.0 |
added 518 characters in body
|
| Jul 4, 2023 at 15:39 | comment | added | user432564 | Can you explain the sed command a little more? I have never seen a multi expression reference a substitution in a previous line, how does the first substitution get the month capture group passed to it? I am thinking I could format both timestamps in my csv, then go back and regex find the 3 letter month name and then do the lookup for the number. | |
| Jul 4, 2023 at 13:23 | history | edited | Stéphane Chazelas | CC BY-SA 4.0 |
added 339 characters in body
|
| Jul 4, 2023 at 13:00 | history | edited | Stéphane Chazelas | CC BY-SA 4.0 |
added 227 characters in body
|
| Jul 4, 2023 at 6:05 | history | answered | Stéphane Chazelas | CC BY-SA 4.0 |