Hi All,
I have a table with 10 columns. Some columns(2nd,4th,5th,7th,8th and 10th) are Not Null columns. I'll get a tab-delimited file and want to check col by col and generate seperate error code for each col eg:102 if 2nd col value is NULL and 104 if 4th col value is NULL so on... I am a... (7 Replies)
Hi guys,
Couldn't find the solution of this problem. Please Help!
I have a file-
Input_File
TC200232 92 30
TC215306 2 74
TC210135 42 14
I want an output file in which if column2>column3, the values are swapped and an additional column with value Rev_Com is... (4 Replies)
Hi i have data with two columns like below.
I want to find average of column values like if the value in column 2 is between 0-250000 the average of column 1 is some xx and average of column2 is ww then if value is 250001-5000000 average of column 1 is yy and average of column 2 is zz.
And my... (5 Replies)
Hi,
I have a space delimited text file that looks like the following:
Aa 100 200
Bb 300 100
Cc X 500
Dd 600 X
Basically, I want to take the average of columns 2 and 3 and print it in column 4. However if there is an X in either column 2 or 3, I want to print the non-X value. Therefore... (11 Replies)
Hi All,
I have a pipe seperated file. I need to add the values in second and third columns with group by on first column.
MYFILE_28012012_1115|47|173.90
MYFILE_28012012_1115|4|0.00
MYFILE_28012012_1115|6|22.20
MYFILE_28012012_1116|47|173.90
MYFILE_28012012_1116|4|0.00... (3 Replies)
Dear Experts,
Kindly help me please,
I have a big file where there is duplicate values in col 11 till col 23, every 2 rows appers a new numbers, but in each row there is different coordinates x and y in col 57 till col 74.
Please i will like to get a single value and average of the x and y... (8 Replies)
cat sample.csv
ID,Name,no
1,AAA,1
2,BBB,1
3,AAA,1
4,BBB,1
cut -d',' -f2 sample.csv | sort | uniq
this gives only the 2nd column values
Name
AAA
BBB
How to I get all the columns of CSV along with this? (1 Reply)
How could i take an input file and split the numeric values from the alpha values (123 vs abc) to distinc columns, and if the source is blank to keep it blank (null) in both of the new columns:
So if the source file had a column like:
Value:
|1 |
|2.3|
| |
|No|
I would... (7 Replies)
I have the need to match the first two columns and when they match, calculate the percent of average for the third columns. The following awk script does not give me the expected results.
awk 'NR==FNR {T=$3; next} $1,$2 in T {P=T/$3*100; printf "%s %s %.0f\n", $1, $2, (P>=0)?P:-P}' diff.file... (1 Reply)
I have a file abc.csv, from which I need column 24(PurchaseOrder_TotalCost) to get the sum_of_amounts with date and row count into another file say output.csv
abc.csv-
UTF-8,,,,,,,,,,,,,,,,,,,,,,,,,
... (6 Replies)
Discussion started by: Tahir_M
6 Replies
LEARN ABOUT DEBIAN
pclock
PCLOCK(1) General Commands Manual PCLOCK(1)NAME
pclock - pixmap clock
SYNOPSIS
pclock [options]
DESCRIPTION
This manual page documents briefly the pclock command. This manual page was written for the Debian GNU/Linux distribution because the
original program does not have a manual page.
pclock is a program that places a small analog clock program on the desktop of X. It was designed to run under the WindowMaker window man-
ager. It uses any 64x64 pixmap as a background.
OPTIONS
The programs follow the usual GNU command line syntax, with long options starting with two dashes (`-') and short optoins starting with one
dash. A summary of options is included below.
-B PIXMAP, --background=PIXMAP
Use the given pixmap as the clock background (size must be 64x64).
-H COLOR, --hands-color=COLOR
Draw the hands (hour, minute and second) in the specified color.
-S COLOR, --second-hand-color
Draw the second hand in the specified color
-h, --help
Show summary of options.
--hour-hand-length=INT
Draw the hour hand with the specified length of INT.
--minute-hand-length=INT
Draw the minute hand with the specified length of INT.
--second-hand-length=INT
Draw the second hand with the specified length of INT.
--second-hand-width=INT
Draw the minute hand with the specified width of INT.
-s, --second-hand
Don't display the second hand.
-v, --version
Show version of program.
-w, --withdrawn
Don't start up in a withdrawn (iconic) state.
AUTHOR
This manual page was written by Darren Benham <gecko@debian.org>, for the Debian GNU/Linux system (but may be used by others). The soft-
ware is copyrighted (c) 1998 by and released under the GPL v2.
Author: Alexander Kourakos <Alexander@Kourakos.com>
Web: http://www.kourakos.com/~awk/pclock/
PCLOCK(1)