I have csv file , all the values of column is separated by "," .
Some column have embedded comma "," . How can i Remove these embedded commas
These embedded commas creating problems to extract value from csv file.
I am using shell script.
Try something like this -
sed 's/\(\"\)\(.*\)\(,\)\(.*\)\(\"\)/\1\2\3\4/' < $input > $tmpFile
cp $tmpFile $input
In excel_sheet.xls some cell contains newline character.
I created cvs (excel_sheet.cvs) form xls. In this cvs same row is divided in two row because of new line character in cell value. I want to extract values from CVS.
how to raise a shell script to raise an alarm o the Linux system when the system disk space exceeds the 90% usage