Shell Programming and Scripting

Hello All,

Got an issue on sending an email with comma seperated values.

Say my file is abc.txt which is

Code:

cat abc.txt
123,456,the american express,America,Day

I will send in a Spread sheet which come in 5 columns. since it has got a space in it, the Spread sheet comes with 7 columns..

I used it as

Code:

cat abc.txt |sed 's/   *,/,/' | sed 's/,/ /g'

Can you please help here..

try using .csv for comma separated files..

This is an error with your spreadsheet software, not the CSV. Excel for instance lets you import with whatever you want as the delimiter...

@Pamu, yes I use that .csv only..

I use that as

Code:

cat abc.txt |sed 's/   *,/,/' | sed 's/,/ /g' > xyz.csv
uuencode xyz.csv xyz.csv | mailx -s "Test" abc@def.com

Still the cells are incorrectly aligned.

@Corona688:
Excel separates the value in the cells by space as default , isn't it?
also this .csv is getting sent to another team who doesn't care on to delimit the values by comma separated. They use on however it comes..

Hence I want my Script to delimit the values into adjacent cells as below
ID1 ID2 Name Country Zt
123 456 the american express America Day

At now, the second row goes in 7 cells due to a space between the values in the Name.

.csv is a comma separated file. And you are removing all the commas.....

try removing above highlighted sed..

Yeah Pamu, it works out... Learnt what .csv does now.

CSV usually puts double quotes around string values to eliminate those errors with blanks etc. Try double quoting but leave numeric out.