C
Cathy
[Briefing]
I got an Project export Text into the CSV file type.
However i face a problem that if my CSV data contain multiple line(eg : "
sleep\r\nHello\r\n"), and open this in the CSV file. We notice that a empty
space is appended behind the new line.
[Result]
sleep<Space>
Hello<space>
If i open this CSV file with notepad, this issue doesnt happen.
[Research]
I had do some similar research
1. Open Outlook contact, at the address field, i break the address into a
few line and export the contact into the CSV file.
- The Outlook CSV file having the same behavior as mention above
2. Open a Notepad and type below text into the notepad.
"CAV
CAV@
CAV@"
and save the notepad into the csv type and then open the CSV file with excel.
- The notepad CSV file also having the same behavior as mention about.
[Question]
why excel appended an empty space behind the "\r\n"? It is a bug for excel?
I got an Project export Text into the CSV file type.
However i face a problem that if my CSV data contain multiple line(eg : "
sleep\r\nHello\r\n"), and open this in the CSV file. We notice that a empty
space is appended behind the new line.
[Result]
sleep<Space>
Hello<space>
If i open this CSV file with notepad, this issue doesnt happen.
[Research]
I had do some similar research
1. Open Outlook contact, at the address field, i break the address into a
few line and export the contact into the CSV file.
- The Outlook CSV file having the same behavior as mention above
2. Open a Notepad and type below text into the notepad.
"CAV
CAV@
CAV@"
and save the notepad into the csv type and then open the CSV file with excel.
- The notepad CSV file also having the same behavior as mention about.
[Question]
why excel appended an empty space behind the "\r\n"? It is a bug for excel?