06-27-2007
Quote:
Originally Posted by
mtechnocrat
Iam tring to execute the below script but iam getting error
cd /data/Projects
sort -k2,2 -k 3.1,3.2 -k1,1 -t'|' Payable.txt |
awk -F"|" '
NR == 1 { first_char=substr(int($3),1,1) }
$3 !~ "^ *"first_char { first_char=substr(int($3),1,1); $0="\n"$0 }
1 '
Error
awk: syntax error near line 3
awk: bailing out near line3
Please help
Try nawk instead of awk
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have this file (filex)
07-11-2003 10:11:12!cccc!ddd!eeeeeeee
07-11-2003 09:11:11!dddd!kkkkk!xxxxxx
09-12-2003 14:18:43!aaaa!bbbbb!cccc
where I need to sort it by date+time in this order:
09-12-2003 14:18:43!aaaa!bbbbb!cccc
07-11-2003 10:11:12!cccc!ddd!eeeeeeee
07-11-2003... (3 Replies)
Discussion started by: gio123bg
3 Replies
2. Shell Programming and Scripting
hi everyone, i have a document where i have email addresess and names, i need to check if the email addresses are uniq, if they repeat erase one of them, how can i do that?
document sample:
aD00763357@cucei.udg.mx,ABRAHAM ANTONIO SEVERIANO
a199721111@cucei.udg.mx,ABRAHAM GONZALEZ... (4 Replies)
Discussion started by: sx3v1l_1n51de
4 Replies
3. Programming
i ahve a file like:
*************************************
sree
122132
12321
***********************************
phani
21321
3213214
******************************
dddsds
213213123
23213213
*******************************
i want to sort the file with respect to name how we can do this... (1 Reply)
Discussion started by: phani_sree
1 Replies
4. Shell Programming and Scripting
i have a data in afile like this
**************************************
sree
sree@yahoo.com
98662323432
*************************************
phani
phani@yahoo.com
98662323344
*************************************
i want to sort the file with respect to name.
how can i do this.
thank... (5 Replies)
Discussion started by: phani_sree
5 Replies
5. Shell Programming and Scripting
I have the file as follow:
A: 60
B: 80
C: 40
D: 11
E: 100
I want to sort the file and get the output to file as follow:
E: 100
B: 80
A: 60
C: 40
D: 11
Could any one help me please? (1 Reply)
Discussion started by: moutaz1983
1 Replies
6. Shell Programming and Scripting
I'm trying to write a script that will look in an /exports folder for the oldest export file and move it to a /staging folder. "Oldest" in this case is actually determined by date information embedded in the file names themselves.
Also, the script should only move a file from /exports to... (6 Replies)
Discussion started by: nikosey
6 Replies
7. UNIX for Dummies Questions & Answers
how would i sort a file on the third column based on numerical value instead of the ASCII order? (1 Reply)
Discussion started by: trob
1 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have two files, one of which I would like to sort based on the order of the data in the second. I would like to do this using a simple unix statement.
My two files as follows:
File 1:
12345 1 2 2 2 0 0
12349 0 0 2 2 1 2
12350 1 2 1 2 2 2
.
.
.
File2:
12350... (3 Replies)
Discussion started by: kasan0
3 Replies
9. Solaris
Hi Guys,
My client (dear clients, I hate to love you) has the funky idea of sorting a 5G flat file.
Certainly enough, this is taking forever and also fulls the / of our machine.
Any idea of how we could proceed to make this a little bit more efficient?
Maybe by forcing sort to "stay in... (7 Replies)
Discussion started by: plmachiavel
7 Replies
10. Shell Programming and Scripting
Hi Unix Admins,
I wanted to sort a file in a specific order,
i.e the input file contains two fields and the first column is not unique and had to be sorted. example
Input File
-------
2014-10-21:Rand1
2014-11-02:Rand2
2014-11-02:Rand3
2014-11-02:Rand4
2014-11-03:Rand5
2014-11-04:Rand6... (4 Replies)
Discussion started by: Naveenezone
4 Replies
LEARN ABOUT NETBSD
column
COLUMN(1) BSD General Commands Manual COLUMN(1)
NAME
column -- columnate lists
SYNOPSIS
column [-tx] [-c columns] [-s sep] [file ...]
DESCRIPTION
The column utility formats its input into multiple columns. Rows are filled before columns. Input is taken from file operands, or, by
default, from the standard input. Empty lines are ignored.
The options are as follows:
-c Output is formatted for a display columns wide.
-s Specify a set of characters to be used to delimit columns for the -t option.
-t Determine the number of columns the input contains and create a table. Columns are delimited with whitespace, by default, or with
the characters supplied using the -s option. Useful for pretty-printing displays.
-x Fill columns before filling rows.
column exits 0 on success, >0 if an error occurred.
ENVIRONMENT
COLUMNS The environment variable COLUMNS is used to determine the size of the screen if no other information is available.
EXAMPLES
(echo "PERM LINKS OWNER GROUP SIZE MONTH DAY HH:MM/YEAR NAME";
ls -l | sed 1d) | column -t
SEE ALSO
colrm(1), ls(1), paste(1), sort(1)
HISTORY
The column command appeared in 4.3BSD-Reno.
BSD
March 9, 2008 BSD