Sponsored Content
Top Forums Shell Programming and Scripting awk to assign points to variables based on conditions and update specific field Post 303003893 by ctsgnb on Friday 22nd of September 2017 08:31:16 AM
Old 09-22-2017
Did you test your script so far ? have you performed some "unity testing" to validate one by one that your conditions work as you expect ?

In condition 1 , where does this (see in if(index$f["FuncrefGene"]... ) "index$f" come from ?

Why using the dollar sign in variable settings ? when assigning the value 3 to the variable "var2" in awk, shouldn't you use var2=3 rather than $var2=3 ??? same in testing : you are in awk, not in shell so use : if ( var2 == 3 ) { ... } rather than if ( $var2 == 3 ) { ... }

Last edited by ctsgnb; 09-22-2017 at 09:41 AM..
This User Gave Thanks to ctsgnb For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extract file records based on some field conditions

Hello Friends, I have a file(InputFile.csv) with the following columns(the columns are pipe-delimited): ColA|ColB|ColC|ColD|ColE|ColF Now for this file, I have to get those records which fulfil the following condition: If "ColB" is NOT NULL and "ColD" has values one of the following... (9 Replies)
Discussion started by: mehimadri
9 Replies

2. Shell Programming and Scripting

awk assign output of array to specific field-number

With this script i want to print the output to a specific field-number . Can anybody help? awk 'NR=FNR{split(FILENAME,fn,"_");nr=$2;f = $1} END{for (i=1;i<=f;i++) print i,$fn=nr}' input_5.csv input_6.csvinput_5.csv 4 135 5 185 6 85 11 30input_6.csv 1 90 3 58 4 135 7 60 8 55 10... (1 Reply)
Discussion started by: sdf
1 Replies

3. Shell Programming and Scripting

awk search/replace specific field, using variables for regexp & subsitution then overwrite file

Hello, I'm trying the solve the following problem. I have a file which I intend to use as a csv called master.csv The columns are separated by commas. I want to change the text on a specific row in either column 3,4,5 or 6 from xxx to yyy depending upon if column 1 matches a specified pattern.... (3 Replies)
Discussion started by: cyphex
3 Replies

4. Shell Programming and Scripting

Calculate the total 4 field based on the conditions

Please help me to write a script Match with ACNO & NAME if it matched calculate the total val1 val2 val3 and val4 and GT is total of ACNO wise.please check the output Table ----------------- 1005|ANDP|ACN|20|50|10|30 1005|ANDP|ACN|20|10|30|40 1001|AND|NAC|40|50|40|50... (22 Replies)
Discussion started by: kalia4u
22 Replies

5. Shell Programming and Scripting

awk to update field file based on match

If $1 in file1 matches $2 in file2. Then the value in $2 of file2 is updated to $1"."$2 of file2. The awk seems to only match the two files but not update. Thank you :). awk awk 'NR==FNR{A ; next} $1 in A { $2 = a }1' file1 file2 file1 name version NM_000593 5 NM_001257406... (3 Replies)
Discussion started by: cmccabe
3 Replies

6. Shell Programming and Scripting

awk to update field in file based of match in another

I am trying to use awk to match two files that are tab-delimited. When a match is found between file1 $1 and file2 $4, $4 in file2 is updated using the $2 value in file1. If no match is found then the next line is processed. Thank you :). file1 uc001bwr.3 ADC uc001bws.3 ADC... (4 Replies)
Discussion started by: cmccabe
4 Replies

7. Shell Programming and Scripting

awk to update value in field based on another field

In the tab-delimeted input file below I am trying to use awk to update the value in $2 if TYPE=ins in bold, by adding the value of HRUN= in italics. In the below since in line 1 TYPE=ins the 117282541 value in $2 has 6 added because that is the value of HRUN=. Hopefully the awk is a start but I... (2 Replies)
Discussion started by: cmccabe
2 Replies

8. Shell Programming and Scripting

awk to update file based on 5 conditions

I am trying to use awk to update the below tab-delimited file based on 5 different rules/conditions. The final output is also tab-delimited and each line in the file will meet one of the conditions. My attemp is below as well though I am not very confident in it. Thank you :). Condition 1: The... (10 Replies)
Discussion started by: cmccabe
10 Replies

9. Shell Programming and Scripting

Perl to update field based on a specific set of rules

In the perl below, which does execute, I am having trouble with the else in Rule 3. The digit in f{8} is extracted and used to update f accordinly along with the value in f. There can be either - * or + before the number that is extracted but the same logic applies, that is if the value is greater... (5 Replies)
Discussion started by: cmccabe
5 Replies

10. Shell Programming and Scripting

Update a specific field in file with Variable value based on other Key Word

I have an input file with A=xyz B=pqr I would want the value in Second Field (xyz or pqr) updated with a value present in Shell Variable based on the value passed in the first field. (A or B ) while read line do NEW_VALUE = `some functionality done on $line` If $line=First Field-... (1 Reply)
Discussion started by: infernalhell
1 Replies
binary(n)						       Tcl Built-In Commands							 binary(n)

__________________________________________________________________________________________________________________________________________________

NAME
binary - Insert and extract fields from binary strings SYNOPSIS
binary format formatString ?arg arg ...? binary scan string formatString ?varName varName ...? _________________________________________________________________ DESCRIPTION
This command provides facilities for manipulating binary data. The first form, binary format, creates a binary string from normal Tcl val- ues. For example, given the values 16 and 22, on a 32 bit architecture, it might produce an 8-byte binary string consisting of two 4-byte integers, one for each of the numbers. The second form of the command, binary scan, does the opposite: it extracts data from a binary string and returns it as ordinary Tcl string values. BINARY FORMAT
The binary format command generates a binary string whose layout is specified by the formatString and whose contents come from the addi- tional arguments. The resulting binary value is returned. The formatString consists of a sequence of zero or more field specifiers separated by zero or more spaces. Each field specifier is a sin- gle type character followed by an optional numeric count. Most field specifiers consume one argument to obtain the value to be formatted. The type character specifies how the value is to be formatted. The count typically indicates how many items of the specified type are taken from the value. If present, the count is a non-negative decimal integer or *, which normally indicates that all of the items in the value are to be used. If the number of arguments does not match the number of fields in the format string that consume arguments, then an error is generated. Each type-count pair moves an imaginary cursor through the binary data, storing bytes at the current position and advancing the cursor to just after the last byte stored. The cursor is initially at position 0 at the beginning of the data. The type may be any one of the fol- lowing characters: a Stores a character string of length count in the output string. If arg has fewer than count bytes, then additional zero bytes are used to pad out the field. If arg is longer than the specified length, the extra characters will be ignored. If count is *, then all of the bytes in arg will be formatted. If count is omitted, then one character will be formatted. For example, binary format a7a*a alpha bravo charlie will return a string equivalent to alpha0000bravoc. A This form is the same as a except that spaces are used for padding instead of nulls. For example, binary format A6A*A alpha bravo charlie will return alpha bravoc. b Stores a string of count binary digits in low-to-high order within each byte in the output string. Arg must contain a sequence of 1 and 0 characters. The resulting bytes are emitted in first to last order with the bits being formatted in low-to-high order within each byte. If arg has fewer than count digits, then zeros will be used for the remaining bits. If arg has more than the specified number of digits, the extra digits will be ignored. If count is *, then all of the digits in arg will be formatted. If count is omitted, then one digit will be formatted. If the number of bits formatted does not end at a byte boundary, the remaining bits of the last byte will be zeros. For example, binary format b5b* 11100 111000011010 will return a string equivalent to x07x87x05. B This form is the same as b except that the bits are stored in high-to-low order within each byte. For example, binary format B5B* 11100 111000011010 will return a string equivalent to xe0xe1xa0. h Stores a string of count hexadecimal digits in low-to-high within each byte in the output string. Arg must contain a sequence of characters in the set ``0123456789abcdefABCDEF''. The resulting bytes are emitted in first to last order with the hex digits being formatted in low-to-high order within each byte. If arg has fewer than count digits, then zeros will be used for the remaining dig- its. If arg has more than the specified number of digits, the extra digits will be ignored. If count is *, then all of the digits in arg will be formatted. If count is omitted, then one digit will be formatted. If the number of digits formatted does not end at a byte boundary, the remaining bits of the last byte will be zeros. For example, binary format h3h* AB def will return a string equivalent to xbax00xedx0f. H This form is the same as h except that the digits are stored in high-to-low order within each byte. For example, binary format H3H* ab DEF will return a string equivalent to xabx00xdexf0. c Stores one or more 8-bit integer values in the output string. If no count is specified, then arg must consist of an integer value; otherwise arg must consist of a list containing at least count integer elements. The low-order 8 bits of each integer are stored as a one-byte value at the cursor position. If count is *, then all of the integers in the list are formatted. If the number of elements in the list is fewer than count, then an error is generated. If the number of elements in the list is greater than count, then the extra elements are ignored. For example, binary format c3cc* {3 -3 128 1} 260 {2 5} will return a string equivalent to x03xfdx80x04x02x05, whereas binary format c {2 5} will generate an error. s This form is the same as c except that it stores one or more 16-bit integers in little-endian byte order in the output string. The low-order 16-bits of each integer are stored as a two-byte value at the cursor position with the least significant byte stored first. For example, binary format s3 {3 -3 258 1} will return a string equivalent to x03x00xfdxffx02x01. S This form is the same as s except that it stores one or more 16-bit integers in big-endian byte order in the output string. For exam- ple, binary format S3 {3 -3 258 1} will return a string equivalent to x00x03xffxfdx01x02. i This form is the same as c except that it stores one or more 32-bit integers in little-endian byte order in the output string. The low-order 32-bits of each integer are stored as a four-byte value at the cursor position with the least significant byte stored first. For example, binary format i3 {3 -3 65536 1} will return a string equivalent to x03x00x00x00xfdxffxffxffx00x00x01x00 I This form is the same as i except that it stores one or more one or more 32-bit integers in big-endian byte order in the output string. For example, binary format I3 {3 -3 65536 1} will return a string equivalent to x00x00x00x03xffxffxffxfdx00x01x00x00 f This form is the same as c except that it stores one or more one or more single-precision floating in the machine's native representa- tion in the output string. This representation is not portable across architectures, so it should not be used to communicate floating point numbers across the network. The size of a floating point number may vary across architectures, so the number of bytes that are generated may vary. If the value overflows the machine's native representation, then the value of FLT_MAX as defined by the system will be used instead. Because Tcl uses double-precision floating-point numbers internally, there may be some loss of precision in the conversion to single-precision. For example, on a Windows system running on an Intel Pentium processor, binary format f2 {1.6 3.4} will return a string equivalent to xcdxccxccx3fx9ax99x59x40. d This form is the same as f except that it stores one or more one or more double-precision floating in the machine's native representa- tion in the output string. For example, on a Windows system running on an Intel Pentium processor, binary format d1 {1.6} will return a string equivalent to x9ax99x99x99x99x99xf9x3f. x Stores count null bytes in the output string. If count is not specified, stores one null byte. If count is *, generates an error. This type does not consume an argument. For example, binary format a3xa3x2a3 abc def ghi will return a string equivalent to abc00def0000ghi. X Moves the cursor back count bytes in the output string. If count is * or is larger than the current cursor position, then the cursor is positioned at location 0 so that the next byte stored will be the first byte in the result string. If count is omitted then the cursor is moved back one byte. This type does not consume an argument. For example, binary format a3X*a3X2a3 abc def ghi will return dghi. @ Moves the cursor to the absolute location in the output string specified by count. Position 0 refers to the first byte in the output string. If count refers to a position beyond the last byte stored so far, then null bytes will be placed in the unitialized locations and the cursor will be placed at the specified location. If count is *, then the cursor is moved to the current end of the output string. If count is omitted, then an error will be generated. This type does not consume an argument. For example, binary format a5@2a1@*a3@10a1 abcde f ghi j will return abfdeghi0000j. BINARY SCAN
The binary scan command parses fields from a binary string, returning the number of conversions performed. String gives the input to be parsed and formatString indicates how to parse it. Each varName gives the name of a variable; when a field is scanned from string the result is assigned to the corresponding variable. As with binary format, the formatString consists of a sequence of zero or more field specifiers separated by zero or more spaces. Each field specifier is a single type character followed by an optional numeric count. Most field specifiers consume one argument to obtain the variable into which the scanned values should be placed. The type character specifies how the binary data is to be interpreted. The count typically indicates how many items of the specified type are taken from the data. If present, the count is a non-negative decimal integer or *, which normally indicates that all of the remaining items in the data are to be used. If there are not enough bytes left after the current cursor position to satisfy the current field specifier, then the corresponding variable is left untouched and binary scan returns immediately with the number of variables that were set. If there are not enough arguments for all of the fields in the format string that consume arguments, then an error is generated. It is important to note that the c, s, and S (and i and I on 64bit systems) will be scanned into long data size values. In doing this, values that have their high bit set (0x80 for chars, 0x8000 for shorts, 0x80000000 for ints), will be sign extended. Thus the following will occur: set signShort [binary format s1 0x8000] binary scan $signShort s1 val; # val == 0xFFFF8000 If you want to produce an unsigned value, then you can mask the return value to the desired size. For example, to produce an unsigned short value: set val [expr {$val & 0xFFFF}]; # val == 0x8000 Each type-count pair moves an imaginary cursor through the binary data, reading bytes from the current position. The cursor is initially at position 0 at the beginning of the data. The type may be any one of the following characters: a The data is a character string of length count. If count is *, then all of the remaining bytes in string will be scanned into the variable. If count is omitted, then one character will be scanned. For example, binary scan abcde00fghi a6a10 var1 var2 will return 1 with the string equivalent to abcde00 stored in var1 and var2 left unmodified. A This form is the same as a, except trailing blanks and nulls are stripped from the scanned value before it is stored in the variable. For example, binary scan "abc efghi 00" A* var1 will return 1 with abc efghi stored in var1. b The data is turned into a string of count binary digits in low-to-high order represented as a sequence of ``1'' and ``0'' characters. The data bytes are scanned in first to last order with the bits being taken in low-to-high order within each byte. Any extra bits in the last byte are ignored. If count is *, then all of the remaining bits in string will be scanned. If count is omitted, then one bit will be scanned. For example, binary scan x07x87x05 b5b* var1 var2 will return 2 with 11100 stored in var1 and 1110000110100000 stored in var2. B This form is the same as b, except the bits are taken in high-to-low order within each byte. For example, binary scan x70x87x05 B5B* var1 var2 will return 2 with 01110 stored in var1 and 1000011100000101 stored in var2. h The data is turned into a string of count hexadecimal digits in low-to-high order represented as a sequence of characters in the set ``0123456789abcdef''. The data bytes are scanned in first to last order with the hex digits being taken in low-to-high order within each byte. Any extra bits in the last byte are ignored. If count is *, then all of the remaining hex digits in string will be scanned. If count is omitted, then one hex digit will be scanned. For example, binary scan x07x86x05 h3h* var1 var2 will return 2 with 706 stored in var1 and 50 stored in var2. H This form is the same as h, except the digits are taken in high-to-low order within each byte. For example, binary scan x07x86x05 H3H* var1 var2 will return 2 with 078 stored in var1 and 05 stored in var2. c The data is turned into count 8-bit signed integers and stored in the corresponding variable as a list. If count is *, then all of the remaining bytes in string will be scanned. If count is omitted, then one 8-bit integer will be scanned. For example, binary scan x07x86x05 c2c* var1 var2 will return 2 with 7 -122 stored in var1 and 5 stored in var2. Note that the integers returned are signed, but they can be converted to unsigned 8-bit quantities using an expression like: expr ( $num + 0x100 ) % 0x100 s The data is interpreted as count 16-bit signed integers represented in little-endian byte order. The integers are stored in the cor- responding variable as a list. If count is *, then all of the remaining bytes in string will be scanned. If count is omitted, then one 16-bit integer will be scanned. For example, binary scan x05x00x07x00xf0xff s2s* var1 var2 will return 2 with 5 7 stored in var1 and -16 stored in var2. Note that the integers returned are signed, but they can be converted to unsigned 16-bit quantities using an expression like: expr ( $num + 0x10000 ) % 0x10000 S This form is the same as s except that the data is interpreted as count 16-bit signed integers represented in big-endian byte order. For example, binary scan x00x05x00x07xffxf0 S2S* var1 var2 will return 2 with 5 7 stored in var1 and -16 stored in var2. i The data is interpreted as count 32-bit signed integers represented in little-endian byte order. The integers are stored in the cor- responding variable as a list. If count is *, then all of the remaining bytes in string will be scanned. If count is omitted, then one 32-bit integer will be scanned. For example, binary scan x05x00x00x00x07x00x00x00xf0xffxffxff i2i* var1 var2 will return 2 with 5 7 stored in var1 and -16 stored in var2. Note that the integers returned are signed and cannot be represented by Tcl as unsigned values. I This form is the same as I except that the data is interpreted as count 32-bit signed integers represented in big-endian byte order. For example, binary x00x00x00x05x00x00x00x07xffxffxffxf0 I2I* var1 var2 will return 2 with 5 7 stored in var1 and -16 stored in var2. f The data is interpreted as count single-precision floating point numbers in the machine's native representation. The floating point numbers are stored in the corresponding variable as a list. If count is *, then all of the remaining bytes in string will be scanned. If count is omitted, then one single-precision floating point number will be scanned. The size of a floating point number may vary across architectures, so the number of bytes that are scanned may vary. If the data does not represent a valid floating point number, the resulting value is undefined and compiler dependent. For example, on a Windows system running on an Intel Pentium processor, binary scan x3fxccxccxcd f var1 will return 1 with 1.6000000238418579 stored in var1. d This form is the same as f except that the data is interpreted as count double-precision floating point numbers in the machine's native representation. For example, on a Windows system running on an Intel Pentium processor, binary scan x9ax99x99x99x99x99xf9x3f d var1 will return 1 with 1.6000000000000001 stored in var1. x Moves the cursor forward count bytes in string. If count is * or is larger than the number of bytes after the current cursor cursor position, then the cursor is positioned after the last byte in string. If count is omitted, then the cursor is moved forward one byte. Note that this type does not consume an argument. For example, binary scan x01x02x03x04 x2H* var1 will return 1 with 0304 stored in var1. X Moves the cursor back count bytes in string. If count is * or is larger than the current cursor position, then the cursor is posi- tioned at location 0 so that the next byte scanned will be the first byte in string. If count is omitted then the cursor is moved back one byte. Note that this type does not consume an argument. For example, binary scan x01x02x03x04 c2XH* var1 var2 will return 2 with 1 2 stored in var1 and 020304 stored in var2. @ Moves the cursor to the absolute location in the data string specified by count. Note that position 0 refers to the first byte in string. If count refers to a position beyond the end of string, then the cursor is positioned after the last byte. If count is omit- ted, then an error will be generated. For example, binary scan x01x02x03x04 c2@1H* var1 var2 will return 2 with 1 2 stored in var1 and 020304 stored in var2. PLATFORM ISSUES
Sometimes it is desirable to format or scan integer values in the native byte order for the machine. Refer to the byteOrder element of the tcl_platform array to decide which type character to use when formatting or scanning integers. SEE ALSO
format(n), scan(n), tclvars(n) KEYWORDS
binary, format, scan Tcl 8.0 binary(n)
All times are GMT -4. The time now is 12:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy