General description:
1. Paste in a CSV file ( no matter if semicolon or tab separated)
2. Be sure one column have quoted data with an line break.
3. Switch to CSV mode (semicolon or tab respectively)
4. Lines are joined and the “MJ ” are visible.
5. Switch back to Normal mode and some of the last lines are NOT switched back to multiple lines, but still have the “MJ” visible.
Details:
My first test was this semicolon separated example:
– Paste in the “example of the original data” from http://stackoverflow.com/questions/14396605/read-csv-file-with-embedded-newlines
– In EmEditor use User-defined separated = ;
– Lines are joined and the “MJ ” are there
– Switch to “Normal Mode” >>> only the first line is restored to multi-lines.
My second test was with the example from above post too:
ID;Name Ver.;Lang
10;”Acrobat Vollversion
5.05″;German
My third test was this tab separated example:
1) paste a few lines of the “Suppliers” list from “http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_join_inner”
2) in “SupplierName” column add quotes and an line break where you want.(example below)
3) Switch to tab CSV mode.
4) Lines are joined and the “MJ ” are visible.
5) Switch back to Normal mode and some of the last lines are NOT switched back to multiple lines, but still have the “MJ” visible.
6) Add some more lines to the end and test again: now the “MJ” are transformed to line break.
7) Manipulate fourth or sixth last line again by adding quotes and line breaks.
8) Test again and you will see that the “MJ” are NOT transformed back to line break.
This happens always with just the last few lines.
I will create a video for better explanation…. tomorrow.
Examples from “Suppliers” list from “http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_join_inner”
SupplierID SupplierName ContactName Address
1 Exotic Liquid Charlotte Cooper 49 Gilbert St.
2 New Orleans Cajun Delights Shelley Burke P.O. Box 78934
3 Grandma Kelly’s Homestead Regina Murphy
SupplierID SupplierName ContactName Address
1 Exotic Liquid Charlotte Cooper 49 Gilbert St.
2 “New Orleans Cajun
Delights” Shelley Burke P.O. Box 78934
3 “Grandma Kelly’s
Homestead” Regina Murphy