How to handle improper Data Coming from CSV in Informatica

Question

I have source file (CSV) and need to load into target (Oracle). But I got an error

FR_3065 ROW[4],Filed [Student_rollnumber]:Invalid Number:[.].The row will be skipped

CSV TABL

Student_rollnumber,Studnet_Name,Marks,Subjects
10,'Revanth',70,"Maths",
11,'Satish',85,Science
12,'Anil',75,"Java
",
13,'Surya',90,"C++",
14,'Ramana',85,"python",
15,'Sudheer'70,"Informatica
",
16,'Prakash',85,"SQL"

I found that in line number 4 the qouts and comma(",) are in the next line how to concat that both ("Java",) And make it single column(Subject)

Answer 1

MatchQuotesPastEndOfLine mentioned by Koushik should work.

Alternatively you may use sed with below pattern to replace newline+" with simply just a " - as a result removing the new line at the end of quoted string.

sed ':a;N;$!ba;s/\n"/"/g'

Feel free to test this gist.

This however will remove just the ending new line and will not help if it's anywhere in the middle. As said, the MatchQuotesPastEndOfLine mentioned by Koushik is the best possible solution.

Above has been based on this question.