Sponsored Content
Top Forums Shell Programming and Scripting file editting with shell programmin Post 77633 by vgersh99 on Monday 11th of July 2005 03:28:15 PM
Old 07-11-2005
Quote:
Originally Posted by ssshen@mit.edu
I modified code slightly by putting FS="\t" ahead of val and it worked! As I executed code I got two more problems. First, the row header in eash file should be omitted. Second, there are some records like "---" which shouldn't be included. Can these be solved? Thanks.
or all in awk:

nawk -f shen.awk input*

shen.awk:
Code:
BEGIN {
  OFS="\t"
}
FNR > 1 && $3 != "-" {
   arr[FILENAME , $3]
}
END {
  for(i in arr) {
    split(i, tmp, SUBSEP)
    printf("%s", tmp[1] )
    for(cell in arr) {
      split(cell, ctmp, SUBSEP)
      if ( ctmp[1] == tmp[1] ) {
        printf("%s%s", OFS,ctmp[2])
        delete arr[cell]
      }
    }
    printf "\n"
  }
}

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Books on Shell programmin

Can Anyone suggest few good books on Unix Shell Programming and C on Unix. Thanks Prasad (5 Replies)
Discussion started by: pswar70
5 Replies

2. IP Networking

socket programmin

I was trying to write proxy code but i here is a problem typedef struct req_msg { char *host;//hostname char *filename;//filename char *modified;//date char *data; char *request; }req_msg; while(take_responce(req,request)!=0) // take_responce gets responce from http server //... (0 Replies)
Discussion started by: yogesh_powar
0 Replies

3. Shell Programming and Scripting

Unix file editting commands

ok, are there any other file editting commands out there other than the below that comes with sunsolaris & linux vi, emacs, ed, (1 Reply)
Discussion started by: Terrible
1 Replies

4. Shell Programming and Scripting

editting file

Hi, I am having sequence of process ids in one file. My file contents is (Output of fuser someobject.so). 654 14583 17890 25902 This no. of processes may vary depends up on the object. I want to check all the processes one by one. If i want to apply egrep, I need to... (3 Replies)
Discussion started by: sharif
3 Replies

5. UNIX for Dummies Questions & Answers

matching IDs from two files and editting

I have two files. One has: ID# 0 a b c d e f g h i j k....................~2 milion columns ID# 0 l m n o p q r s t u v....................~2 milion columns . . . ~6000 lines Other has: ID# 1 or ID# 2 . . ~6000 lines (2 Replies)
Discussion started by: polly_falconer
2 Replies

6. Shell Programming and Scripting

Editting each line in a file

Hi Can anyone please help me in resolving my issue. I have a file with entries like this t9787ms 99970 22/08/2010 12:30 /www.google.com t9788ms 99942 22/08/2010 12:40 /www.google.com t4788ms 88942 22/08/2010 01:40 /www.google.com there are around 5 lakh records of this type my requirement... (4 Replies)
Discussion started by: mskalyani
4 Replies

7. Programming

gdbm with c programmin Books & Tutorial.

Hello, Could you please tell me if there are any books/tutorial on gdbm programming with C for beginners. So far, I've found few tutorials and one of those: http://www.network-theory.co.uk/docs/gccintro/gccintro_22.html is easy to understand but very short in treatment as it dealt with ... (6 Replies)
Discussion started by: vectrum
6 Replies

8. Linux

Problem editting the first occurence of a pattern in the first uncommented line

Hi I have to replace a pattern found in the first uncommented line in a file. The challenge I'm facing is there are several such similar lines but I have to edit only the first uncommented line. Eg: #this is example #/root/xyz:Old_Pattern /root/xyz:Old_Pattern /root/xyz:Old_Pattern ... (10 Replies)
Discussion started by: Stoner008
10 Replies

9. Shell Programming and Scripting

Editting a record

robert (6 Replies)
Discussion started by: robert89
6 Replies

10. Shell Programming and Scripting

Help with Shell Scrip in Masking particular columns in .csv file or .txt file using shell script

Hello Unix Shell Script Experts, I have a script that would mask the columns in .csv file or .txt file. First the script will untar the .zip files from Archive folder and processes into work folder and finally pushes the masked .csv files into Feed folder. Two parameters are passed ... (5 Replies)
Discussion started by: Mahesh G
5 Replies
COLLATOR_SORT(3)							 1							  COLLATOR_SORT(3)

Collator::sort - Sort array using specified collator

	Object oriented style

SYNOPSIS
public bool Collator::sort (array &$arr, [int $sort_flag]) DESCRIPTION
Procedural style bool collator_sort (Collator $coll, array &$arr, [int $sort_flag]) This function sorts an array according to current locale rules. Equivalent to standard PHP sort(3) . PARAMETERS
o $coll -Collator object. o $arr - Array of strings to sort. o $sort_flag - Optional sorting type, one of the following: o Collator::SORT_REGULAR - compare items normally (don't change types) o Collator::SORT_NUMERIC - compare items numerically o Collator::SORT_STRING - compare items as strings Default sorting type is Collator::SORT_REGULAR. It is also used if an invalid $sort_flag value has been specified. RETURN VALUES
Returns TRUE on success or FALSE on failure. EXAMPLES
Example #1 collator_sort(3) example <?php $coll = collator_create( 'en_US' ); $arr = array( 'at', 'as', 'as' ); var_export( $arr ); collator_sort( $coll, $arr ); var_export( $arr ); ?> The above example will output: array ( 0 => 'at', 1 => 'as', 2 => 'as', )array ( 0 => 'as', 1 => 'as', 2 => 'at', ) SEE ALSO
Collator constants, collator_asort(3), collator_sort_with_sort_keys(3). PHP Documentation Group COLLATOR_SORT(3)
All times are GMT -4. The time now is 06:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy