Pattern matching and format problem


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Pattern matching and format problem
# 1  
Old 07-05-2012
Pattern matching and format problem

Hi I need a bash script that can search through a text file and when it finds 'FSS1206' I need to put a Letter F 100 spaces after the second instance of FSS1206

The format is the same throughout the file I need to repeat this on every time it finds the second 'FSS1206' in the file

I have really not explained this very well but see example below, I need an F at that position. Smilie

or would it be easier to search for "71502FSS1206 FSS1206" and put a F 100 spaces after this rather than just search for a single instance of FSS1206?


Code:
71502FSS1206               FSS1206               000000000000200100000000000820009958170009958181200100005952

Code:
71502FSS1206               FSS1206               000000000000200100000000000820009958170009958181200100005952                       F

# 2  
Old 07-05-2012
From the description I am not sure, if you mean a 2nd occurence in the same line or another line.
If it is meant per line, something like this might work:
Code:
$> cat infile
aa  FSS1206 vv
bb  something
aa  FSS1206 vv
aa  FSS1206 vv
completeley different
aa  FSS1206 vv
it seems
aa  FSS1206 vv
$ awk 'f && /FSS1206/ {print NR,$0,"F"; f=0; next} /FSS1206/ {f=1}' infile
3 aa  FSS1206 vv F
6 aa  FSS1206 vv F

The example input file is shorter so you can adjust the output of "F" with printf for example. I added NR to print the line number.
It will recognize every 2nd line that matches the pattern.

If it is meant per line, you can try this:
Code:
$ cat infile
aa  FSS1206 vv iquwegh2pg3FSS6uagwf777
aa  FSS1206 vv iquwegh2pg3FSS1206uagwf777
aa  FSS1206 vv iquwegh2pg3FSS1206uagwf777FSS1206
$ awk -F"FSS1206" 'NF==3 {print $0, "     F"; next} {print}' infile
aa  FSS1206 vv iquwegh2pg3FSS1206uagwf777

You can exeriment with printf for the "F" here too.

Last edited by zaxxon; 07-05-2012 at 10:28 AM.. Reason: modified 2nd line
# 3  
Old 07-05-2012
Try:
Code:
awk '$2=="FSS1206"{$0=$0"                       F"}1' infile > outfile

# 4  
Old 07-05-2012
Quote:
Originally Posted by zaxxon
From the description I am not sure, if you mean a 2nd occurence in the same line or another line.

sorry for not explaining better, there are multiple instances FSS1206.

Would it be easier searching for
Code:
71502FSS1206               FSS1206

and place a letter F 100 spaces after every occurrence found within the file

Is this possible?


Quote:
Originally Posted by bartus11
Try:
Code:
awk '$2=="FSS1206"{$0=$0"                       F"}1' infile > outfile

This didn't appear to do anything.

Thanks for all the help its appreciated.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Pattern matching problem

if i have to do pattern match for file name with digit alphanumeric value like this File_1234.csv File_12sd45rg.csv i am using this File_*.csv and File_*.csv for digit pattern match. when i am doing pattern match for the digit then both alphanumeric match and digit match is coming. ... (3 Replies)
Discussion started by: ramsavi
3 Replies

2. Shell Programming and Scripting

Pattern matching problem

Hi I need a bash script that can search through a text file for all lines starting with 71502FSC1206 on every line it finds starting with this I need to place a letter F at the 127 position on that line. Thanks Paul (6 Replies)
Discussion started by: firefox2k2
6 Replies

3. Programming

pl sql . pattern matching problem

hi everyone i am facing a strange problem declare v_var number(10); begin if( regexp_like('RCDORMS_MMS_*_DAR','RCDORMS_MMS_*_DAR')) then v_var:=20; dbms_output.put_line(v_var); end if; end; / please tell me what's the wrong thing in this expression.. as i am not able to get... (1 Reply)
Discussion started by: aishsimplesweet
1 Replies

4. Shell Programming and Scripting

pattern matching problem

# cat email.txt | grep -i "To:" To: <test@example.com> # cat email.txt | grep -i "Subject" Subject: Test Subject: How are you. I need to print only test@example.com from To field need to eliminate "< & >" from To field and need to print entire subject after Subject: It should be #... (7 Replies)
Discussion started by: mirfan
7 Replies

5. Shell Programming and Scripting

Problem extracting just a part of a matching pattern

Hello everyone, this is my first post so please give me a hand. I apologize for my English, I'll try to be clear with my request. I need to write a script (Bash) which finds all the variables defined in the file .h of the folder and then writes the name of the files .c where these variables are... (1 Reply)
Discussion started by: paxilpaz
1 Replies

6. Shell Programming and Scripting

problem using sed for pattern matching

if abc.sh is 192.168.1.41 then the output that i get is v5c01 my code is sed 's/192.168.1.4/v5c0/g s/192.168.1.41/acc1/g' abc.sh 2>&1 | tee abc.sh i want to find 192.168.1.4 and replace it with v5c0 and find 192.168.1.41 and replace it with acc1 and i want to do it using sed (5 Replies)
Discussion started by: lassimanji
5 Replies

7. Shell Programming and Scripting

Pattern Matching problem in UNIX

Hello All, I need help I have a problem in searching the pattern in a file let us say the file contains the below lines line 1 USING *'/FILE/FOLDER/RETURN') ................. ................. line 4 USING *'/FILE/FOLDER/6kdat1') line 5 USING... (2 Replies)
Discussion started by: maxmave
2 Replies

8. Shell Programming and Scripting

pattern matching problem

FilesToBackup='*.track* *.xml *.vm* *.gz Trace* TRACE* "*core*" *.out fcif_data_* esi_error_* *.rollback *.sed R.* APStatus_* log* *.output* send_mail* downenv* check_env* intaspurge_db_* sqlnet.log *.rpt *.html *.csv "*TSC*"' and i am using it like this- echo Moving files from $(pwd): ... (2 Replies)
Discussion started by: namishtiwari
2 Replies

9. Shell Programming and Scripting

problem with CASE pattern matching

I am using ksh on a HP Ux. I have a simple script but am having problem with the case statement:- #!/usr/bin/sh Chl=”SM.APPLE_SWIFT_DV” LoConfirm=”” case $chl in ) LoConfirm=”Using channel at Building 1” echo “test conditon1” echo $LoConfirm;; ) LoConfirm=”Using... (2 Replies)
Discussion started by: gummysweets
2 Replies

10. Shell Programming and Scripting

pattern matching problem

I have a file with the following contents; NEW 85174 MP081 /29OCT07 CNL 85986 MP098 /28OCT07 NEW 86014 MP098 /28OCT07 NEW 86051 MP097 /27OCT07 CNL 86084 MP097 /27OCT07 Now I have to retrieve all lines that start with NEW and where the next line starts with CNL and where the MP codes are... (8 Replies)
Discussion started by: rein
8 Replies
Login or Register to Ask a Question