How to fix newline and quotation mark

Andy Light

Hi. I have csv-file with separators by comma. And there are few lines that unlike from others. They divided into new lines by some reason.

In file:

"word1","word2
","word3
","word4
"
"nextword1","nextword2
","nextword3
","nextword4
"

What I need:

"word1","word2","word3","word4"
"nextword1","nextword2","nextword3","nextword4"

Can anyone help me to fix this please?

Ekopalypse

@Andy-Light

without knowing what caused it is hard to tell what needs to be done.
Did you use View->Show Symbols->Show all characters to see
what has been inserted?

Andy Light

@Ekopalypse all of lines ends with CRLF. But bugged rows ends without quotation mark.

Here is a normal row:

"word1","word2","word3","word4"

And here is a bugged row:

"word1","word2","word3","word4

As you can see, the bugged row doesn’t have quotation mark. Maybe there is a way how to find those rows?

Ekopalypse

@Andy-Light

given the example I would say this should do it

find what: ([^"])\r\n
replace with: \1

Alan Kilborn

This post is deleted!

Andy Light

@Ekopalypse it works! Wonderful! Thanks :)

Sudeep Tamrakar

Thanks, it helps me out.

Prahlad-Makwana4145

Hello, @Andy-Light

Please follow below steps :

Step 1:- Find (in regular expression mode) (.+)
Step 2:- Replace with: "/1"
Step 3:- This adds the quotes :

"word1"
"word2"
"word3"
"word4"

Step 4:- Find (in extended mode): /r/n
Step 5:- Replace with (with a space after the comma, not shown): ,
Step 6:- This converts the lines into a comma-separated list:
"word1", "word2", "word3", "word4"

I hope above information will be useful for you.
Thank you.