Timeline for replace space and empty cells in csv file
Current License: CC BY-SA 3.0
19 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 1 at 18:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 2 at 13:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 4, 2023 at 21:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 5, 2023 at 18:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 30, 2023 at 10:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 28, 2022 at 7:07 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 31, 2022 at 3:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 25, 2022 at 15:06 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Dec 18, 2018 at 10:36 | answer | added | Jack Culhane | timeline score: 0 | |
| Apr 29, 2017 at 22:16 | answer | added | bstipe | timeline score: 0 | |
| Mar 15, 2017 at 17:19 | comment | added | uzsolt | if the count of commas is greater then your number of columns. Or... many cases. The other question (how do resolve): I'm using "psv", "pipe separated values", the separator character is "|". It's rarely used character in texts or numbers :) | |
| Mar 15, 2017 at 14:02 | comment | added | Elham | @uzsolt2, how can I know if my file has this problem and how do I resolve it. Because I think one of my other files has this problem, so when I use awk to get one column printed (the last one in the file), it returns an empty column. | |
| Mar 12, 2017 at 20:24 | comment | added | Elham | Thank you. based on @Cyrus previous comment (which now seems to have been removed). I did this followed by replace empty space with NA and it worked: sed 's/ *,/,/g' file1 | sed 's/,,/,NA,/g' > file2 | |
| Mar 12, 2017 at 17:49 | comment | added | uzsolt |
Please be careful: if your CSV file contains spaces and commas (for example foo,"bar, baz",bar - it has two cells: foo, bar, baz and bar) it isn't easy to parse (and change) with sed or awk.
|
|
| Mar 12, 2017 at 17:22 | history | edited | Cyrus | CC BY-SA 3.0 |
layout fixed
|
| Mar 12, 2017 at 17:14 | history | edited | Elham | CC BY-SA 3.0 |
added 419 characters in body
|
| Mar 12, 2017 at 17:08 | history | edited | Elham | CC BY-SA 3.0 |
added 419 characters in body
|
| Mar 12, 2017 at 16:48 | review | First posts | |||
| Mar 18, 2017 at 4:55 | |||||
| Mar 12, 2017 at 16:45 | history | asked | Elham | CC BY-SA 3.0 |