and modified it for our environment to uuencode it and mail a csv to me. The issue I have is the output contains quotes that hinder the csv use appropriately.
My script looks like this
Code:
cd /tmp
df -Pg | awk 'BEGIN{
print "\t\t\t SPACE OF IMPORTANT FILE SYSTEMS\t\n-------------------------------------------------------------------------------\n FILE-SYSTEM\t TOTAL-SPACE\t USED-SPACE\t FREE-SPACE\t %USED\n"}
function disp(v1,v2,v3,v4,v5){
printf "%-21s\t %10s\t %13s\t %10s\t %5s \n",v1,v2,v3,v4,v5
}
NR>2&&(($3>($2*.80)&&disp($6,$2,$3,$4,$5))||($3>($2*.40)&&$3<($2*.80)&&disp($6,$2,$3,$4,$5))||($3<($2*.40)&&disp($6,$2,$3,$4,$5)))
END{print "-------------------------------------------------------------------------------\n"}' > email.csv
uuencode email.csv email.csv | /bin/mailx -s "$HOST diskusage usage" email@email.com
rm -rf email.csv
The output looks like this when pulled out of the csv
If I can remove the quotes from the output, the spreadsheet works perfectly (since this is now the practice I have to do to get it to populate the rows and columns correctly.)
What can I do in the script side to remove the quotes from the end product?
I appreciate any input.
Stryker
Last edited by Scrutinizer; 07-22-2013 at 06:40 PM..
Reason: extra code tags
Hi,
I am trying to replace a specific column values in a csv file with double quotes.
Example:
SNO,NAME,ZIPCODE,RANK
1,Robert,74538,12
2,Sam,07564,13
3,Kim, Ed,12345,14
Desired Output:
SNO,NAME,ZIPCODE,RANK
1,Robert Ken,74538,12
2,Sam Mik,"07564",13
3,"Kim, Ed",12345,14
I... (3 Replies)
I have a CSV file that is missing quotes around a column that contains text with commas. Example:
Column1, Column2, Column3, Column4, Column5, Column6
Data1, Data2, Data3, Data, 4, Data5, Data6
Data1, Data3, Data3, Data, text, 4, Data5, Data6
I think the easiest way for me to fix this is to... (2 Replies)
Hello,
I need to read a csv file and I am trying to replace a comma with a text DSEE?DSEE.
Example
Input
"Chapter","NewTrains, "oldTrains","Delayed",10,"London"
"Chapter","Newbuses,oldbuses","On Time",20,"London"
Output
"Chapter","NewTrainsDSEE?DSEE... (5 Replies)
I saved the csv file in a comma delimited format.
Sample input
input.csv
1 abc 2
2 def 4
3 ghi 6
4 jkl 8
5 mno 10
output.csv should look like this with single quotes around each field
'1' 'abc' '2'
'2' 'def' '4'
'3' 'ghi' '6'
'4' 'jkl' '8'
'5' 'mno' '10'
Please help me :confused:... (3 Replies)
Hi List,
I am sure this issue must have been encountered before. I have saved an excel CSV and sent it to my linux box where I require to parse it as a CSV line by line. The file displays fine in Excel with csv headers and consistent records and fields. However when I look at it in linux I see... (2 Replies)
Hello experts,
I need to validate a csv file which contains data like this:
Sample.csv
"ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0
"ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0
I just need to check if all the records contain exactly the number of... (5 Replies)
I have a csv data file :
A,B,C,D,"A,B",E,"GG,H"
E,F,G,H,I,J,"S,P"
I need to replace all "," with "|" except the ones between double quotes i.e
A|B|C|D|"A,B"|E|"GG,H"
E|F|G|H|I|J|"S,P"
CAn someone assist? (8 Replies)
Okay, I would like to delete all the commas in a .CSV file (TEST.CSV) or at least substitute them with empty space, that are enclosed in double quote.
Please see the sample file as below:
column 1,column 2,column 3,column 4,column 5,column 6,column 7,column 8,column 9,column 10... (8 Replies)
i have data as below
123,"paul phiri",paul@yahoo.com,"po.box 23, BT","Eco Bank,Blantyre,Malawi"
i need an output to be
123,"paul phiri",paul@yahoo.com,"po.box 23 BT","Eco Bank Blantyre Malawi" (5 Replies)
Hi All,
I'm unable to load the data using sql loader where there are double quotes within the double quotes As these are optionally enclosed by double quotes.
Sample Data :
"221100",138.00,"D","0019/1477","44012075","49938","49938/15043000","Television - 22" Refurbished - Airwave","Supply... (6 Replies)
Discussion started by: mlavanya
6 Replies
LEARN ABOUT SUNOS
mlib_signalautocorrel_s16
mlib_SignalAutoCorrel_S16(3MLIB) mediaLib Library Functions mlib_SignalAutoCorrel_S16(3MLIB)NAME
mlib_SignalAutoCorrel_S16, mlib_SignalAutoCorrel_S16S, mlib_SignalAutoCorrel_F32, mlib_SignalAutoCorrel_F32S - signal auto-correlation
SYNOPSIS
cc [ flag... ] file... -lmlib [ library... ]
#include <mlib.h>
mlib_status mlib_SignalAutoCorrel_S16(mlib_d64 *correl, const mlib_s16 *src, mlib_s32 disp, mlib_s32 n);
mlib_status mlib_SignalAutoCorrel_S16S(mlib_d64 *correl, const mlib_s16 *src, mlib_s32 disp, mlib_s32 n);
mlib_status mlib_SignalAutoCorrel_F32(mlib_d64 *correl, const mlib_f32 *src, mlib_s32 disp, mlib_s32 n);
mlib_status mlib_SignalAutoCorrel_F32S(mlib_d64 *correl, const mlib_f32 *src, mlib_s32 disp, mlib_s32 n);
DESCRIPTION
Each of these functions performs auto-correlation.
For monaural signals, the following equation is used:
1 n-d-1
correl[0] = ----- * SUM (src[i] * src[i + d])
n - d i=0
For stereo signals, the following equation is used:
1 n-d-1
correl[0] = ----- * SUM (src[2*i] * src[2*(i + d)])
n - d i=0
1 n-d-1
correl[1] = ----- * SUM (src[2*i + 1] * src[2*(i + d) + 1])
n - d i=0
where d = disp.
PARAMETERS
Each of the functions takes the following arguments:
correl Pointer to the auto-correlation array. In the stereo version, correl[0] contains the auto-correlation of channel 0, and
correl[1] contains the auto-correlation of channel 1.
src Source signal array.
disp Displacement. 0 <= disp < n.
n Number of samples in the source signal array.
RETURN VALUES
Each of the functions returns MLIB_SUCCESS if successful. Otherwise it returns MLIB_FAILURE.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Interface Stability |Evolving |
+-----------------------------+-----------------------------+
|MT-Level |MT-Safe |
+-----------------------------+-----------------------------+
SEE ALSO mlib_SignalCrossCorrel_S16(3MLIB), attributes(5)SunOS 5.10 10 Nov 2004 mlib_SignalAutoCorrel_S16(3MLIB)