Timeline for How to remove double quotes within the double-quoted field values in .dat file
Current License: CC BY-SA 4.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 6, 2024 at 12:04 | comment | added | Mythri | Thank you all ! | |
| May 5, 2024 at 12:42 | history | edited | Ed Morton | CC BY-SA 4.0 |
added 1 character in body
|
| May 5, 2024 at 12:15 | history | edited | Ed Morton | CC BY-SA 4.0 |
added 1606 characters in body
|
| May 5, 2024 at 12:09 | history | edited | Ed Morton | CC BY-SA 4.0 |
added 1606 characters in body
|
| May 5, 2024 at 12:07 | comment | added | Ed Morton | If you really want to have your quoted string exist as a single field in the record, I updated my answer to show one way to do it. | |
| May 5, 2024 at 12:05 | comment | added | Ed Morton |
I added comments to the awk script. You seem to be missing the main point of my answer and comment - you can't use $11 because given that "s and ,s can exist inside "-delimited fields it is impossible for tools to tell where any field starts/stops using normal field splitting on ,s. So while awk will populate $11 it can be some substring inside a quoted field rather than a whole field.
|
|
| May 5, 2024 at 12:04 | history | edited | Ed Morton | CC BY-SA 4.0 |
added 1606 characters in body
|
| May 5, 2024 at 11:43 | history | edited | Ed Morton | CC BY-SA 4.0 |
added 300 characters in body
|
| May 5, 2024 at 0:59 | vote | accept | Mythri | ||
| May 5, 2024 at 1:00 | |||||
| May 5, 2024 at 0:57 | vote | accept | Mythri | ||
| May 5, 2024 at 0:59 | |||||
| May 5, 2024 at 0:31 | comment | added | Mythri | Thank you so much! the awk command worked for me, can you please explain the code. I am trying to understand what each of those lines do. I would have played with the code, but right now fully packed up with lot of development work. I tried to replace $0 with $11(line description column) but it did not work. Why? | |
| May 4, 2024 at 11:48 | history | edited | Ed Morton | CC BY-SA 4.0 |
added 852 characters in body
|
| May 3, 2024 at 21:02 | history | edited | Ed Morton | CC BY-SA 4.0 |
added 8 characters in body
|
| May 3, 2024 at 20:56 | history | answered | Ed Morton | CC BY-SA 4.0 |