Timeline for Remove the last rows with no data but just commas from a CSV file through shell script
Current License: CC BY-SA 4.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 24, 2021 at 17:50 | comment | added | Ed Morton | Can your data also have lines of all commas BEFORE the last line that contains non-commas and, if so, do you want those lines removed too or only the lines after the last line that contains non-commas? See the sample input/output in my answer for example. | |
| Sep 24, 2021 at 16:35 | answer | added | Ed Morton | timeline score: 0 | |
| Sep 24, 2021 at 7:25 | answer | added | Mayank Parihar | timeline score: -1 | |
| Sep 24, 2021 at 6:58 | comment | added | Paul_Pedant | Having suffered this issue myself, you might need to beware of additional junk such as completely blank lines, training whitespace, and carriage returns. The problem seems to arise from slapdash selection of data during Excel exports. | |
| Sep 24, 2021 at 6:55 | vote | accept | Mayank Parihar | ||
| Sep 24, 2021 at 6:49 | comment | added | Mayank Parihar | There are 4 files which needs to be treated. And each of them have different number of fields | |
| Sep 24, 2021 at 6:48 | answer | added | Kusalananda♦ | timeline score: 2 | |
| Sep 24, 2021 at 6:41 | comment | added | Mayank Parihar | It is coming through a tool with which I can't do much. Editing the data through the shell script for sending it ahead would be an easier solution | |
| Sep 24, 2021 at 6:40 | comment | added | Kusalananda♦ | How are you generating the CSV data? It seems that it should be possible to produce the data correctly from the start instead of relying on a post-processing step to correct it after the fact. | |
| Sep 24, 2021 at 6:38 | history | edited | Kusalananda♦ | CC BY-SA 4.0 | Markup, spelling etc. |
| S Sep 24, 2021 at 6:30 | review | First questions | |||
| Sep 24, 2021 at 17:48 | |||||
| S Sep 24, 2021 at 6:30 | history | asked | Mayank Parihar | CC BY-SA 4.0 |