add lines automatically based on a field on another file

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Print lines based upon unique values in Nth field

For some reason I am having difficulty performing what should be a fairly easy task. I would like to print lines of a file that have a unique value in the first field. For example, I have a large data-set with the following excerpt: PS003,001 MZMWR/ L-DWD// * PS003,001...

2. Shell Programming and Scripting

awk to print lines based on text in field and value in two additional fields

In the awk below I am trying to print the entire line, along with the header row, if $2 is SNV or MNV or INDEL. If that condition is met or is true, and $3 is less than or equal to 0.05, then in $7 the sub pattern :GMAF= is found and the value after the = sign is checked. If that value is less than...

3. Shell Programming and Scripting

Concatenation lines based on first field of the lines

Hello All, This is to request some assistance on the issue that I encountered until recently. Problem is: I have a pipe delimited file in which some lines/records are broken. Now, I have to join/concatenate broken lines in the file to form actual record to make sure that the count of records...

4. Shell Programming and Scripting

awk joining multiple lines based on field count

Hi Folks, I have a file with fields as follows which has last field in multiple lines. I would like to combine a line which has three fields with single field line for as shown in expected output. Please help. INPUT hname01 windows appnamec1eda_p1, ...

5. Shell Programming and Scripting

Add specific string to last field of each line in perl based on value

I am trying to add a condition to the below perl that will capture the GTtag and place a specific string in the last field of each line. The problem is that the GT value used is not right after the tag rather it is a few fields away. The values should always be 0/1 or 1/2 and are in bold in the...

6. UNIX for Dummies Questions & Answers

join 2 lines based on 1st field

hi i have a file with the following lines 2303:13593:137135 16 abc1 26213806....... 1234:45675:123456 16 bbc1 9813806....... 2303:13593:137135 17 bna1 26566444.... 1234:45675:123456 18 nnb1 98123456....... i want to join the lines having common 1st field i,e., ...

7. Shell Programming and Scripting

Combine multiple lines in file based on specific field

Hi, I have an issue to combine multiple lines of a file. I have records as below. Fields are delimited by TAB. Each lines are ending with a new line char (\n) Input -------- ABC 123456 abcde 987 890456 7890 xyz ght gtuv ABC 5tyin 1234 789 ghty kuio ABC ghty jind 1234 678 ght ...

8. Shell Programming and Scripting

Remove duplicate lines based on field and sort

I have a csv file that I would like to remove duplicate lines based on field 1 and sort. I don't care about any of the other fields but I still wanna keep there data intact. I was thinking I could do something like this but I have no idea how to print the full line with this. Please show any method...

9. Shell Programming and Scripting

AWK : Add Fields of lines with matching field

Dear All, I would like to add values of a field, if the lines match in a certain field. Then I would like to divide the sum though the number of lines that have a matched field. This is the Input: Input: Test1 5 Test1 10 Test2 2 Test2 5 Test2 13 Test3 4 Output: Test1 7.5 Test1 7.5...

10. Shell Programming and Scripting

Extract lines from a file automatically. Please a Help

hello, hope you can help me: ive got a file called archivos The content or structure of this file is ./chu0/filechu ./chu1/filechu I extract each line from this file manually and redirect to a file, and it Works fine, so the command line is: awk �/chu0/ {print $0}' < archivos >...

LEARN ABOUT OSF1

sdiff

sdiff(1)						      General Commands Manual							  sdiff(1)

NAME

       sdiff - Compares two files and displays the differences in a side-by-side format

SYNOPSIS

       sdiff [-l | -s] [-w number] [-o output_file] file1 file2

       The sdiff command reads file1 and file2, uses diff to compare them, and writes the results to standard output in a side-by-side format.

OPTIONS

       Displays  only the left side when lines are identical.  Creates a third file, output_file, by a controlled interactive line-by-line merging
       of file1 and file2. The following subcommands govern the creation of this file: Adds the left side to output_file.  Adds the right side	to
       output_file.   Stops  displaying  identical  lines.  Begins displaying identical lines.	Enters ed with the left side, the right side, both
       sides, or an empty file, respectively.

	      Each time you exit from ed, sdiff writes the resulting edited file to the end of output_file.  If  you  fail  to	save  the  changes
	      before  exiting,	sdiff  writes  the  initial input to output_file.  Exits the interactive session.  Suppresses display of identical
	      lines.  Sets the width of the output line to number (130 characters by default).

DESCRIPTION

       The sdiff command displays each line of the two files with a series of spaces between them if the lines are  identical,	a  <  (left  angle
       bracket) in the field of spaces if the line only exists in file1, a > (right angle bracket) if the line only exists in file2, and a | (ver-
       tical bar) for lines that are different.

       When you specify the -o option, sdiff produces a third file by merging file1 and file2 according to your instructions.

       Note that the sdiff command invokes the diff -b command to compare two input files.  The -b option causes the diff command to ignore trail-
       ing spaces, tab characters, and consider other strings of spaces as equal.

EXAMPLES

       To print a comparison of two files, enter: sdiff  chap1.bak  chap1

	      This  displays a side-by-side listing that compares each line of chap1.bak and chap1.  To display only the lines that differ, enter:
	      sdiff  -s  -w 80	chap1.bak  chap1

	      This displays the differences at the tty.  The -w 80 sets page width to 80 columns.  The -s option tells sdiff not to display  lines
	      that  are  identical  in	both  files.  To selectively combine parts of two files, enter: sdiff -s  -w 80  -o chap1.combo  chap1.bak
	      chap1

	      This combines chap1.bak and chap1 into a new file called chap1.combo.  For each group of differing lines, sdiff asks you which group
	      to keep or whether you want to edit them using ed.

SEE ALSO

       Commands:  diff(1), ed(1)

																	  sdiff(1)

Shell Programming and Scripting