08-21-2007
vgersh99,
Thanks for the swift reply. I appreciate your assistance. I hate being very rusty and trying to relearn something. LOL Question would that work also for doing a multiple series of math? Meaning I have a column that I want to do math upon. I am taking the column and multiplying it by 0.125, then that total will be subtracted by 1, then that total will be multiplied by 0.0225 for the final total.
((Column*0.125)-1)*0.0225=new column
Meaning would I be able to do something like this:
BEGIN {
FS=OFS=","
}
{
format="%0" length($2) "d"
$(NF+1)=sprintf(format, ((($4*0.125)-1)*0.0225))
print
}
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
My input file:
data_5 Ali 422 2.00E-45 102/253 140/253 24
data_3 Abu 202 60.00E-45 12/23 140/23 28
data_1 Ahmad 256 7.00E-45 120/235 140/235 22
data_4 Aman 365 8.00E-45 15/65 140/65 20
data_10 Jones 869 9.00E-45 65/253 140/253 18... (12 Replies)
Discussion started by: patrick87
12 Replies
2. Shell Programming and Scripting
I have a data file that has a list of data macthing by user.
I am able to sort by user and there is multiple rows for each user.
Ideally I would like to email only the user of the files they own. Would it be best to create a seperate file by user and all rows showing the files they own? (9 Replies)
Discussion started by: mykey242
9 Replies
3. Shell Programming and Scripting
Can anyone please help with this? I have 2 files as given below.
If 2nd column of file1 has pattern foo1@a, find the matching 1st column in file2 & replace 2nd column of file1 with file2's value.
file1
abc_1 foo1@a ....
abc_1 soo2@a ...
def_2 soo2@a ....
def_2 foo1@a ........ (7 Replies)
Discussion started by: prashali
7 Replies
4. Shell Programming and Scripting
Hi,
I need an awk script (or whatever shell-construct) that would take data like below and get the max value of 3 column, when grouping by the 1st column.
clientname,day-of-month,max-users
-----------------------------------
client1,20120610,5
client2,20120610,2
client3,20120610,7... (3 Replies)
Discussion started by: ckmehta
3 Replies
5. Shell Programming and Scripting
Hello experts,
Please help me in achieving this in an easier way possible. I have 2 csv files with following data:
File1
08/23/2012 12:35:47,JOB_5330
08/23/2012 12:35:47,JOB_5330
08/23/2012 12:36:09,JOB_5340
08/23/2012 12:36:14,JOB_5340
08/23/2012 12:36:22,JOB_5350
08/23/2012... (5 Replies)
Discussion started by: asnandhakumar
5 Replies
6. Shell Programming and Scripting
Hi, I am newbie in shell script.
I need your help to solve my problem.
Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies
7. Shell Programming and Scripting
Split column data if the table has n number of column's with some record then how to split n number of colmn's line by line with records
Table
---------
Col1 col2 col3 col4 ....................col20
1 2 3 4 .................... 20
a b c d .................... v
... (11 Replies)
Discussion started by: Priti2277
11 Replies
8. Shell Programming and Scripting
I am working on a multilingual dictionary and I have data in three columns. The data structure can be
word=word=gloss
or
word word=word word=gloss gloss
= acts as a delimiter
The number of words separated by the delimiter can be up to 8 or 10. The structure is well defined in the sense... (6 Replies)
Discussion started by: gimley
6 Replies
9. Shell Programming and Scripting
Hello,
I have this file outputData:
# cat /tmp/outputData
__Capacity^6^NBSC01_Licences^L3_functionality_for_ESB_switch
__Capacity^2100^NBSC01_Licences^Gb_over_IP
__Capacity^1837^NBSC01_Licences^EDGE_BSS_Fnc
__Capacity^1816^NBSC01_Licences^GPRS_CS3_and_CS4... (1 Reply)
Discussion started by: nypreH
1 Replies
10. UNIX for Beginners Questions & Answers
Source Code of the original script is down below please run the script and try to solve this problem
this is my data and I want it column wise
2019-03-20 13:00:00:000
2019-03-20 15:00:00:000
1
Operating System
LAB
0
1
1
1
1
1
1
1
1
1
0
1 (5 Replies)
Discussion started by: Shubham1182
5 Replies
NEATEN(1) General Commands Manual NEATEN(1)
NAME
neaten - neaten up output columns
SYNOPSIS
neaten [ format ]
DESCRIPTION
Neaten reads from its standard input and neatens up columns separated by white space using the specified format. The format is a string
consisting of a positive integer followed by an alignment character and another integer. The alignment character is usually a decimal
point ('.'), but it can be any non-digit.
The alignment character is used as the central point of each column. The total column field width will be the number to the left of the
alignment character plus one for the alignment character itself plus the number to the right of the alignment character.
If a field does not contain the alignment character, it will be printed to the left of where the alignment character would have appeared.
If a field is too long to print within the specified format, the entire field will be printed and that row will not be aligned with the
rest.
The default format is "8.8".
EXAMPLE
To examine a file with columns of numbers:
neaten 10.8 < input | more
BUGS
Columns wider than the total width of the format specification will be printed without any separating white space.
The program does not do anything special with tabs on the input.
AUTHOR
Greg Ward
SEE ALSO
cnt(1), rcalc(1), rlam(1), total(1)
RADIANCE
11/15/93 NEATEN(1)