Timeline for How to convert a CSV with multiple sub-row items (from a column) to new columns in Awk?
Current License: CC BY-SA 4.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 30, 2021 at 20:15 | history | edited | not2qubit | CC BY-SA 4.0 |
updated UPDATE
|
| Apr 29, 2021 at 20:41 | vote | accept | not2qubit | ||
| Apr 29, 2021 at 16:53 | history | edited | not2qubit | CC BY-SA 4.0 |
added 131 characters in body
|
| Apr 29, 2021 at 16:43 | history | edited | not2qubit | CC BY-SA 4.0 |
added update info
|
| Apr 29, 2021 at 16:38 | comment | added | Ed Morton |
-F'[,"]' is pretty suspect. Actually so are the other conditions. If you post a new question we can help you with that filtering.
|
|
| Apr 29, 2021 at 16:31 | comment | added | not2qubit |
Hi @EdMorton, no, but since the actual data is OCR extracted from a PDF file, there certainly could be garbage. I've tried to do some rudimentary pre-filtering using: awk -F'[,"]' '($2~/[0-9]+/ && $3~/F[0-9]+/) || (!$2 && !$3)', because there may be rows that look like: sometimes,shit,happens,with,data.
|
|
| Apr 29, 2021 at 13:58 | comment | added | Ed Morton |
Can the item value ever be the number 0?
|
|
| Apr 29, 2021 at 7:06 | vote | accept | not2qubit | ||
| Apr 29, 2021 at 16:58 | |||||
| Apr 29, 2021 at 7:00 | history | edited | αғsнιη |
edited tags
|
|
| Apr 29, 2021 at 6:30 | answer | added | αғsнιη | timeline score: 2 | |
| Apr 29, 2021 at 6:15 | history | edited | not2qubit | CC BY-SA 4.0 |
added 22 characters in body
|
| Apr 29, 2021 at 6:10 | history | asked | not2qubit | CC BY-SA 4.0 |