Replace a multi-line strings or numbers


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Replace a multi-line strings or numbers
# 1  
Old 05-20-2013
Replace a multi-line strings or numbers

Hi

I have no experience in Unix so any help would be appreciated


I have the flowing text
Code:
235543
123
45654
199
225
578
45654
199
225

I need to find this sequence from A file
Code:
45654
199
225

and replaced it with in B file
Code:
45654
258

so the new file B will be
Code:
235543
123
45654
258
578
45654
258

any help?

Last edited by Scott; 05-20-2013 at 04:29 PM.. Reason: Please use code tags for code and data samples
# 2  
Old 05-20-2013
Here is a solution using awk:
Code:
awk '
        {
                A[++c] = $1
        }
        END {
                for ( i = 1; i <= c; i++ )
                {
                        if ( A[i] == 45654 && A[i+1] == 199 && A[i+2] == 225 )
                        {
                                A[i+1] = 258
                                A[i+2] = 0
                        }
                        if ( A[i] )
                                print A[i]
                }
        }
' file

This User Gave Thanks to Yoda For This Post:
# 3  
Old 05-20-2013
Thanks Yoda

but what if I want to search for a variable sequence instead of known. for example
Code:
"variable number" 
199
225

will be
Code:
"variable number" 
258

Thanks

Last edited by Scott; 05-20-2013 at 04:30 PM.. Reason: Code tags
# 4  
Old 05-20-2013
Quote:
Originally Posted by khaled79
but what if I want to search for a variable sequence instead of known.
I didn't quite understand what you mean by variable sequence.

The program that I posted replaces 45654 199 225 to 45654 258

You just have to modify it as per your requirement.
This User Gave Thanks to Yoda For This Post:
# 5  
Old 05-20-2013
Thanx again Yoda

sorry for being not clear

what I meant was


what if I want to find sequence that followed by "xxx"
Code:
XXX
199
225

and replace it with
Code:
XXX
258


xxx could be any number between (1 to 260)

so, every time replace all the sequence followed by that XXX

Thank you
# 6  
Old 05-20-2013
So I assume that you are going to define starting sequence in a variable.

In that case you can pass whatever variable to awk, assign it and use it.

You can code something like:
Code:
SEQ=XXX

awk -v S="$SEQ" '
        {
                A[++c] = $1
        }
        END {
                for ( i = 1; i <= c; i++ )
                {
                        if ( A[i] == S && A[i+1] == 199 && A[i+2] == 225 )
                        {
                                A[i+1] = 258
                                A[i+2] = 0
                        }
                        if ( A[i] )
                                print A[i]
                }
        }
' file

I used shell variable: SEQ, replace value XXX with the number of your choice. I hope this helps.
# 7  
Old 05-20-2013
Khaled79,
Check this out:
Code:
# v=45654;perl -0777  -pe 's/$ENV{v}\n199\n225/$ENV{v}\n258/igs' file


Code:
235543
123
45654
258
578
45654
258

This User Gave Thanks to rveri For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Multi line regex for search and replace

I have text file like below: a.txt Server=abc Run=1 Time=120.123 Tables=10 Sessions=16 Time=380.123 Version=1.1 Jobs=5 Server=abc Run=2 Time=160.123 Tables=15 Sessions=16 Time=400.258 Version=2.0 (1 Reply)
Discussion started by: sol_nov
1 Replies

2. Homework & Coursework Questions

[solved]Perl: Printing line numbers to matched strings and hashes.

Florida State University, Tallahassee, FL, USA, Dr. Whalley, COP4342 Unix Tools. This program takes much of my previous assignment but adds the functionality of printing the concatenated line numbers found within the input. Sample input from <> operator: Hello World This is hello a sample... (2 Replies)
Discussion started by: D2K
2 Replies

3. Shell Programming and Scripting

sed to replace a line with multi lines from a var

I am trying to find a line in a file ("Replace_Flag") and replace it with a variable which hold a multi lined file. myVar=`cat myfile` sed -e 's/Replace_Flag/'$myVar'/' /pathto/test.file myfile: cat dog boy girl mouse house test.file: football hockey Replace_Flag baseball ... (4 Replies)
Discussion started by: bblondin
4 Replies

4. Shell Programming and Scripting

SED - insert space at the beginning of line and multi replace command

hi I am trying to use SED to replace the line matching a pattern using the command sed 'pattern c\ new line ' <file1 >file 2 I got two questions 1. how do I insert a blank space at the beginning of new line? 2. how do I use this command to execute multiple command using the -e... (5 Replies)
Discussion started by: piynik
5 Replies

5. Shell Programming and Scripting

Multi-line filtering based on multi-line pattern in a file

I have a file with data records separated by multiple equals signs, as below. ========== RECORD 1 ========== RECORD 2 DATA LINE ========== RECORD 3 ========== RECORD 4 DATA LINE ========== RECORD 5 DATA LINE ========== I need to filter out all data from this file where the... (2 Replies)
Discussion started by: Finja
2 Replies

6. Shell Programming and Scripting

Search for a multi-line strings in a file

Hello I need to search for a mult-line strngs(with spaces in between and qoted) in a file1 and replace that text with Fixed string globally in file1. The strng to search for is in file2. The file is big with some 20K records. so speed and effciency is required file1: (where srch & rplc will... (7 Replies)
Discussion started by: Hiano
7 Replies

7. Shell Programming and Scripting

Global search and replace multi line file

Hello I need to search for a mult-line strngs(with spaces in between and qoted) in a file1 and replace that text with Fixed string globally in file1. The strng to search for is in file2. The file is big with some 20K records. so speed and effciency is required file1: (where srch & rplc... (0 Replies)
Discussion started by: Hiano
0 Replies

8. Shell Programming and Scripting

Multi-Line Search and Replace

There appears to be several threads that touch on what I'm trying to do, but nothing quite generic enough. What I need to do is search through many (poorly coded) HTML files and make changes. The catch is that my search string may be on one line or may be on several lines. For example there... (5 Replies)
Discussion started by: bisbell
5 Replies

9. Shell Programming and Scripting

multi line multirecord find and replace

Hello I am looking to have a script that performs some tasks for find and replace and inserts a line as well. I have done some programming 10 years ago, so it is causing me a little grief. File consists of 2500 records. I will show you a sample consisting of two records below and what needs... (3 Replies)
Discussion started by: cdc01
3 Replies

10. Shell Programming and Scripting

Search and replace multi-line text in files

Hello I need to search for a mult-line text in a file exfile1 and replace that text with another text. The text to search for is in exfile2 and the replacement text is in exfile3. I work with kornshell under AIX and need to do this with a lot of files. (the file type is postscript and they need... (10 Replies)
Discussion started by: marz
10 Replies
Login or Register to Ask a Question