Hi All;
I got a text file that comes like:
"1Name";"LastName";"Comment field this one extends itself
and breaks in two lines"
"2Name";"LastName";"Shorter comment now"
... and it goes.
This sample is somewhat like an export txt from Outlook Express, the problem is that when the comment field splits in two lines Oultook cannot mount back the information correctly when re-importing the txt cause it mistakes the broken line. What I need is a code to read the txt file and whenever it breaks lines without closing the quotes first it gets everything and rewrites it on another one formating like below:
"1Name";"LastName";"Comment field this one extends itself and breaks in two lines"
"2Name";"LastName";"Shorter comment now"
Alexandre @lmarton Marton
almarton@task.com.br
I got a text file that comes like:
"1Name";"LastName";"Comment field this one extends itself
and breaks in two lines"
"2Name";"LastName";"Shorter comment now"
... and it goes.
This sample is somewhat like an export txt from Outlook Express, the problem is that when the comment field splits in two lines Oultook cannot mount back the information correctly when re-importing the txt cause it mistakes the broken line. What I need is a code to read the txt file and whenever it breaks lines without closing the quotes first it gets everything and rewrites it on another one formating like below:
"1Name";"LastName";"Comment field this one extends itself and breaks in two lines"
"2Name";"LastName";"Shorter comment now"
Alexandre @lmarton Marton
almarton@task.com.br