thanks for your quick reply. the result doesn't look correct. please see below result:
the business rule is "for each ID, there 2 records, if any one record amt1 is 0, the in 4th col add "no", for each ID, there 2 records, if any one record amt1 is 0, the in 4th col add "no""
I expected result is
Hello everyone,
I am writing a script to process data from the ATP world tour.
I have a file which contains:
t=540 y=2011 r=1 p=N409
t=540 y=2011 r=2 p=N409
t=540 y=2011 r=3 p=N409
t=540 y=2011 r=4 p=N409
t=520 y=2011 r=1 p=N409
t=520 y=2011 r=2 p=N409
t=520 y=2011 r=3 p=N409
The... (4 Replies)
I am a new user of Unix/Linux, so this question might be a bit simple!
I am trying to join two (very large) files that both have different # of cols and rows in each file.
I want to keep 'all' rows and 'all' cols from both files in the joint file, and the primary key variables are in the rows.... (1 Reply)
Hi,
In a file, I have to mark duplicate records as 'D' and the latest record alone as 'C'.
In the below file, I have to identify if duplicate records are there or not based on Man_ID, Man_DT, Ship_ID and I have to mark the record with latest Ship_DT as "C" and other as "D" (I have to create... (7 Replies)
Hello,
I have some tab delimited data and I need to move the last col. I could hard code it,
awk '{ print $1,$NF,$2,$3,$4,etc }' infile > outfile
but it would be nice to know the syntax to print a range cols.
I know in cut you can do,
cut -f 1,4-8,11-
to print fields 1,... (8 Replies)
Hi,
Please help with this.
I have several excel files (with and .xlsx format) with 10-15 columns each.
They all have the same type of data but the columns are not ordered in the same way.
Here is a 3 column example. What I want to do add the alphabet
from column 2 to column 3, provided... (9 Replies)
Hi
I have a file some thing like below. I want to bin the data. My Bin size is 100.
items number
HELIX1 75
HELIX6 160
HELIX2 88
HELIX19 114
HELIX5 61
HELIX4 167
it should consider each elemet under the number column and bin all the lines like below with 100... (7 Replies)
I want to specify field width based on the row with FTR.
I can acheive this if column width is constant with:
awk 'BEGIN { FIELDWIDTHS = "20 7 14 30" }{print $1,$4}' file
file:COL1 COL2 CL3 FTR
AA8 S2 CAT2 your comments
CC7 ... (5 Replies)
Hello Friends,
Hope all are doing fine.
Here is a tricky issue.
my input file is like this
07 10 14 20 21
03 15 27 30 32
01 10 11 19 30
02 06 14 15 17
01 06 20 25 29
Logic:
1. Please print another column as "0-0-0-0-0" for the first and second rows.
2. Read the first column... (4 Replies)
Hi ALL,
We have requirement in a file, i have multiple rows.
Example below:
Input file rows
01,1,102319,0,0,70,26,U,1,331,000000113200000011920000001212
01,1,102319,0,1,80,20,U,1,241,00000059420000006021
I need my output file should be as mentioned below. Last field should split for... (4 Replies)
Discussion started by: kotra
4 Replies
LEARN ABOUT DEBIAN
amtterm
amtterm(1) General Commands Manual amtterm(1)NAME
amtterm - Intel AMT serial-over-lan (sol) client.
SYNOPSIS
amtterm [ options ] host [ port ]
DESCRIPTION
amtterm provides access to the serial-over-lan port of Intel AMT managed machines. host is the hostname or IP address of the machine amt-
term should connect to. port is the tcp port to use and defaults to 16994 (standard AMT redirection port) if unspecified.
For more inforamtions on Intel AMT check amt-howto(7).
OPTIONS -h Display help text.
-v Be verbose (default).
-q Be quiet.
-u <user>
Specify username, defaults to "admin".
-p <pass>
Specify password. amtterm will prompt on the terminal if unspecified.
ENVIRONMENT
AMT_PASSWORD
Default value for the password.
SEE ALSO gamt(1), amttool(1), amt-howto(7)AUTHOR
(c) 2007 Gerd Hoffmann <kraxel@redhat.com>
(c) 2007 Gerd Hoffmann amtterm(1)