Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Shell script to populate an array from a csv file
Top Forums Shell Programming and Scripting Shell script to populate an array from a csv file Post 302597213 by jimbob01 on Thursday 9th of February 2012 04:00:16 PM
Old 02-09-2012
Shell script to populate an array from a csv file
Hi Guys,

I've got a script that runs and collects statistics from one of our machines and outputs the data into a csv file. Now, that script runs fine and I managed to create another one (with a lot of help from this forum!!) to trim the csv file down to all the data that I need, rather than all the data it collects.

Anyway, I'm now trying to write a script to import this data from the csv file into Nagios so it can report the statistics. The easiest way I've heard of to do this is to create a script which involves populating an array from the csv file and then passing the contents of the array into Nagios (I can modify an existing script for that).

My knowledge on scripting is a bit limited and I certainly haven't created one involving passing a csv file into an array!! Does anyone have any pointers on how this can be done ? This is an example of the data in the csv file:
Code:
startup timestamp,1327702381482
cpu combined,0.0900
cpu idle,0.9100
cpu nice,0.0000
cpu sys,0.0360
cpu user,0.0540
cpu wait,0.0010
memory free,4415.501335 MB
memory max,4494.937500 MB
memory used,79.436165 MB

As you can see, there isn't a lot of data to insert into the array and I could possibly do without the first column as I can enter this in the Nagios script. Or, does anyone think there is a better way of doing this !?

Thanks for any help!

Cheers, Jim
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

using the getline to populate an array from a file

Hello, I am trying to use the awk getline command to populate an array from a flat file. Has anyone done this before? So we have file1: a b c d I want to create an array like index that contains these four elements (8 Replies)
Discussion started by: penfold
8 Replies

2. Shell Programming and Scripting

Modifying a csv file from Shell Script

Hi all, I have some script that creates a temp csv file. What I need to do is do some search and replace and modify the file from my shell script. I know the commands to open the file and then apply the reg ex but wasnt sure how I could do this from a script and modify the file? Any help... (2 Replies)
Discussion started by: not4google
2 Replies

3. UNIX for Advanced & Expert Users

format csv file using shell script

i have a report.csv file from oracle datavase In that file data is like this with report heading and date SALES DAILY REPORT DATE: 06-26-2007 REPORT NAME: SALES DATA AA.BB.CCCC.DDDD,BBBBB,06-26-2007,0,BEGIN,END ZZ.VV.DDDD.XXXXXXX,MMMMMM,06-25-2007,18,BEGIN,END... (3 Replies)
Discussion started by: raosurya
3 Replies

4. Shell Programming and Scripting

how to create csv file using shell script

I have a file in multiple directory which has some records in the following format File: a/latest.txt , b/latest.txt, c/latest.txt -> Name=Jhon Age=27 Gender=M Street=LA Road Occupation=Service I want to generate a csv file from the above file as follows File: output.csv -> ... (9 Replies)
Discussion started by: rjk2504
9 Replies

5. Shell Programming and Scripting

populate specified value in csv

Hi, I've requirement of populating two blank column ( 4rth and 6th ) in a csv file with specified value for all the rows having value within the first colmn. I know it can be done with sed, as given in the below command, but i am not sure how pull blank value or specify target column etc or... (11 Replies)
Discussion started by: john_prince
11 Replies

6. Shell Programming and Scripting

Using eval to populate an array in the background

Hi. I am trying to populate an array using eval in the background within a function. So this function will create a list of 3 character directories from SVN and store in an array. I want to call this function when the script starts in the background unknown to the user. The problem is that... (2 Replies)
Discussion started by: jmiaebrown
2 Replies

7. UNIX for Dummies Questions & Answers

Help to parse csv file with shell script

Hello ! I am very aware that this is not the first time this question is asked here, because I have already read a lot of previous answers, but none of them worked, so... As said in the title, I want to read a csv file with a bash script. Here is a sample of the file: ... (4 Replies)
Discussion started by: Grhyll
4 Replies

8. Shell Programming and Scripting

Reading a csv file using shell script

Hello All, I have a csv file that looks like below ProdId_A,3.3.3,some text,some/text,sometext_1.2.3 ProdId_B,3.3.3,some text,some/text,sometext_1.2.3 ProdId_C,3.3.3,some text,some/text,sometext_1.2.3 ProdId_A,6.6.6,some text,some/text,sometext_9.9.9 I will get ProdId from... (5 Replies)
Discussion started by: anand.shah
5 Replies

9. Shell Programming and Scripting

CSV File Creation Within Shell Script

Hi All, I am trying to create a CSV file within a shell script test.ksh and the code snippet is something like below: #!/usr/bin/ksh # Set required variables. . $HOME/.prof # Output file path Group1=/tmp/G1.csv Group2=/tmp/G2.csv Group3=/tmp/G3.csv $ORACLE_HOME/bin/sqlplus -s... (2 Replies)
Discussion started by: swasid
2 Replies

10. Shell Programming and Scripting

Help with Shell Scrip in Masking particular columns in .csv file or .txt file using shell script

Hello Unix Shell Script Experts, I have a script that would mask the columns in .csv file or .txt file. First the script will untar the .zip files from Archive folder and processes into work folder and finally pushes the masked .csv files into Feed folder. Two parameters are passed ... (5 Replies)
Discussion started by: Mahesh G
5 Replies

LEARN ABOUT DEBIAN

ipescript

IPESCRIPT(1)						      General Commands Manual						      IPESCRIPT(1)

NAME

       ipescript - Run an Ipe script (written in Lua)

SYNOPSIS

       ipescript script { arguments }

DESCRIPTION

       ipescript  runs	an Ipe script written in Lua.  The Ipe bindings are automatically available in the script.  Ipescript looks for the script
       in any of the script directories.

       The script argument should not contain the .lua extension.

ENVIRONMENT VARIABLES

       ipescript respects the following environment variables:

       IPELATEXDIR
	      the directory where ipetoipe runs Pdflatex.

       IPESCRIPTS a list of directories where Ipescript will look for
	      scripts.	When this variable is not set, Ipe searches first the current directory, then ~/.ipe/scripts, and finally the  system-wide
	      Ipe script directory.  When this variable is set, it should contain a list of directories, separated by semicolons.  A single under-
	      score is replaced by the system-wide Ipe script directory.

       IPEDEBUG
	      set this to 1 for debugging output from ipescript.

AUTHOR

       Otfried Cheong

REPORTING BUGS

       Please report bugs using Ipe bugzilla at http://ipe7.sourceforge.net/bugzilla.html

SEE ALSO

       Ipe is documented fully in The Ipe Manual, which is available online at http://ipe7.sourceforge.net/manual/manual.html .

								  August 28, 2011						      IPESCRIPT(1)
All times are GMT -4. The time now is 06:11 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy