-1

I have a CSV file and I want to remove the all line feeds (LF or \n) which are all coming in between the double quotes alone.

Can you please provide me an Unix script to perform the above task. I have given the input and expected output below.

Input :

No,Status,Date

1,"Success

Error",1/15/2018

2,"Success

Error

NA",2/15/2018

3,"Success

Error",3/15/2018

Expected output:

No,Status,Date

1,"Success Error",1/15/2018

2,"Success Error NA",2/15/2018

3,"Success Error",3/15/2018

Siva
  • 1
  • 1
  • 3
    Welcome to Stack Overflow. This is not a code/SQL/regex writing service, where you post a list of your requirements and language of choice and a code monkey churns out code for you. We're more than happy to help, but we expect you to make an effort to solve the problem yourself first. Once you've done so, you can explain the problem you're having, include the **relevant** portions of your work, and ask a specific question, and we'll try to help. Good luck. – Ken White Apr 04 '18 at 02:46