My CSV file contains text that can span multiple lines. These lines are separated by the /n code. The text lines are enclosed in double quotes. This indicates that text spanning multiple lines in the CSV file should be included in a single cell.
However, after importing, these text lines have become multiple lines in the spreadsheet. I don’t think the double quotes are being considered during the import process.
CSV
First Name,Middle Name,Last Name,Phonetic First Name,Phonetic Middle Name,Phonetic Last Name,Name Prefix,Name Suffix,Nickname,File As,Organization Name,Organization Title,Organization Department,Birthday,Notes,Photo,Labels,E-mail 1 - Label,E-mail 1 - Value,E-mail 2 - Label,E-mail 2 - Value,E-mail 3 - Label,E-mail 3 - Value,E-mail 4 - Label,E-mail 4 - Value,Phone 1 - Label,Phone 1 - Value,Phone 2 - Label,Phone 2 - Value,Phone 3 - Label,Phone 3 - Value,Address 1 - Label,Address 1 - Formatted,Address 1 - Street,Address 1 - City,Address 1 - PO Box,Address 1 - Region,Address 1 - Postal Code,Address 1 - Country,Address 1 - Extended Address,Address 2 - Label,Address 2 - Formatted,Address 2 - Street,Address 2 - City,Address 2 - PO Box,Address 2 - Region,Address 2 - Postal Code,Address 2 - Country,Address 2 - Extended Address,Relation 1 - Label,Relation 1 - Value,Website 1 - Label,Website 1 - Value,Website 2 - Label,Website 2 - Value,Event 1 - Label,Event 1 - Value,Event 2 - Label,Event 2 - Value,Custom Field 1 - Label,Custom Field 1 - Value
?,Buddingh-van Harskamp,M.S.,3.2 Buren ::: * myContacts,Home,“28 Oude Kloostertuin
Oosterbeek 6861 GV
NL”,28 Oude Kloostertuin,Oosterbeek,6861 GV,NL,
Result
Expected in one cell:
Oude Kloostertuin 28
6861 GV Oosterbeek
NL
Can you please tell me how I can get the expected results?
OS version: Windows 11
App version: Onlyoffice/8.3.3.21
Downloaded from: ONLYOFFICE website
)