Skip to main content
Unix & Linux

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*

5
  • What operating system are you using? Please mention that in the question instead of using tags for it (OS tags should be used when the question is about the OS, not when you're simply using that OS). And you have tagged with both Linux and Solaris, two very different systems with different versions of the standard tools. Commented Mar 24, 2018 at 15:23
  • In addition to what terdon said, you have tagged the question with both awk and sed, but thu only utility mentioned in the question itself is grep. Commented Mar 24, 2018 at 15:26
  • I have to implement it on both Linux and Solaris OS using awk cmd. Commented Mar 24, 2018 at 16:05
  • For properly formatted CSV, you should double any existing double quotes, then enclose in double quotes: test|test_f|21/03/2017|"""|||||USER ""RIGHTa anything here"|123 Commented Mar 25, 2018 at 3:02
  • And you should be fixing the process that creates the file in the first place, instead of repairing the damage. Commented Mar 25, 2018 at 3:03