Shell Programming and Scripting

Hi,

I am trying to attach and email a csv file in the form of an excel sheet.
And I have been successful in doing this.

But after some days I realised that some fields in the csv file are also having commas because of which this field is getting splitted in columns in the excel sheet.

Is there a way by which I can change the field separator from comma to something else, say a pipe or something?

I use the following command to send the email:

mailx -r from_email@abc.com -s "Subject" to_email@abc.com < <filename.txt>

Could some one assist me on this one please?

Regards,
Girish.

Code:

 
sed 's/,/|/g' csvFile

e.g.

Code:

 
echo "fdfdfdf,dffdf,fdfdf" | sed 's/,/|/g'

gives

Code:

 
fdfdfdf|dffdf|fdfdf

I think he means that he has something like:

"field1", "field 2, with a comma","field 3"

and he wants to change it to

"field1"|"field 2, with a comma"|"field 3"

How's awk or sed or whatever supposed to tell the data apart from the delimiters? It will have the same problem as excel. You need to create it with "|" instead of "," in the first place, not translate later. Or fix the code that's injecting the thousands separators or whatever they are.

I'd do it by replacing ", with "|

That might work, if and only if the input data is actually formatted like that... Is it?