Filter Row Based On Max Column Value After Group BY Post: 302978976

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

filter based on column value

I have a file with colon separated values.. the sample is attached below. No of fields in each record/line is dependent on the value of field53. What I need to do is to design a special filter based on specific requirement of some match of values in particular column or combination of columns. ...

2. Shell Programming and Scripting

intent: df -kh | filter based on capacity (used space) column where % > 85

I want to accomplish this in sh, however if the capability exists only in other shells elsewhere that's acceptable. % df -kh Filesystem size used avail capacity Mounted on ... /dev/dsk/c0t0d0s1 103G 102G 23M 100% /export/DISK15 ... # output...

3. Shell Programming and Scripting

Insert comma based on max number of column

Hi, I am new to unix shell shell scripting. I have a specific requirement where I need to append comma's based on the max number of column in the file. Eg: If my source file look something like this, sengwa,china tom,america,northamerica smith,america walter My output file...

4. Shell Programming and Scripting

repeated column data filter and make as a row

I need to get the output in row wise for the repeated column data Ex: Input: que = five ans = 5 que = six ans = 6 Required output: que = five six ans = 5 6 Any body can guide me?""""""

5. Shell Programming and Scripting

Filter the column and print the result based on condition

Hi all This is my output of the some SQL Query TABLESPACE_NAME FILE_NAME TOTALSPACE FREESPACE USEDSPACE Free ------------------------- ------------------------------------------------------- ---------- --------- ---------...

6. Shell Programming and Scripting

Filter and migrate data from row to column

Hello Experts, I am new in scripting. I would like to filter and migrate data from row to column by awk. Thanks in advance. For example FileA abc 1 2 3 Xyz3 4 1 5 bcd1 Output : Abc 1 2 3 Xyz3 4 1 5 bcd1 3 5 6

7. Shell Programming and Scripting

extracting row with max column value using awk or unix

Hello, BC106081_abc_128240811_128241377 7.96301 BC106081_abc_128240811_128241377 39.322 BC106081_cde_128240811_128241377 1.98628 BC106081_def_128240811_128241377 -2.44492 BC106081_abc_128240811_128241377 69.5504 FLJ00075_xyz_14406_16765 -0.173417 ...

8. Shell Programming and Scripting

awk filter based on column value (variable value)

Hi, I have a requirement to display/write the 3rd column from a file based on the value in the column 3. Ex: Data in the File (comma delimited) ID,Value,Description 1,A,Active 1,I,Inactive 2,S,Started 1,N,None 2,C,Completed 2,F,Failed I need to first get a list of all Unique IDs in...

9. Shell Programming and Scripting

Filter tab file based on column value

Hello I have a tab text file with many columns and have to filter rows ONLY if column 22 has the value of '0', '1', '2' or '3' (out of 0-5). If Column 22 has value '0','1', '2' or '3' (highlighted below), then remove anything less than 10 and greater 100 (based on column 5) AND remove anything...

10. UNIX for Beginners Questions & Answers

Print a row with the max number in a column

Hello, I have this table: chr1_16857_17742 - chr1 17369 17436 "ENST00000619216.1"; "MIR6859-1"; - 67 chr1_16857_17742 - chr1 14404 29570 "ENST00000488147.1"; "WASH7P"; - 885 chr1_16857_18061 - chr1 ...

LEARN ABOUT DEBIAN

fstrcasecmp

fstrcasecmp(3)						     Library Functions Manual						    fstrcasecmp(3)

NAME

       fstrcasecmp - fuzzy comparison of two strings ignoring case

SYNOPSIS

       #include <fstrcmp.h>
       #define FSTRCMP_IDENTICAL
       #define FSTRCMP_THRESHOLD
       #define FSTRCMP_ERROR
       double fstrcasecmp(const char *string1, const char *string2);

DESCRIPTION

       The fstrcmp() function compares the two strings, string1 and string2, ignoring case.

RETURN VALUE

       The  fstrcasecmp  function  returns a floating point value between 0.0 and FSTRCMP_IDENTICAL.  A value of 0.0 means the strings are utterly
       un-alike.  A value of FSTRCMP_IDENTICAL means the strings are identical.  A value of more than FSTRCMP_THRESHOLD (it lies between  0.0  and
       FSTRCMP_IDENTICAL) would be considered "similar" by most people.

       A value of FSTRCMP_ERROR (always negative) indicates a malloc(3) failure.

SEE ALSO

       fmemcmp(3)
	       fuzzy comparison of two memory areas

       fstrcasecmpi(3)
	       fuzzy comparison of two strings ignoring case

       fstrcmp(3)
	       fuzzy comparison of two strings

       strcasecmp(3)
	       compare two strings ignoring case

COPYRIGHT

       fstrcmp version 0.4
       Copyright (C) 2009 Peter Miller
       Peter Miller <pmiller@opensource.org.au>

       The  comparison	code  is  derived  from the fuzzy comparison functions in GNU Gettext 0.17.  The GNU Gettext comparison functions were, in
       turn, derived from GNU Diff 2.7.

       Copyright (C) 1988-2009 Free Software Foundation

																    fstrcasecmp(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

filter based on column value

Discussion started by: rraajjiibb

2. Shell Programming and Scripting

intent: df -kh | filter based on capacity (used space) column where % > 85

Discussion started by: ProGrammar

3. Shell Programming and Scripting

Insert comma based on max number of column

Discussion started by: nicholas_ejn

4. Shell Programming and Scripting

repeated column data filter and make as a row

Discussion started by: vasanth_vadalur