02-05-2010
hello my friend Scrutinizer,
i test there may be sth wrong with your script because the third field is not sorted.
Quote:
sort -t"|" +2 yourfile | awk -F"|" 'BEGIN{arr[""]="";}{arr[$5]=$0;}END{for(i in arr){if(arr[i]!="")print arr[i];}}' | sort -t"|" -f +4
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hello,
how can I filter and get the latest order number (last five digits) below:
input file:
johnmm00001
maryyy00121
johnm100222
johnmm00003
maryyy00122
output file:
johnmm00003
maryyy00122
johnm100222 (6 Replies)
Discussion started by: happyv
6 Replies
2. Shell Programming and Scripting
Anyone can help for filter the uniq record for below example? Thank you very much
Input file
20090503011111|test|abc
20090503011112|tet1|abc|def
20090503011112|test1|bcd|def
20090503011131|abc|abc
20090503011131|bbc|bcd
20090503011152|bcd|abc
20090503011151|abc|abc... (8 Replies)
Discussion started by: bleach8578
8 Replies
3. Shell Programming and Scripting
Reposting since I didnt not get any reply.
I have a problem while filtering records from a file. Can somebody help please?
For eg: Consider the below files
Record file:
0003@00000000000190@20100401@201004012010040120100401@003@... (1 Reply)
Discussion started by: gpaulose
1 Replies
4. UNIX for Dummies Questions & Answers
Hello all!! I am new here and new in scripting!
I want to write a ksh script to select the most recent file from a dir and use it in a variable.
I have a directory with files named like: YYYMMDD
A basic idea of the script I want to write is
#!/usr/bin/ksh
latest= latest_dated_file at... (2 Replies)
Discussion started by: chris_euop
2 Replies
5. Shell Programming and Scripting
Hi,
I need a ksh script for the below requirement:
i have a Delimited flat file with 200 records delimiter is '|~|'
i need a script to insert space at the end if the record is ending with delimiter '|~|'
if it didnt end with delimiter it should not append space.
Example: ram|~|2|~| ... (16 Replies)
Discussion started by: srikanth_sagi
16 Replies
6. Shell Programming and Scripting
I have file1
3049
3138
4672
22631
45324
112382
121240
125470
130289
186128
193996
194002
202776
228002
253221
273523
284601
284605
641858 (8 Replies)
Discussion started by: biomed
8 Replies
7. Shell Programming and Scripting
Dear friend,
I have a file 2 files with column wise
FILE_A
------------------------------
x,1,@
y,3,$
x,5,%
FILE_B
--------------------
x,1,@
i like to delete the all lines in FILE_A ,if first column available in FILE_B.
output (in FILE_A)
y,3,$
x,5,% (10 Replies)
Discussion started by: Jewel
10 Replies
8. Shell Programming and Scripting
Dear All,
I have getting data as follows, the second field signifies table name and last one is time stamp. I have return always latest record based on time stamp. Could you please help me ?
I/P
====
... (1 Reply)
Discussion started by: srikanth38
1 Replies
9. Shell Programming and Scripting
Using ksh, I am using SQLPlus to execute a query with a filter using a string variable.
REPO_DB=DEV1
FOLDER_NM='U_nmalencia'
FOLDER_CHECK=$(sqlplus -s /nolog <<EOF
CONNECT user/pswd_select@${REPO_DB}
set echo off heading off feedback off
select subj_name
from subject
where... (5 Replies)
Discussion started by: nkm0brm
5 Replies
10. UNIX for Dummies Questions & Answers
I have requirement to print latest record from file based on multiple columns combination.
EWAPE EW1SLE0000 EW1SOMU01 ABORTED 03/16/2015 100004 03/16/2015 100005 001
EWAPE EW1SLE0000 EW1SOMU01 ABORTED 03/18/2015 140003 03/18/2015 140004 001
EWAPE EW1SLE0000 EW1SOMU01 ABORTED 03/18/2015 220006... (1 Reply)
Discussion started by: tmalik79
1 Replies
LEARN ABOUT PHP
collator_sort_with_sort_keys
COLLATOR_SORT_WITH_SORT_KEYS(3) 1 COLLATOR_SORT_WITH_SORT_KEYS(3)
Collator::sortWithSortKeys - Sort array using specified collator and sort keys
Object oriented style
SYNOPSIS
public bool Collator::sortWithSortKeys (array &$arr)
DESCRIPTION
Procedural style
bool collator_sort_with_sort_keys (Collator $coll, array &$arr)
Similar to collator_sort(3) but uses ICU sorting keys produced by ucol_getSortKey() to gain more speed on large arrays.
PARAMETERS
o $coll
-Collator object.
o $arr
-Array of strings to sort
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
collator_sort_with_sort_keys(3) example
<?php
$arr = array( 'Kopfe', 'Kypper', 'Kopfe' );
$coll = collator_create( 'sv' );
collator_sort_with_sort_keys( $coll, $arr );
var_export( $arr );
?>
The above example will output:
array (
0 => 'Kopfe',
1 => 'Kypper',
2 => 'Kopfe',
)
SEE ALSO
Collator constants, collator_sort(3), collator_asort(3).
PHP Documentation Group COLLATOR_SORT_WITH_SORT_KEYS(3)