Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Find and Remove rows
Top Forums Shell Programming and Scripting Find and Remove rows Post 302600611 by Shanks on Tuesday 21st of February 2012 02:33:38 PM
Old 02-21-2012
Find and Remove rows
Code:
*******************************************
* ROW *
*******************************************
CODE:CODE1
FILE: FILE1
FIELD: FIELD1
KEY: KEY1
ORA-00001: unique constraint (ETL.KEY_PK) violated
*******************************************
* ROW *
*******************************************
CODE:CODE2
FILE: FILE2
FIELD: FIELD2
KEY: KEY2
ORA-00001: unique constraint (ETL.KEY_PK) violated


All I need is those 4 rows code,file,filed,key , what it the best way to delete the remaining like ******, *ROW ,
Objective , once I have only those fields, I have use excel and transpose to Columns from rows.
Thanks In Advance,
- S
Last edited by joeyg; 02-21-2012 at 04:31 PM.. Reason: Please wrap examples in CodeTags; not lots of font formatting
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

remove header and footer rows

I would like to remove some lines from begining of file (header) and some lines from end of file (footer). The header/footer lines generated by web-browser when the user upload a file to my webserver. Example: -----------------------------7d62af20c052c Content-Disposition: form-data;... (2 Replies)
Discussion started by: seaky
2 Replies

2. UNIX for Dummies Questions & Answers

find and remove rows from file where multi occurrences of character found

I have a '~' delimited file of 6 - 7 million rows. Each row should contain 13 columns delimited by 12 ~'s. Where there are 13 tildes, the row needs to be removed. Each row contains alphanumeric data and occasionally a ~ ends up in a descriptive field and therefore acts as a delimiter, resulting in... (1 Reply)
Discussion started by: kpd
1 Replies

3. UNIX for Dummies Questions & Answers

Remove rows from file

Hi to all,this is my first post here. I've a file as name 89 78 09 67 othername how I can remove the word name and othername from this file, and an eventually blank row in it?Thanks in advance. (2 Replies)
Discussion started by: cv313x
2 Replies

4. Shell Programming and Scripting

Remove 1st two rows and last 2 rows

Hi All, I need to remove 1st 2 line from head and last 2 line from last. I thought it would be possible by using the Head and tail command. But after i am using it is not possible by it. Example:Input file 1 2 3 4 5 Example: Output file 3 But my head and tail command are not... (12 Replies)
Discussion started by: kam786sim
12 Replies

5. Shell Programming and Scripting

Remove comma and next rows beginning from the end

Hello friends, I have a file which consists of many rows, I use a couple of commands to convert it so i can use in a database query for filtering. I need the first columns (msisdns) in a row, seperated with commas, 9855162267,4,5,2010-11-03 17:02:07.627 9594567938f,5,5,2010-11-02... (9 Replies)
Discussion started by: EAGL€
9 Replies

6. Shell Programming and Scripting

Remove Blank Rows

Hello All, I am having a problem in automating my UNIX Script to remove the blank spaces in between records. When I incorporate it into my script, the output file is deleting the whole content :confused: Basically this is what I am trying to do: File contains data like this:... (14 Replies)
Discussion started by: Vinsanity
14 Replies

7. Shell Programming and Scripting

remove consecutive duplicate rows

I have some data that looks like, 1 3300665.mol 3300665 5177008 102.093 2 3300665.mol 3300665 5177008 102.093 3 3294015.mol 3294015 5131552 102.114 4 3294015.mol 3294015 5131552 102.114 5 3293734.mol 3293734 5129625 104.152 6 3293734.mol ... (13 Replies)
Discussion started by: LMHmedchem
13 Replies

8. Shell Programming and Scripting

Remove rows with e column values

Hi All, I have a big file with 232 columns and 9 million rows, I want to delete all rows with same column values in col3 through col232. Also the output should be sorted based on first 2 columns. Here is a reduced example with 6 columns. I want to remove rows with duplicate values in col3... (9 Replies)
Discussion started by: alpesh
9 Replies

9. Shell Programming and Scripting

Remove rows containing commas with awk

Hello everyone, I have a dataset that looks something like: 1 3 2 2 3 4,5 4 3:9 5 5,9 6 5:6 I need to remove the rows that contain a comma in the second column and I'm not sure how to go about this. Here is an attempt. awk 'BEGIN {FS=" "} { if ($2!==,) print }'Any help is appreciated. (5 Replies)
Discussion started by: Rabu
5 Replies

10. UNIX for Beginners Questions & Answers

How to remove matched rows from my file?

Hello, I am new beginner, and just got help from this forum. The command line is :awk '($1, $2) in x { print x print delete x next } { x = $0 }' results>myfileI got a output "myfile" from the orginal file 'results'. The quesion is I don't know how to get all rows... (7 Replies)
Discussion started by: nengcheng
7 Replies

LEARN ABOUT DEBIAN

seqdiag

SEQDIAG(1)						      General Commands Manual							SEQDIAG(1)

NAME

       seqdiag - generate sequence-diagram image file from spec-text file.

SYNOPSIS

       seqdiag [options] file

DESCRIPTION

       This manual page documents briefly the seqdiag commands.

       seqdiag is generate sequence-diagram image file from spec-text file.

OPTIONS

       These  programs	follow	the  usual  GNU  command  line	syntax, with long options starting with two dashes (`-').  A summary of options is
       included below.	For a complete description, see the Info files.

       --version
	      show program's version number and exit

       -h, --help
	      show this help message and exit

       -a, --antialias
	      Pass diagram image to anti-alias filter

       -c FILE, --config=FILE
	      read configurations from FILE

       -o FILE
	      write diagram to FILE

       -f FONT, --font=FONT
	      use FONT to draw diagram

       -T TYPE
	      Output diagram as TYPE format

SEE ALSO


       The programs are documented fully by
       http://tk0miya.bitbucket.org/seqdiag/build/html/index.html

AUTHOR

       seqdiag was written by Takeshi Komiya <i.tkomiya@gmail.com>

       This manual page was written by Kouhei Maeda <mkouhei@palmtb.net>, for the Debian project (and may be used by others).

								   May 21, 2011 							SEQDIAG(1)
All times are GMT -4. The time now is 03:13 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy