Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Getting rip of multiple rows based on column1
Top Forums Shell Programming and Scripting Getting rip of multiple rows based on column1 Post 302381248 by durden_tyler on Thursday 17th of December 2009 03:10:54 PM
Old 12-17-2009
Alternatively, with Perl:

Code:
$
$ cat f0
iu  2
iu  1
iu  3
k   4
jk  3
nm 4
nm 2
$
$ ##
$ perl -F'\s+' -lane 'if ($x ne $F[0] && $x ne ""){print $y if $c==1; $c=0}
>                     $x=$F[0]; $y=$_; $c++;
>                     END {print $y if $c==1}' f0
k   4
jk  3
$
$

tyler_durden
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

extract multiple cloumns from multiple files; skip rows and include filenames; awk

Hello, I am trying to write a bash shell script that does the following: 1.Finds all *.txt files within my directory of interest 2. reads each of the files (25 files) one by one (tab-delimited format and have the same data format) 3. skips the first 10 rows of the file 4. extracts and... (4 Replies)
Discussion started by: manishabh
4 Replies

2. UNIX for Dummies Questions & Answers

Converting rows into multiple-rows

Hi every one; I have a file with 22 rows and 13 columns which includes floating numbers. I want to parse the file so that every five columns in the row would be a new record (row). For example, the first line in the old file should be converted into three lines with first two lines contain 5... (6 Replies)
Discussion started by: PHL
6 Replies

3. Shell Programming and Scripting

How to fetch rows based on line numbers or based on the beginning of a word?

I have a file which will have rows like shown below, ST*820*316054716 RMR*IV*11333331009*PO*40.31 REF*IV*22234441009*xsss471-2762 DTM*003*091016 ENT*000006 RMR*IV*2222234444*PO*239.91 REF*IV*1234445451009*LJhjlkhkj471-2762 </SPAN> DTM*003* 091016 RMR*IV*2223344441009*PO*40.31... (18 Replies)
Discussion started by: Muthuraj K
18 Replies

4. Shell Programming and Scripting

Split single rows to multiple rows ..

Hi pls help me out to short out this problem rm PAB113_011.out rm: PAB113_011.out: override protection 644 (yes/no)? n If i give y it remove the file. But i added the rm command as a part of ksh file and i tried to remove the file. Its not removing and the the file prompting as... (7 Replies)
Discussion started by: sri_aue
7 Replies

5. Shell Programming and Scripting

Combining multiple rows in single row based on certain condition using awk or sed

Hi, I'm using AIX(ksh shell). > cat temp.txt "a","b",0 "c",bc",0 "a1","b1",0 "cc","cb",1 "cc","b2",1 "bb","bc",2 I want the output as: "a","b","c","bc","a1","b1" "cc","cb","cc","b2" "bb","bc" I want to combine multiple lines into single line where third column is same. Is... (1 Reply)
Discussion started by: samuelray
1 Replies

6. UNIX for Dummies Questions & Answers

merging rows into new file based on rows and first column

I have 2 files, file01= 7 columns, row unknown (but few) file02= 7 columns, row unknown (but many) now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there e.g. file 01 James|0|50|25|10|50|30... (1 Reply)
Discussion started by: A-V
1 Replies

7. Shell Programming and Scripting

Create Multiple UNIX Files for Multiple SQL Rows output

Dear All, I am trying to write a Unix Script which fires a sql query. The output of the sql query gives multiple rows. Each row should be saved in a separate Unix File. The number of rows of sql output can be variable. I am able save all the rows in one file but in separate files. Any... (14 Replies)
Discussion started by: Rahul_Bhasin
14 Replies

8. Shell Programming and Scripting

awk to ignore multiple rows based on a condition

All, I have a text file(Inputfile.csv) with millions of rows and 100 columns. Check the sample for 2 columns below. Key,Check A,1 A,2 A, A,4 B,0 B,1 B,2 B,3 B,4 .... million rows. My requirement is to delete all the rows corresponding to all the keys which ever has at least one... (4 Replies)
Discussion started by: ks_reddy
4 Replies

9. Shell Programming and Scripting

Combine multiple rows based on selected column keys

Hello I want to collapse a file with multiple rows into consolidated lines of entries based on selected columns as the 'key'. Example: 1 2 3 Abc def ghi 1 2 3 jkl mno p qrts 6 9 0 mno def Abc 7 8 4 Abc mno mno abc 7 8 9 mno mno abc 7 8 9 mno j k So if columns 1, 2 and 3 are... (6 Replies)
Discussion started by: linuxlearner123
6 Replies

10. Shell Programming and Scripting

Splitting single row into multiple rows based on for every 10 digits of last field of the row

Hi ALL, We have requirement in a file, i have multiple rows. Example below: Input file rows 01,1,102319,0,0,70,26,U,1,331,000000113200000011920000001212 01,1,102319,0,1,80,20,U,1,241,00000059420000006021 I need my output file should be as mentioned below. Last field should split for... (4 Replies)
Discussion started by: kotra
4 Replies

LEARN ABOUT MOJAVE

perlivp

PERLIVP(1)						 Perl Programmers Reference Guide						PERLIVP(1)

NAME

       perlivp - Perl Installation Verification Procedure

SYNOPSIS

       perlivp [-p] [-v] [-h]

DESCRIPTION

       The perlivp program is set up at Perl source code build time to test the Perl version it was built under.  It can be used after running:

	   make install

       (or your platform's equivalent procedure) to verify that perl and its libraries have been installed correctly.  A correct installation is
       verified by output that looks like:

	   ok 1
	   ok 2

       etc.

OPTIONS

       -h help
	    Prints out a brief help message.

       -p print preface
	    Gives a description of each test prior to performing it.

       -v verbose
	    Gives more detailed information about each test, after it has been performed.  Note that any failed tests ought to print out some
	    extra information whether or not -v is thrown.

DIAGNOSTICS

       o   print "# Perl binary '$perlpath' does not appear executable.
";

	   Likely to occur for a perl binary that was not properly installed.  Correct by conducting a proper installation.

       o   print "# Perl version '$]' installed, expected $ivp_VERSION.
";

	   Likely to occur for a perl that was not properly installed.	Correct by conducting a proper installation.

       o   print "# Perl @INC directory '$_' does not appear to exist.
";

	   Likely to occur for a perl library tree that was not properly installed.  Correct by conducting a proper installation.

       o   print "# Needed module '$_' does not appear to be properly installed.
";

	   One of the two modules that is used by perlivp was not present in the installation.	This is a serious error since it adversely affects
	   perlivp's ability to function.  You may be able to correct this by performing a proper perl installation.

       o   print "# Required module '$_' does not appear to be properly installed.
";

	   An attempt to "eval "require $module"" failed, even though the list of extensions indicated that it should succeed.	Correct by
	   conducting a proper installation.

       o   print "# Unnecessary module 'bLuRfle' appears to be installed.
";

	   This test not coming out ok could indicate that you have in fact installed a bLuRfle.pm module or that the "eval " require
	   "$module_name.pm"; "" test may give misleading results with your installation of perl.  If yours is the latter case then please let
	   the author know.

       o   print "# file",+($#missing == 0) ? '' : 's'," missing from installation:
";

	   One or more files turned up missing according to a run of "ExtUtils::Installed -> validate()" over your installation.  Correct by
	   conducting a proper installation.

       For further information on how to conduct a proper installation consult the INSTALL file that comes with the perl source and the README
       file for your platform.

AUTHOR

       Peter Prymmer

perl v5.18.2							    2018-08-17								PERLIVP(1)
All times are GMT -4. The time now is 01:16 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy