Include information in certain columns using grep and awk Post: 302915473

Sponsored Content

Top Forums Shell Programming and Scripting Include information in certain columns using grep and awk Post 302915473 by owwow14 on Wednesday 3rd of September 2014 09:19:24 AM

09-03-2014

Registered User

Include information in certain columns using grep and awk

HI all,
I have data in a file that looks like this:

Code:

1       HOW     _       NNP     NNP     _       3       nn      _       _
2       DRUGS   _       NNP     NNP     _       3       nn      _       _
3       ACT     _       NNP     NNP     _       0       null    _       _
4       :       _       :       :       _       3       punct   _       _
5       GENERAL _       NNP     NNP     _       7       nn      _       _
6       PRINCIPLES      _       NNPS    NNPS    _       7       nn      _      _
7       Pharmacology    _       NNP     NNP     _       10      nsubjpass      __
8       can     _       MD      MD      _       10      aux     _       _
9       be      _       VB      VB      _       10      auxpass _       _
10      defined _       VBN     VBN     _       3       parataxis       _      _

I need to use 'awk' to include some information in the second column of those lines which have 'N*' in the 4th column.
Is there an easy 'grep' that will allow me to do this?

The desired result is the following:

Code:

1       HOW-x-     _       NNP     NNP     _       3       nn      _       _
2       DRUGS-x-   _       NNP     NNP     _       3       nn      _       _
3       ACT-x-     _       NNP     NNP     _       0       null    _       _
4       :       _       :       :       _       3       punct   _       _
5       GENERAL-x- _       NNP     NNP     _       7       nn      _       _
6       PRINCIPLES-x-      _       NNPS    NNPS    _       7       nn      _      _
7       Pharmacology-x-    _       NNP     NNP     _       10      nsubjpass      __
8       can     _       MD      MD      _       10      aux     _       _
9       be      _       VB      VB      _       10      auxpass _       _
10      defined _       VBN     VBN     _       3       parataxis       _     _

Thank you in advance for assitance.

Last edited by owwow14; 09-03-2014 at 10:42 AM..

owwow14

View Public Profile for owwow14

Find all posts by owwow14

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk / grep / Prints all columns except the first one

I have the a file with the following data. File Content. 1249 snf06.3.0 sw version 1.1 code MD5 192F MD4 MD3 1248 sns06.3.0 sw version 1.1 code MD5 192F MD12 1250 sns06.3.0 sw version 1.1 code MD5 192F0\ MD8 1241 sns06.3.0 sw code MD5 19 1243 sn06.3.0 sw version 1.1 code MD5 19 12...

2. UNIX for Dummies Questions & Answers

why does tar sometimes include directory information?

hi, say I have dirA/file1 dirB/file2 and I tar them up, and then do zcat Tar.tar | tar tvf - Sometimes I will see: dirA/ dirA/file1 dirB/ dirB/file2 yet other times I will see

3. Shell Programming and Scripting

Display output as columns using grep/awk/sed

I have several files with say something like cat sparrow I can grep for "cat" and "sparrow" and usually the output is one below the other cat sparrow How can I view these as columns say Pets Birds cat sparrow Would be great if this can be on command line using awk or...

4. Shell Programming and Scripting

awk (gawk) grep & columns

Hi, I'm working with gawk (on DOS) today. A goal is: find a string for-instance '123', cut a line in two columns and write second one. The problem is: command line works OK, awk file doesn't. But I would like to work with file because there are many strings to find. input: line command: awk...

5. Shell Programming and Scripting

grep/awk to only print lines with two columns in a file

Hey, Need some help for command to print only lines with two columns in a file abc 111 cde 222 fgh ijk 2 klm 12 23 nop want the ouput to be abc 111 cde 222 ijk 2 Thanks a lot in advance!!!

6. Shell Programming and Scripting

copying file information using awk & grep

Hi, TASK 1: I have been using this code to print the information of files kept at "/castor/cern.ch/user/s/sudha/forPooja" in some text file name FILE.txt. rfdir /castor/cern.ch/user/s/sudha/forPooja | grep data | awk '{print "rfio:///castor/cern.ch/user/s/sudha/forPooja/"$9}' > FILE.txt ...

7. Shell Programming and Scripting

Need to include two more columns in the file using awk

Hi, I have a input file with many records as below: 1J4RR4GG0BC508200 68646 1 N M i want my output file to be like with columns included dgismdh and timestamp : Example: 1J4RR4GG0BC508200 68646 1 N M dgismdh 2012-02-21 07:22:25.98591 How to do it.can we do using awk? Pls help.

8. Shell Programming and Scripting

Use less pipe for grep or awk sed to print the line not include xx yy zz

cat file |grep -v "xx" | grep -v "yy" |grep -v "zz"

9. Shell Programming and Scripting

Include information and change column order while maintaing white spaces

I need to change the order of the columns of data that looks like this: The original data is in 6 tab-separated columns. FACTSHEET factsheet NN 1 5 DEP WHAT what WP 2 3 SBJ IS be VBZ 3 1 NMOD AIDS AIDS NP ...

10. Shell Programming and Scripting

sed / awk / grep to extract information from log

Hi all, I have a query that runs that outputs data in the following format - 01/09/12 11:43:40,ADMIN,4,77,Application Group Load: Name(TESTED) LoadId(5137-1-0-1XX-15343-15343) File(/dir/dir/File.T03.CI2.RYR.2012009.11433350806.ARD) InputSize(5344) OutputSize(1359) Rows(2) Time(1.9960)...

LEARN ABOUT FREEBSD

tabs

TABS(1) 						    BSD General Commands Manual 						   TABS(1)

NAME

     tabs -- set terminal tabs

SYNOPSIS

     tabs [-n | -a | -a2 | -c | -c2 | -c3 | -f | -p | -s | -u] [+m[n]] [-T type]
     tabs [-T type] [+[n]] n1[,n2,...]

DESCRIPTION

     The tabs utility displays a series of characters that clear the hardware terminal tab settings then initialises tab stops at specified posi-
     tions, and optionally adjusts the margin.

     In the first synopsis form, the tab stops set depend on the command line options used, and may be one of the predefined formats or at regular
     intervals.

     In the second synopsis form, tab stops are set at positions n1, n2, etc.  If a position is preceded by a '+', it is relative to the previous
     position set.  No more than 20 positions may be specified.

     If no tab stops are specified, the ``standard'' UNIX tab width of 8 is used.

     The options are as follows:

     -n      Set a tab stop every n columns.  If n is 0, the tab stops are cleared but no new ones are set.

     -a      Assembler format (columns 1, 10, 16, 36, 72).

     -a2     Assembler format (columns 1, 10, 16, 40, 72).

     -c      COBOL normal format (columns 1, 8, 12, 16, 20, 55)

     -c2     COBOL compact format (columns 1, 6, 10, 14, 49)

     -c3     COBOL compact format (columns 1, 6, 10, 14, 18, 22, 26, 30, 34, 38, 42, 46, 50, 54, 58, 62, 67).

     -f      FORTRAN format (columns 1, 7, 11, 15, 19, 23).

     -p      PL/1 format (columns 1, 5, 9, 13, 17, 21, 25, 29, 33, 37, 41, 45, 49, 53, 57, 61).

     -s      SNOBOL format (columns 1, 10, 55).

     -u      Assembler format (columns 1, 12, 20, 44).

     +m[n], +[n]
	     Set an n character left margin, or 10 if n is omitted.

     -T type
	     Output escape sequence for the terminal type type.

ENVIRONMENT

     The LANG, LC_ALL, LC_CTYPE and TERM environment variables affect the execution of tabs as described in environ(7).

     The -T option overrides the setting of the TERM environment variable.  If neither TERM nor the -T option are present, tabs will fail.

EXIT STATUS

     The tabs utility exits 0 on success, and >0 if an error occurs.

SEE ALSO

     expand(1), stty(1), tput(1), unexpand(1), termcap(5)

STANDARDS

     The tabs utility conforms to IEEE Std 1003.1-2001 (``POSIX.1'').

HISTORY

     A tabs utility appeared in PWB UNIX.  This implementation was introduced in FreeBSD 5.0.

BUGS

     The current termcap(5) database does not define the 'ML' (set left soft margin) capability for any terminals.

BSD
								   May 20, 2002 							       BSD

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk / grep / Prints all columns except the first one

Discussion started by: knijjar

2. UNIX for Dummies Questions & Answers

why does tar sometimes include directory information?

Discussion started by: JamesByars

3. Shell Programming and Scripting

Display output as columns using grep/awk/sed

Discussion started by: gubbu

4. Shell Programming and Scripting

awk (gawk) grep & columns

Discussion started by: frajer