Timeline for CSV file processing - remove quotes and replace comma delimiter with tab
Current License: CC BY-SA 4.0
23 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 25, 2023 at 4:08 | answer | added | jubilatious1 | timeline score: 0 | |
| Nov 18, 2018 at 9:41 | history | edited | Rui F Ribeiro | CC BY-SA 4.0 | deleted 5 characters in body |
| Sep 8, 2017 at 3:59 | vote | accept | Arijit Choudhury | ||
| Sep 8, 2017 at 3:55 | vote | accept | Arijit Choudhury | ||
| Sep 8, 2017 at 3:59 | |||||
| Sep 8, 2017 at 3:55 | vote | accept | Arijit Choudhury | ||
| Sep 8, 2017 at 3:55 | |||||
| Sep 4, 2017 at 8:46 | comment | added | Philippos | Then please mark the question as answered, so it doesn't fish for more answers. Check the answer that did help you most, so future readers can identify it. Thank you. | |
| Sep 1, 2017 at 23:25 | comment | added | Arijit Choudhury | Would like to thank all the experts for helping me out !!! My requirement is successfully met. | |
| Sep 1, 2017 at 10:21 | answer | added | glenn jackman | timeline score: 0 | |
| Sep 1, 2017 at 7:16 | answer | added | Philippos | timeline score: 2 | |
| Sep 1, 2017 at 7:13 | answer | added | nxnev | timeline score: 0 | |
| Sep 1, 2017 at 6:43 | comment | added | Arijit Choudhury | Hi Nexnev, a script should be fine too, as long as it is able to process both the mentioned scenarios i.e. file with quotes and without quotes. Any combination of command would also be fine like we did try to mix and match SED and AWK to get the results. Even we tried a single SED command which actually gave the desired result but takes a lot of time to process, approx it took 8~10 Hours. The requirement is to process files of size 6 to 7 GB in less than 1 hour. | |
| Sep 1, 2017 at 6:42 | answer | added | Kusalananda♦ | timeline score: 5 | |
| Sep 1, 2017 at 2:20 | comment | added | nxnev | Do you strictly need it to be a single command in awk? I made a script but it doesn't use awk and neither sed. | |
| Aug 31, 2017 at 22:29 | answer | added | RomanPerekhrest | timeline score: 2 | |
| Aug 31, 2017 at 22:13 | history | edited | GAD3R | CC BY-SA 3.0 | added 3 characters in body |
| Aug 31, 2017 at 22:03 | history | edited | Arijit Choudhury | CC BY-SA 3.0 | added 4 characters in body |
| Aug 31, 2017 at 22:01 | comment | added | Arijit Choudhury | We tried this command which works fine on the higher environment. sed -e '/^\s*$/d' -e '$d' tpt.csv | awk 'BEGIN { FPAT="([^,]+)|(\"[^\"]+\")"; OFS="\t" } $1=$1' | sed -e 's/"//g' > tpt.tsv | |
| Aug 31, 2017 at 22:01 | history | edited | Jeff Schaller♦ | edited tags | |
| Aug 31, 2017 at 21:59 | history | edited | Arijit Choudhury | CC BY-SA 3.0 | added 76 characters in body |
| Aug 31, 2017 at 21:59 | comment | added | pfnuesel | What did you try? | |
| Aug 31, 2017 at 21:58 | comment | added | Arijit Choudhury | The command should be effective in Awk 3.x on RHEL 6.x environment. | |
| Aug 31, 2017 at 21:58 | review | First posts | |||
| Aug 31, 2017 at 22:17 | |||||
| Aug 31, 2017 at 21:56 | history | asked | Arijit Choudhury | CC BY-SA 3.0 |