Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

4
  • Thanks for updating your answer! After some few data cleanup, I managed to make it work in respect to your code! big thanks! Commented Sep 6, 2022 at 13:46
  • Answer edited to process comma separated values, where values are double quoted. Two changes were needed (1) change the value of FS (2) add a double quote character when the value of $5 was cut (sub(...)). @GifterVillanueva Commented Sep 6, 2022 at 14:22
  • Thank you so much! This worked as intended and how I would've wanted it! Commented Sep 6, 2022 at 14:30
  • 1
    @GifterVillanueva You are welcome !. :-) Commented Sep 6, 2022 at 14:32