Sponsored Content
Top Forums Shell Programming and Scripting Please do help: Perl Script to pull out rows from a CSV file Post 302414407 by pankajusc on Tuesday 20th of April 2010 04:15:09 AM
Old 04-20-2010
It works. :)

Hi Pravin,

Thanks a lot for that you.

It would be great to have the inputs i.e. 'the input CSV file', the 'HGR' 'PDR' 'DDD' 'MPG' from within the perl script instead of the command line.

I understand am asking a lot, but that was the intention since there would be atleast a 100 such inputs which I would be giving.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Simple Script needed for Processing CSV file perl

I am new to perl, and need a script to pull a CSV file, strip out 2 leading columns, and 2 ending columns, and resave the file in a new location. The file is basic and has less than 10,000 records. Secondly, can I schedule perl scripts to run daily? Can someone provide the basic script to... (1 Reply)
Discussion started by: cobbjob
1 Replies

2. Shell Programming and Scripting

Deleting rows from csv file

Hello, I am supposed to process about 100 csv files. But these files have some extra lines at the bottom of the file. these extra lines start with a header for each column and then some values below. These lines are actually a summary of the actual data and not supposed to be processed. These... (8 Replies)
Discussion started by: cobroraj
8 Replies

3. Shell Programming and Scripting

Calculate average from CSV file using PERL script

Hi All I have this csv file and I need to calculate the average of FPS. FPS:27.7420, Interval:1314184238772 FPS:25.9798, Interval:1314184242646 FPS:27.4772, Interval:1314184246311 FPS:26.1623, Interval:1314184250159 FPS:26.4515, Interval:1314184253972 FPS:31.5896, Interval:1314184257163... (24 Replies)
Discussion started by: sayachop
24 Replies

4. Shell Programming and Scripting

Perl script to get info from specific rows & columns (.xls file)

Hi all, I want to read some specific rows & columns in the .xls file with my script to get the data to be manipulated. Now, I can read the .xls file correctly & i can go to the specific sheet that I want but i have a problem to specify the specific rows & columns. I mean, I want to get the info... (0 Replies)
Discussion started by: Yohannita
0 Replies

5. Shell Programming and Scripting

Shell script to count unique rows in a CSV

HI All, I have a CSV file of 30 columns separated by ,. I want to get a count of all unique rows written to a flat file. The CSV file is around 5000 rows The first column is a time stamp and I need to exclude while counting unique Thanks, Ravi (4 Replies)
Discussion started by: Nani369
4 Replies

6. Shell Programming and Scripting

pull out rows with specific criteria

Hi, I have a file with multiple columns and for column 5 I want to extract that row into another file if it is equal to or greater than a certain value. For example: FAR 4 5 7 LOP GAT 3 3 3 POL I want values that are greater than 5 for column 4. So the final file will look like... (1 Reply)
Discussion started by: phil_heath
1 Replies

7. Shell Programming and Scripting

Bash script help - removing certain rows from .csv file

Hello Everyone, I am trying to find a way to take a .csv file with 7 columns and a ton of rows (over 600,000) and remove the entire row if the cell in forth column is blank. Just to give you a little background on why I am doing this (just in case there is an easier way), I am pulling... (3 Replies)
Discussion started by: MrTuxor
3 Replies

8. Shell Programming and Scripting

Perl script to Convert XLSX or XLS files to CSV file

Hi All, I've got in a situation where I need to convert .xlsx or .xls formatted files into simple text file or .csv file. I've found many options but doing this using PERL script is the best way I believe.I'm in AIX box. Perl code should have 2 params while running. i.e perl... (1 Reply)
Discussion started by: manab86
1 Replies

9. Shell Programming and Scripting

Perl script to modify csv file

Hi Friends, I want to convert a csv file into a ordinary .txt file. I am able to convert but I want the output to look as shown below in the .txt file table findhost= { {"xyz","abc"}, {"rxz","mmz"}, {"vrr","nnz"}, } default={"NONE"} My current perl script #!/usr/bin/env perl... (12 Replies)
Discussion started by: dbashyam
12 Replies

10. UNIX for Beginners Questions & Answers

Get duplicate rows from a csv file

How can i get the duplicates rows from a file using unix, for example i have data like a,1 b,2 c,3 d,4 a,1 c,3 e,5 i want output to be like a,1 c,3 (4 Replies)
Discussion started by: ggupta
4 Replies
libgii.conf(5)								GGI							    libgii.conf(5)

NAME
libgii.conf - LibGII configuration file format DESCRIPTION
/etc/ggi/libgii.conf is the configuration file that defines what input module are available and where libgii is supposed to find them. It consists of lines defining target locations (mapping a target name a function name) and target aliases (fake targets that actually calls other target with a specific set of parameters). The format is common to all GGI libraries. It is defined by libgg. See ggLoadConfig(3) for additional information on file inclusions and other generic options. EXAMPLES
These examples show how to use the generic configuration mechanism proposed by LibGG with LibGII. The first example defines three input modules (or targets) for which initialization function is found in three different dynamic libraries (.so files), under the default LibGII input symbol: GIIdlinit: input-stdin input/stdin.so input-x input/x.so input-xwin input/xwin.so In the second example, the two inputs are implemented in a single dynamic library, but they each have their own initialization functions in this library. Their name is separated from the path by a :. input-x input/x.so:GIIdl_x input-xwin input/x.so:GIIdl_xwin The third example defines only one real target input-x, located in shared object input/x.so under the symbol GIIdl_x. input-xwin is an alias that will resolve to target input-x with the option string -be-xwin to be passed to the target function (GIIdl_x in input/x.so). input-x input/x.so:GIIdl_x alias input-xwin input-x:-be-xwin The last examples defines two inputs, with two possible location for their implementation. The first two lines are the same as in example 2. The other two states that these two inputs can also be found (if the previous fail) as a built-in modules. The /gii-builtins path points to the LibGII built-in symbol namespace. In this case both input would be found in this namespace under the default symbol GIIdlinit. The initialization function will be given the requested target name to know which implementation to use. input-x input/x.so:GIIdl_x input-xwin input/x.so:GIIdl_xwin input-x /gii-builtins input-xwin /gii-builtins SEE ALSO
ggLoadConfig(3) libgii-1.0.x 2006-12-30 libgii.conf(5)
All times are GMT -4. The time now is 05:27 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy