Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to awk/sed/grep lines which contains a pattern at a given position
Top Forums Shell Programming and Scripting How to awk/sed/grep lines which contains a pattern at a given position Post 302252311 by anoopvraj on Wednesday 29th of October 2008 09:01:13 AM
Old 10-29-2008
How to awk/sed/grep lines which contains a pattern at a given position
Dear friends

I am new to linux and was trying to split some files userwise in our linux server.

I have a data file of 156 continuous columns named ecscr final.

I want the script to redirect all the lines containing a pattern of 7 digits to separate files. I was using grep to do that, as below. I have written all available patterns to a file named usercode.

while read alpha
do
cat ecscrfinal | grep -e $alpha >> mkoff.$alpha
echo "Generating markoff data for $alpha"
done < /home/ftp/ecs/usercode


But I need only those lines which have the pattern occuring at 3rd column or 81st column to go to that file. In the above case if the pattern is found any wher in the line, it is redirected to that file which gives me a wrong result.

How sed/awk/grep can be used to match a pattern occuring only at a specified field.....?

The pattern should be matched only if it is occuring in 3rd position or 81st postition.

Please help me.....i am running against a deadline.........
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extracting pattern only with AWK | SED | GREP

We have the following statement working in CGYWIN, but when we move the program to Solaris 10 it fails. x=`echo "ABC196925XYZ" | grep -o --only-matching "\{6\}"` How can we use AWK or SED to extract only the number from the string? The following outputs the entire string. We only want... (5 Replies)
Discussion started by: James Clark
5 Replies

2. Shell Programming and Scripting

Remove text from n position to n position sed/awk

I want to remove text from nth position to nth position couple of times in same line my line is "hello is there anyone can help me with this question" I need like this ello is there anyone can help me with question 'h' is removed and 'this' removed from the line. I want to do this... (5 Replies)
Discussion started by: elamurugu
5 Replies

3. Shell Programming and Scripting

sed/awk : how to delete lines based on IP pattern ?

Hi, I would like to delete lines in /etc/hosts on few workstations, basically I want to delete all the lines for a list of machines like this : for HOST in $(cat stations.lst |uniq) do # echo -n "$HOST" if ping -c 1 $HOST > /dev/null 2>&1 then HOSTNAME_val=`rsh $HOST "sed... (3 Replies)
Discussion started by: albator1932
3 Replies

4. UNIX for Dummies Questions & Answers

One liner pattern search with awk/sed/grep

I have an array containing bunch of characters. I have to check this array for specific character and if "Not Found than" use a goto statement to go to USAGE set options = (A B C D E F) @ i = 0 while ($i <= ${#options}) if ($options != "F" || $options != "D") then goto USAGE endif @... (1 Reply)
Discussion started by: dixits
1 Replies

5. Shell Programming and Scripting

How to print the lines between the pattern using awk/grep/sed?

Hi, I need a help to search a pattern and print the multiple lines between them. Input file: Tue May 29 12:30:33 EDT 2012:threadWebContainer : 357:com.travimp.hotelierlinks.abba.service.RequestHandler.requestService(String, ITICSDataSet): hotelCancelReservation request: ... (4 Replies)
Discussion started by: aroragaurav.84
4 Replies

6. Shell Programming and Scripting

Getting lines before and until next pattern in file /awk, sed

Hi, I need to get specific parts in a large file. I need to: Get a line containing an IP address, and read from there to another line saying ***SNMP-END*** So, I have the start and the end well defined, but the problem is that apparently the awk command using the -F option doesn't work... (17 Replies)
Discussion started by: ocramas
17 Replies

7. Shell Programming and Scripting

Sed/awk : to grep only required pattern disk

Hi Experts, Need help with the following: Desired output: Only want to get the output marked in green. The file: --- Physical volumes --- PV Name /dev/disk/disk4704 PV Status available Total PE 6399 Free PE ... (3 Replies)
Discussion started by: rveri
3 Replies

8. Shell Programming and Scripting

sed and awk usage to grep a pattern 1 and with reference to this grep a pattern 2 and pattern 3

Hi , I have a file where i have modifed certain things compared to original file . The difference of the original file and modified file is as follows. # diff mir_lex.c.modified mir_lex.c.orig 3209c3209 < if(yy_current_buffer -> yy_is_our_buffer == 0) { --- >... (5 Replies)
Discussion started by: breezevinay
5 Replies

9. Shell Programming and Scripting

Using awk or sed to find a pattern that has lines before and after it

Dear gurus, Please help this beginner to write and understand the required script. I am looking for useing awk for sed. I have a few thousand lines file whose contain are mostly as below and I am trying to achieve followings. 1. Find a string, say user1. Then hash the line containing the... (6 Replies)
Discussion started by: ran_bon_78
6 Replies

10. UNIX for Beginners Questions & Answers

Sed/awk join lines once pattern found

Hi all OS - RHEL6.4 I have input file -f1.txt I need to search line which starts with \Start and read next line till it gets blank line and join them all. I need to trim any trailing spaces for each line.So output.txt should be.. \Start\now\fine stepwatch this space for toolsends... (7 Replies)
Discussion started by: krsnadasa
7 Replies

LEARN ABOUT SUNOS

fgrep

fgrep(1)							   User Commands							  fgrep(1)

NAME

       fgrep - search a file for a fixed-character string

SYNOPSIS

       /usr/bin/fgrep [-bchilnsvx] [-e pattern_list] [-f pattern-file] [pattern] [file...]

       /usr/xpg4/bin/fgrep [-bchilnsvx] [-e pattern_list] [-f pattern-file] [pattern] [file...]

DESCRIPTION

       The  fgrep (fast grep) utility searches files for a character string and prints all lines that contain that string. fgrep is different from
       grep(1) and from egrep(1) because it searches for a string, instead of searching for a pattern that matches an  expression.  fgrep  uses  a
       fast and compact algorithm.

       The characters $, *, [, ^, |, (, ), and  are interpreted literally by fgrep, that is, fgrep does not recognize full regular expressions as
       does egrep. These characters have special meaning to the shell. Therefore, to be safe, enclose the entire string within single quotes (').

       If no files are specified, fgrep assumes standard input. Normally, each line that is found is copied to the standard output. The file  name
       is printed before each line that is found if there is more than one input file.

OPTIONS

       The following options are supported:

       -b	       Precedes  each  line  by the block number on which the line was found. This can be useful in locating block numbers by con-
		       text. The first block is 0.

       -c	       Prints only a count of the lines that contain the pattern.

       -e pattern_list Searches for a string in pattern-list. This is useful when the string begins with a -.

       -f pattern-file Takes the list of patterns from pattern-file.

       -h	       Suppresses printing of files when searching multiple files.

       -i	       Ignores upper/lower case distinction during comparisons.

       -l	       Prints the names of files with matching lines once, separated by new-lines. Does not repeat the names  of  files  when  the
		       pattern is found more than once.

       -n	       Precedes each line by its line number in the file. The first line is 1.

       -s	       Works silently, that is, displays nothing except error messages. This is useful for checking the error status.

       -v	       Prints all lines except those that contain the pattern.

       -x	       Prints only lines that are matched entirely.

OPERANDS

       The following operands are supported:

       file	       Specifies a path name of a file to be searched for the patterns. If no file operands are specified, the standard input will
		       be used.

   /usr/bin/fgrep
       pattern	       Specifies a pattern to be used during the search for input.

   /usr/xpg4/bin/fgrep
       pattern	       Specifies one or more patterns to be used during the search for input. This operand is treated as if it were  specified	as
		       -e pattern_list.

USAGE

       See largefile(5) for the description of the behavior of fgrep when encountering files greater than or equal to 2 Gbyte ( 2**31 bytes).

ENVIRONMENT VARIABLES

       See  environ(5)	for  descriptions of the following environment variables that affect the execution of fgrep: LC_COLLATE, LC_CTYPE, LC_MES-
       SAGES, and NLSPATH.

EXIT STATUS

       The following exit values are returned:

       0	If any matches are found

       1	If no matches are found

       2	For syntax errors or inaccessible files, even if matches were found.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

   /usr/bin/fgrep
       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+

   /usr/xpg4/bin/fgrep
       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWxcu4			   |
       +-----------------------------+-----------------------------+
       |CSI			     |Enabled			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       ed(1), egrep(1), grep(1), sed(1), sh(1), attributes(5), environ(5), largefile(5), XPG4(5)

NOTES

       Ideally, there should be only one grep command, but there is not a single algorithm that spans a wide enough range of space-time tradeoffs.

       Lines are limited only by the size of the available virtual memory.

   /usr/xpg4/bin/fgrep
       The /usr/xpg4/bin/fgrep utility is identical to /usr/xpg4/bin/grep -F (see grep(1)). Portable applications  should  use	/usr/xpg4/bin/grep
       -F.

SunOS 5.10							    4 Oct 2002								  fgrep(1)
All times are GMT -4. The time now is 06:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy