newline not work with my csv

nicksu · 03-31-2013, 09:11 PM

Hi,I have a file,content as below:
a
b
c
d

and I want insert the content into a csv form,and used the
"echo ,,`cat file`, >file.csv"
but the csv form turns out to be as below:

Click image for larger version

Name: Capture.PNG
Views: 23
Size: 1.2 KB
ID: 12175

Can anyone help to make the newline work,and keep the format as the file shows,not shows in one line.

evo2 · 03-31-2013, 10:55 PM

Hi,

what about the following:

Code:

sed 's/$/,/g' < file > file.csv

If that doesn't do what you want (because at this point we can only guess), please be explicit about what you want the output csv file to look like.

Evo2.

nicksu · 03-31-2013, 11:17 PM

Quote:

Originally Posted by evo2

Hi,

what about the following:

Code:

sed 's/$/,/g' < file > file.csv

If that doesn't do what you want (because at this point we can only guess), please be explicit about what you want the output csv file to look like.

Evo2.

Click image for larger version

Name: Capture.PNG
Views: 26
Size: 1.8 KB
ID: 12176

Hi,I want it to look like this,thank you for your help

evo2 · 03-31-2013, 11:43 PM

Hi,

Quote:

Originally Posted by nicksu

Attachment 12176Hi,I want it to look like this,thank you for your help

I need to see the csv file itself, not how it is rendered in some spread sheet program. Eg what is the output of

Code:

cat --show-nonprinting file.csv

Evo2.

Wim Sturkenboom · 04-01-2013, 12:04 AM

You need to embed the text in double quotes. The below was tested in a windows environment and shows how you can embed newlines (double quotes highlighted in bold red) as well as commas in csv fields.

csv file

Code:

"a
b
c
d","1,2,3,4"
"x
y
z","0,9,8,7"

The result

Code:

+----+-------------+
| a  | 1,2,3,4     |
| b  |             |
| c  |             |
| d  |             |
+----+-------------+
| x  | 0,9,8,7     |
| y  |             |
| z  |             |
+----+-------------+

Explanation:
unless within double quotes, newlines indicate the end of the records; similar, commas indicated the end of a field

nicksu · 04-01-2013, 12:41 AM

Quote:

Originally Posted by evo2

Hi,

I need to see the csv file itself, not how it is rendered in some spread sheet program. Eg what is the output of

Code:

cat --show-nonprinting file.csv

Evo2.

[ssh@Nick sf_osshare]$ cat --show-nonprinting t.csv
,,a
b
c
d,
HI,nothing different

evo2 · 04-01-2013, 01:33 AM

Hi,

I thought that Wim's post was the answer...

Quote:

Originally Posted by nicksu

[ssh@Nick sf_osshare]$ cat --show-nonprinting t.csv
,,a
b
c
d,
HI,nothing different

Does that file display as you want it to in your spread sheet? If yes, then what is the problem? If no, then please post the contents of the file that does.

Evo2.

PS. Please use [code] tags where appropriate.

nicksu · 04-01-2013, 03:38 AM

Quote:

Originally Posted by evo2

Hi,

I thought that Will's post was the answer...

Does that file display as you want it to in your spread sheet? If yes, then what is the problem? If no, then please post the contents of the file that does.

Evo2.

PS. Please use [code] tags where appropriate.

Hi,thank you for your help.a printf work,thank you