Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

Move a block of lines to file if string found in the block.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Move a block of lines to file if string found in the block.
# 8  
Old 11-09-2012
Thanks. It worked using nawk.
But I have a scenario where there can be spaces in the userid/name field.
Is there anyway I can include the whole word(s) to match the pattern.
example: the username(lookup file) can have data like this:
Code:
abc123
John Smith
def123

Your code is skipping the "John Smith" part and outputting the name "John Appeas" (First John in the list), which is unwanted. and not getting me the "John Smith" (one of the last John's)

Thanks
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

awk - (URGENT!) Print lines sort and move lines if match found

URGENT HELP IS NEEDED!! I am looking to move matching lines (01 - 07) from File1 and 77 tab the matching string from File2, to File3.txt. I am almost done but - Currently, script is not printing lines to File3.txt in order. - Also the matching lines are not moving out of File1.txt ... (1 Reply)
Discussion started by: High-T
1 Replies

2. Shell Programming and Scripting

Printing a block of lines from a file, if that block does not contain two patterns using sed

I want to process a file block by block using sed, and if that block does not contain two patterns, then that complete block has to be printed. See below for the example data. ................................server 1............................... running process 1 running... (8 Replies)
Discussion started by: Kesavan
8 Replies

3. Shell Programming and Scripting

Removing a block of duplicate lines from a file

Hi all, I have a file with the data 1 abc 2 123 3 ; 4 rao 5 bell 6 ; 7 call 8 abc 9 123 10 ; 11 rao 12 bell 13 ; (10 Replies)
Discussion started by: raosr020
10 Replies

4. Shell Programming and Scripting

extracting block of lines from a file

consider the input file which i am dealing with looks like this.. #cat 11.sql create table abc ( . . . ) engine=Innodb ; . . etc . . . create table UsM ( blah blah blah ) engine=Innodb ; (5 Replies)
Discussion started by: vivek d r
5 Replies

5. Linux

Find String in FileName and move the String to new File if not found

Hi all, I have a question.. Here is my requirement..I have 500 files in a path say /a/b/c I have some numbers in a file which are comma seperated...and I wanted to check if the numbers are present in the FileName in the path /a/b/c..if the number is there in the file that is fine..but if... (1 Reply)
Discussion started by: us_pokiri
1 Replies

6. Shell Programming and Scripting

Grep between block of lines in a file

Hi Friends, I have a file which has many of the statements like below ******** MAKING > noun1 < cg_all statements statements statements ********* MAKING > noun2 < cg_all statements statements statements ********* MAKING > noun3 < all statements statements statements I would... (3 Replies)
Discussion started by: ganga.dharan
3 Replies

7. Shell Programming and Scripting

Counting lines in each block file

hello im new here so i want to say hi everybody :) i have to write a script and im newbie :/ i hope that in this forum are many ppl who knows subject :) i have hundrets folders. in each folder is a file name trace.txt. each trace.txt has a lot of tracert's results separates with "-----" it... (6 Replies)
Discussion started by: michael8484
6 Replies

8. Shell Programming and Scripting

Replacing Block of lines in a text file

Dear All, Regards of the Day. I have a text file with some functions: Function1 { parameter 1 parameter 2 parameter 3 } end Function2 { parameter 1 parameter 2 parameter 3 } (1 Reply)
Discussion started by: ashisharora
1 Replies

9. Shell Programming and Scripting

Read block of lines from xml file

Hi I am new to this forum. I have few XML files and from each xml file I want to copy some specific 50 no of lines and copy them to some other file. how to do that? pls help.. (5 Replies)
Discussion started by: pritam1980
5 Replies

10. Shell Programming and Scripting

Delete a block of text delimited by blank lines when pattern is found

I have a file which contains blocks of text - each block is a multi-lines text delimited by blank lines eg. <blank line> several lines of text ... pattern found on this line several more lines of text ... <blank line> How do you delete the block of text (including the blank lines) when... (17 Replies)
Discussion started by: gleu
17 Replies
Login or Register to Ask a Question

LEARN ABOUT CENTOS

begin

BEGIN(7)						  PostgreSQL 9.2.7 Documentation						  BEGIN(7)

NAME

       BEGIN - start a transaction block

SYNOPSIS

       BEGIN [ WORK | TRANSACTION ] [ transaction_mode [, ...] ]

       where transaction_mode is one of:

	   ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }
	   READ WRITE | READ ONLY
	   [ NOT ] DEFERRABLE

DESCRIPTION

       BEGIN initiates a transaction block, that is, all statements after a BEGIN command will be executed in a single transaction until an
       explicit COMMIT(7) or ROLLBACK(7) is given. By default (without BEGIN), PostgreSQL executes transactions in "autocommit" mode, that is,
       each statement is executed in its own transaction and a commit is implicitly performed at the end of the statement (if execution was
       successful, otherwise a rollback is done).

       Statements are executed more quickly in a transaction block, because transaction start/commit requires significant CPU and disk activity.
       Execution of multiple statements inside a transaction is also useful to ensure consistency when making several related changes: other
       sessions will be unable to see the intermediate states wherein not all the related updates have been done.

       If the isolation level, read/write mode, or deferrable mode is specified, the new transaction has those characteristics, as if SET
       TRANSACTION (SET_TRANSACTION(7)) was executed.

PARAMETERS

       WORK, TRANSACTION
	   Optional key words. They have no effect.

       Refer to SET TRANSACTION (SET_TRANSACTION(7)) for information on the meaning of the other parameters to this statement.

NOTES

       START TRANSACTION (START_TRANSACTION(7)) has the same functionality as BEGIN.

       Use COMMIT(7) or ROLLBACK(7) to terminate a transaction block.

       Issuing BEGIN when already inside a transaction block will provoke a warning message. The state of the transaction is not affected. To nest
       transactions within a transaction block, use savepoints (see SAVEPOINT(7)).

       For reasons of backwards compatibility, the commas between successive transaction_modes can be omitted.

EXAMPLES

       To begin a transaction block:

	   BEGIN;

COMPATIBILITY

       BEGIN is a PostgreSQL language extension. It is equivalent to the SQL-standard command START TRANSACTION (START_TRANSACTION(7)), whose
       reference page contains additional compatibility information.

       The DEFERRABLE transaction_mode is a PostgreSQL language extension.

       Incidentally, the BEGIN key word is used for a different purpose in embedded SQL. You are advised to be careful about the transaction
       semantics when porting database applications.

SEE ALSO

       COMMIT(7), ROLLBACK(7), START TRANSACTION (START_TRANSACTION(7)), SAVEPOINT(7)

PostgreSQL 9.2.7						    2014-02-17								  BEGIN(7)