09-01-2009
Quote:
nawk '
/EmployeeID/ {c=3; header=$0;next}
c && --c {if(c==2) id=$0; if (c==1) print header OFS $0;next}
{ $0=id OFS $0;print}' OFS=, myFile
Sorry, after I google about AWK and learned it, I still have trouble to understand your syntax. I understand EmployeeID is the search pattern. OFS is Field Separator comma.
awk <search pattern> {<program actions>}
What I am confused is program action. Could you kindly explain?
1. what is that mean? c && --c
2. next; does that mean exit the program action and going to next program action?
Thanks
Last edited by jbchen; 09-01-2009 at 04:03 PM..
10 More Discussions You Might Find Interesting
1. UNIX Desktop Questions & Answers
One of the things that I have learned to take for granted in the Win32 world is the cut, copy and paste hotkeys of ^X, ^C and ^V.
I use these keys all the time under Win32 to copy and paste information from one GUI into another GUI.
My question is, does X have a similiar standard?
... (4 Replies)
Discussion started by: auswipe
4 Replies
2. Shell Programming and Scripting
hi i am new to shell scripting,
i have been trying to cut columns numbered 1,4 of a file consisiting of 4 columns. Each column is seperated by 2 spaces.
for example:
john 6102097199 tennessee usa
michel 6734590899 texas USA
now, i need to cut the name... (3 Replies)
Discussion started by: t_harsha18
3 Replies
3. Shell Programming and Scripting
Hello
I have a very large file where say each line is made up of 80 characters.
I want to cut the characters from 20-30 and 50-60 from each line and then insert a delimiter between them (# or | etc).
eg
input file
000000000131.12.20990000590425246363375670011200140406... (5 Replies)
Discussion started by: PradeepRed
5 Replies
4. Shell Programming and Scripting
Hi i need a favour
i have a file which has some trillions of records. The file is like this
11111000000000192831840914000000000000000000000000000
45789899090000000000000000011111111111111111111111111
I want to cut specific postions in each line like cut1-3 and assisgn it to a variable and... (5 Replies)
Discussion started by: richa2.m
5 Replies
5. UNIX for Dummies Questions & Answers
Hello,
I want to be able to cut and paste columns from two tables in one command.
Presently I do the following:
cut -f 1,3-6,9 table1.in > table1.out
cut -f 7,6,1-3 table2.in > table2.out
paste table1.out -d '\t' table2.out > MergedTable.out
Is there a better way to do this?
... (1 Reply)
Discussion started by: Gussifinknottle
1 Replies
6. Shell Programming and Scripting
Hi,
Need a help with shell script. I have to search for a string in one of the file, if match found, copy the line to a new file and delete the line from the exisiting file.
eg:
83510000000000063800000.1800000.1600000.1600000.2400000.1800000.2000000.21... (6 Replies)
Discussion started by: gpaulose
6 Replies
7. UNIX for Dummies Questions & Answers
Hello,
I am working on unix for the first time.
I have to write a shell script where i want to cut paste from one file to other.
File "1234.abc" is
03,12345555
16,936,x,x,120
16,936,x,x,100
49,12345555
03,12347710
16,936,x,x,115
16,936,x,x,122
49,12347710
03,12342222... (9 Replies)
Discussion started by: swapsb
9 Replies
8. Shell Programming and Scripting
I have a file which contains 3 fields separated by tabs example
andrew kid baker
I need to swap kid and baker using cut and paste commands how is this to be done?
Thanks (3 Replies)
Discussion started by: drew211
3 Replies
9. Shell Programming and Scripting
let i have A file and B file
A has contains 4 fields as below
----------------
f1 f2 f3 f4
B file consists of 5 fields as below
--------------------
f5 f6 f7 f8 f9
need to display as below output:
f5 f1 f3 f8 f9 (2 Replies)
Discussion started by: ANSHUMAN1983
2 Replies
10. Shell Programming and Scripting
Hello,
I have some problem in cut or paste command for my text data.
Input1.txt :
I use cut command :
cut -d ' ' -f1 Input1.txt > result.txt result.txt :
Then, I use paste command to merge result.txt.
paste -d ' ' result.txt Input1.txt > output.txt output.txt showed :
I use cut... (1 Reply)
Discussion started by: awil
1 Replies
SMRSH(8) System Manager's Manual SMRSH(8)
NAME
smrsh - restricted shell for sendmail
SYNOPSIS
smrsh -c command
DESCRIPTION
The smrsh program is intended as a replacement for sh for use in the ``prog'' mailer in sendmail(8) configuration files. It sharply limits
the commands that can be run using the ``|program'' syntax of sendmail in order to improve the over all security of your system. Briefly,
even if a ``bad guy'' can get sendmail to run a program without going through an alias or forward file, smrsh limits the set of programs
that he or she can execute.
Briefly, smrsh limits programs to be in a single directory, by default /etc/smrsh, allowing the system administrator to choose the set of
acceptable commands, and to the shell builtin commands ``exec'', ``exit'', and ``echo''. It also rejects any commands with the characters
``', `<', `>', `;', `$', `(', `)', `
' (carriage return), or `
' (newline) on the command line to prevent ``end run'' attacks. It allows
``||'' and ``&&'' to enable commands like: ``"|exec /usr/local/bin/procmail -f- /etc/procmailrcs/user || exit 75"''
Initial pathnames on programs are stripped, so forwarding to ``/usr/ucb/vacation'', ``/usr/bin/vacation'', ``/home/server/mydir/bin/vaca-
tion'', and ``vacation'' all actually forward to ``/etc/smrsh/vacation''.
System administrators should be conservative about populating the /etc/smrsh directory. Reasonable additions are vacation(1), procmail(1),
and the like. No matter how brow-beaten you may be, never include any shell or shell-like program (such as perl(1)) in the /etc/smrsh
directory. Note that this does not restrict the use of shell or perl scripts in the sm.bin directory (using the ``#!'' syntax); it simply
disallows execution of arbitrary programs.
FILES
/etc/smrsh - directory for restricted programs
SEE ALSO
sendmail(8)
$Date: 2002/04/25 13:33:40 $ SMRSH(8)