Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk to change value in field according to another
Top Forums Shell Programming and Scripting awk to change value in field according to another Post 303025703 by Don Cragun on Saturday 10th of November 2018 02:29:02 AM
Old 11-10-2018
Quote:
Originally Posted by cmccabe
The $4 value in file1 is not unique but is meant to ensure that, using line 1 as an example, only SDBH lines are searched or used in the comparison. There may be hundreds of lines in file1, but only a subset will match the $4 value. Thank you Smilie.
And, of that subset that match the $4 value, we have to assume that the same subset or a smaller subset may be classified as "intron", the same subset or a smaller subset may be classified as "exon", and the same subset or a smaller subset may be classified as "splicing" when your criteria are applied. How are the subset of lines that match the $4 value supposed to be combined or selected so that only one of the possible results are returned (presumably the one possible result that is the one that you want to match from all of the ones in the subset that do match)???
This User Gave Thanks to Don Cragun For This Post:
cmccabe
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

change field content awk

I have a line like this: I want to move HTTP/1.1 200 OK to the next line and put a blank line between the two lines i.e. How can i get it using awk? Thanks in advance (2 Replies)
Discussion started by: littleboyblu
2 Replies

2. Shell Programming and Scripting

dynamically change awk Field Separator FS

Hi All, I was wondering if anyone knew how to dynamically change the FS in awk to accept vairiable containing a field separator. the current code is as below and does not work when i introduce the dynamic FS change :-( validate_source_file() { source_file=$1 ... (2 Replies)
Discussion started by: satnamx
2 Replies

3. Shell Programming and Scripting

awk,cut fields by change field format

Hi Everyone, # cat 1.txt 1321631,77770132976455,19,20091001011859,20091001011907 1321631,77770132976455,19,20091001011859,20091001011907 1321631,77770132976455,19,20091001011859,20091001011907 # cat 1.txt | awk -F, '{OFS=",";print $1,$3,$4,$5}' 1321631,19,20091001011859,20091001011907... (7 Replies)
Discussion started by: jimmy_y
7 Replies

4. Shell Programming and Scripting

awk, comma as field separator and text inside double quotes as a field.

Hi, all I need to get fields in a line that are separated by commas, some of the fields are enclosed with double quotes, and they are supposed to be treated as a single field even if there are commas inside the quotes. sample input: for this line, 5 fields are supposed to be extracted, they... (8 Replies)
Discussion started by: kevintse
8 Replies

5. Shell Programming and Scripting

AWK: Pattern match between 2 files, then compare a field in file1 as > or < field in file2

First, thanks for the help in previous posts... couldn't have gotten where I am now without it! So here is what I have, I use AWK to match $1 and $2 as 1 string in file1 to $1 and $2 as 1 string in file2. Now I'm wondering if I can extend this AWK command to incorporate the following: If $1... (4 Replies)
Discussion started by: right_coaster
4 Replies

6. Shell Programming and Scripting

awk or sed? change field conditional on key match

Hi. I'd appreciate if I can get some direction in this issue to get me going. Datafile1: -About 4000 records, I have to update field#4 in selected records based on a match in the key field (Field#1). -Field #1 is the key field (servername) . # of Fields may vary # comment server1 bbb ccc... (2 Replies)
Discussion started by: RascalHoudi
2 Replies

7. UNIX for Dummies Questions & Answers

change field separator only from nth field until NF

Hi ! input: 111|222|333|aaa|bbb|ccc 999|888|777|nnn|kkk 444|666|555|eee|ttt|ooo|ppp With awk, I am trying to change the FS "|" to "; " only from the 4th field until the end (the number of fields vary between records). In order to get: 111|222|333|aaa; bbb; ccc 999|888|777|nnn; kkk... (1 Reply)
Discussion started by: beca123456
1 Replies

8. Shell Programming and Scripting

awk :how to change delimiter without giving all field name

Hi Experts, i need to change delimiter from tab to "," sample test file cat test A0000368 A29938511 072569352 5 Any 2 for £1.00 BUTCHERS|CAT FOOD|400G Sep 12 2012 12:00AM Jan 5 2014 11:59PM Sep 7 2012 12:00AM M 2.000 group 5 ... (2 Replies)
Discussion started by: Lakshman_Gupta
2 Replies

9. Shell Programming and Scripting

awk to change value of field using multiple conditions

In the below awk in the first step I default Classification NF-1 to VUS. Next, I am trying to change the value of Classification (NF) to whatever CLINSIG (NF-1) is. If there is only one condition everything works great, but if there are two conditions it does not work. Is the syntax used... (4 Replies)
Discussion started by: cmccabe
4 Replies

10. Shell Programming and Scripting

awk to change contents of field based on condition in same file

In the awk below I am trying to copy the entire contents of $6 there may be multiple values seperated by a ;, to $8, if $8 is . (lines 1 and 3 are examples). If that condition $8 is not . (line2 is an example) then that line is skipped and printed as is. The awk does execute but prints the output... (3 Replies)
Discussion started by: cmccabe
3 Replies

LEARN ABOUT OSF1

stl_ctrl

stl_ctrl(4)						     Kernel Interfaces Manual						       stl_ctrl(4)

NAME

       stl_ctrl - Software subset control files

DESCRIPTION

       Each software subset that is distributed for the setld command has an associated control file.  This control file is created by the kits(1)
       utility.  The control file's name consists of the subset name with the string .ctrl for a suffix.   The	control  file  contains  attribute
       information for the subset.  Once the subset has been installed on a system, the control file is placed in the usr/.smdb.  directory.

       The  attribute definitions in the file are stored one per line as attribute name/value pairs separated by equals signs (=).  The attributes
       are:

       NAME   The name (text description) of the product of which this subset is a component, as given by the NAME attribute defined in the  prod-
	      uct attributes section of the key file.

       DESC   The text description of the subset, as given in the subset descriptor for this subset in the key file.

       ROOTSIZE
	      The size in bytes that are used on the root file system.

       USRSIZE
	      The size in bytes that are used on the usr file system.

       VARSIZE
	      The size in bytes that are used on the ar file system.

       MTLOC  Two  integers  separated	by a colon (:).  These integers are used by the setld utility to find the subset on tape media.  The first
	      number specifies the volume in the product tape set; the second is the location within that volume.  The values established for this
	      attribute  by the kits utility are placeholders.	The actual values are generated as the subset is being written to tape by the gen-
	      tapes command.

       DEPS   The dependency list for this subset.

       FLAGS  The value specified by the flags field of this subset's record in the key file.

EXAMPLES

       The following example shows the contents of OATDCB100.ctrl, the control file for a hypothetical subset: NAME='Orpheus Authoring Tools  OAT-
       DCB100' DESC='Document Building Tools' ROOTSIZE=12352 USRSIZE=43941 VARSIZE=8704 NVOLS=1:2 MTLOC=1:1 DEPS="."  FLAGS=0

RELATED INFORMATION

       gendisk(1), gentapes(1), kits(1), stl_key(4), setld(8)

       Guide to Preparing Product Kits delim off

																       stl_ctrl(4)
All times are GMT -4. The time now is 03:53 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy