Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Find 5 lines and replace with 18 line in sql file where it contains multiple blocks.
Top Forums Shell Programming and Scripting Find 5 lines and replace with 18 line in sql file where it contains multiple blocks. Post 302355402 by durden_tyler on Tuesday 22nd of September 2009 02:28:28 PM
Old 09-22-2009
Quote:
Originally Posted by Zaheer.mic
...
In my xyz_abc.sql file there are multiple blocks.
Just imagine there are 25 blocks in xyz_abc.sql file in that block I need to find the following block.

Code:
rem Subset Rows (&&tempName.*)
CREATE   VIEW &&tempName.* AS
SELECT   *
FROM     &&tempName.*
WHERE    EGTESTCD is not null

...
(1) Yes but how is this block different from the other 24 ? You will need this information in order to identify and replace this block correctly (out of the 25).

(2) Are all the blocks identical ? If so, which block do you want replaced ? The 1st, 2nd, 25th ? Or all ?

To give us a better idea, post a short excerpt of your target file that clearly demonstrates the difference(s) between the block of interest and the rest.

tyler_durden
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

replace multiple lines in file

Hello I am a beginner in shell script. I was trying to find a way to replace multiple lines of a file with different set of multiple line. sed -n '/begin/,/end/p' < sample1.txt >test.txt UNEDITED=`cat test.txt` vi test.txt EDITED=`cat test.txt`... (2 Replies)
Discussion started by: nox
2 Replies

2. Shell Programming and Scripting

sed find and replace multiple lines

I am new to linux and would like to modify the contents of a file preferably using a one line. The situation is as follows <start> some lines "I am the string" "replace string" more lines here <end> In the above example,On encountering "I am the string", the "replace string "should be... (6 Replies)
Discussion started by: supersimha
6 Replies

3. Shell Programming and Scripting

Single/Multiple Line with Special characters - Find & Replace in Unix Script

Hi, I am creating a script to do a find and replace single/multiple lines in a file with any number of lines. I have written a logic in a script that reads a reference file say "findrep" and populates two variables $FIND and $REPLACE print $FIND gives Hi How r $u Rahul() Note:... (0 Replies)
Discussion started by: r_sarnayak
0 Replies

4. UNIX for Dummies Questions & Answers

grep command to find multiple strings in multiple lines in a file.

I want to search files (basically .cc files) in /xx folder and subfolders. Those files (*.cc files) must contain #include "header.h" AND x() function. I am writing it another way to make it clear, I wanna list of *.cc files that have 'header.h' & 'x()'. They must have two strings, header.h... (2 Replies)
Discussion started by: ritikaSharma
2 Replies

5. Shell Programming and Scripting

replace (sed?) a single line/string in file with multiple lines (string) from another file??

Can someone tell me how I can do this? e.g: Say file1.txt contains: today is monday the 22 of NOVEMBER 2010 and file2.txt contains: the 11th month of How do i replace the word NOVEMBER with (5 Replies)
Discussion started by: tuathan
5 Replies

6. Shell Programming and Scripting

Find and replace multiple lines

I have a section of text in file A, see below # falkdjf lkjadf lkjadf lkajdf lkajdf lkajdf lkjadf lkjadf 234.234.2.234 lkjlkjlk 234.234.3.234 # Only the first line with "# falkdjf lkjadf lkjadf" is unique in the file. The new section that I want to overwrite the old section above is in... (1 Reply)
Discussion started by: jyang72211
1 Replies

7. Shell Programming and Scripting

Script to find & replace a multiple lines string across multiple php files and subdirectories

Hey guys. I know pratically 0 about Linux, so could anyone please give me instructions on how to accomplish this ? The distro is RedHat 4.1.2 and i need to find and replace a multiple lines string in several php files across subdirectories. So lets say im at root/dir1/dir2/ , when i execute... (12 Replies)
Discussion started by: spfc_dmt
12 Replies

8. Shell Programming and Scripting

sed multiple multi line blocks of text containing pattern

Hi, I have a log file which has sessionids in it, each block in the log starts with a date entry, a block may be a single line or multiple lines. I need to sed (or awk) out the lines/blocks with that start with a date and include the session id. The files are large at several Gb. My... (3 Replies)
Discussion started by: andyatit
3 Replies

9. Shell Programming and Scripting

Shell Script to find common lines and replace next line

I want to find common line in two files and replace the next line of first file with the next line of second file. (sed,awk,perl,bash any solution is welcomed ) Case Ignored. Multiple Occurrence of same line. File 1: hgacdavd sndm,ACNMSDC msgid "Rome" msgstr "" kgcksdcgfkdsb... (4 Replies)
Discussion started by: madira
4 Replies

10. Shell Programming and Scripting

Script using awk to find and replace a line, how to ignore comment lines

Hello, I have some code that works more or less. This is called by a make file to adjust some hard-coded definitions in the src code. The script generated some values by looking at some of the src files and then writes those values to specific locations in other files. The awk code is used to... (3 Replies)
Discussion started by: LMHmedchem
3 Replies

LEARN ABOUT OSF1

icheck

icheck(8)						      System Manager's Manual							 icheck(8)

NAME

       icheck - File system storage consistency check

SYNOPSIS

       /usr/sbin/icheck [-b numbers] [file system]

DESCRIPTION

       The icheck command is obsoleted for normal consistency checking by fsck.

       The  icheck  command  examines a file system, builds a bit map of used blocks, and compares this bit map against the free map maintained on
       the file system.  If the file system is not specified, a set of default file systems is checked.  The normal output of  icheck  includes  a
       report  of the following items: The total number of files and the numbers of regular, directory, block special, character special, and fifo
       files.  The total number of blocks in use and the numbers of single-, double-, and triple-indirect blocks and directory blocks.	The number
       of free blocks.	The number of blocks missing; that is, not in any file or in any free map.

       A list of block numbers follows the -b option; whenever any of the named blocks turn up in a file, a diagnostic is produced.

       The icheck command is faster if the raw version of the special file is used since it reads the i-list many blocks at a time.

NOTES

       Since  icheck is inherently two-pass in nature, extraneous diagnostics may be produced if applied to active file systems.  It believes even
       preposterous super-blocks and consequently causes a core dump.

DIAGNOSTICS

       For duplicate blocks and bad blocks which lie outside the file system, icheck announces the difficulty, the i-number, and the kind of block
       involved.  If a read error is encountered, the block number of the bad block is printed and icheck considers it to contain zero.

FILES

       Specifies the command path.

RELATED INFORMATION

       Commands:  clri(8), fsck(8), ncheck(8) delim off

																	 icheck(8)
All times are GMT -4. The time now is 11:50 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy