04-12-2012
Help with figuring division and addition based on column data and line numbers
I have a data file in the format of
1234 xxx |
1234 xxx |
1234 xxx |
1234 xxx |
I want to be able to calculate the following -
COLUMN1+((LINENUMBER-1)/365)
The output needs to preserve the 2nd column -
1234 xxx |
1234.00274 xxx |
1234.00548 xxx |
What is the best way to do this? I am somewhat familiar with awk.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I want to find the different column numbers among rows in a file. For example:
A001 a b c d e ... N
A002 a b c d e ... N
A003 a b c d e ... N+1
A004 a b c d e ... N
A005 a b c d e ... N+2
:
:
For most of the lines I will have N columns (say 1000 rows) in each line except the line 3... (5 Replies)
Discussion started by: AMBER
5 Replies
2. 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
3. Shell Programming and Scripting
My input file:
AVI.out <detail>named as the RRM .</detail>
AVI.out <detail>Contains 1 RRM .</detail>
AR0.out <detail>named as the tellurite-resistance.</detail>
AWG.out <detail>Contains 2 HTH .</detail>
ADV.out <detail>named as the DENR family.</detail>
ADV.out ... (10 Replies)
Discussion started by: patrick87
10 Replies
4. Shell Programming and Scripting
I have a file which will have rows like shown below,
ST*820*316054716
RMR*IV*11333331009*PO*40.31
REF*IV*22234441009*xsss471-2762
DTM*003*091016
ENT*000006
RMR*IV*2222234444*PO*239.91
REF*IV*1234445451009*LJhjlkhkj471-2762 </SPAN>
DTM*003*
091016
RMR*IV*2223344441009*PO*40.31... (18 Replies)
Discussion started by: Muthuraj K
18 Replies
5. Shell Programming and Scripting
Hello All,
Could you please help with this.
This is what I have:
506234.222 2
506234.222 2
506234.222 2
506234.222 2
508212.200 2
508212.200 2
333456.111 2
333456.111 2
333456.111 2
333456.111 2
But this is what I want:
506234.222 1
506234.222 2
506234.222 2
506234.222 3 (5 Replies)
Discussion started by: canimba
5 Replies
6. Shell Programming and Scripting
Hi All
I have one query,say i have a requirement like the below code should be
move to diffent files whose maximum lines can be of 10 lines.Say in the below example,it consist of 14 lines.
This should be moved logically using the data in the fisrt coloumn to file1 and file 2.The data of first... (2 Replies)
Discussion started by: sarav.shan
2 Replies
7. UNIX for Dummies Questions & Answers
I have a tab delimited text file that looks like the following:
ERBB3 0.00097
IL31RA 0.000972
SETD5 0.000972
MCART1 0.000973
CENPJ 0.000973
FNDC6 0.000974
I want to assign a number to each row based on the value in the last column (in the order of increasing value so that the first row... (3 Replies)
Discussion started by: evelibertine
3 Replies
8. Shell Programming and Scripting
Hi,
I have a data file with :
01/28/2012,1,1,98995
01/28/2012,1,2,7195
01/29/2012,1,1,98995
01/29/2012,1,2,7195
01/30/2012,1,1,98896
01/30/2012,1,2,7083
01/31/2012,1,1,98896
01/31/2012,1,2,7083
02/01/2012,1,1,98896
02/01/2012,1,2,7083
02/02/2012,1,1,98899
02/02/2012,1,2,7083
I... (1 Reply)
Discussion started by: himanish
1 Replies
9. Shell Programming and Scripting
Dear All,
I have to solve the following problems with multiple tab-separated text file but I don't know how. Any help would be greatly appreciated. I have access to Linux mint (but not as a professional).
I have multiple tab-delimited files with the following structure:
file1:
1 44
2 ... (5 Replies)
Discussion started by: Bastami
5 Replies
10. Shell Programming and Scripting
Hi guys,
I need to append new data at the end of each line of the files. This new data is based on substring (3rd fields) of last column.
Input file xxx.csv:
U1234|1-5X|orange|1-5X|Act|1-5X|0.1 /sac/orange 12345 0
U5678|1-7X|grape|1-7X|Act|1-7X|0.1 /sac/grape 5678 0... (5 Replies)
Discussion started by: null7
5 Replies
LEARN ABOUT SUSE
getunimap
GETUNIMAP(8) Linux GETUNIMAP(8)
NAME
getunimap - dump the unicode map for the current console to stdout
SYNOPSIS
getunimap [ -s ] [ -C console ]
DESCRIPTION
The getunimap program is old and obsolete. It is now part of setfont (1).
The getunimap program outputs the unicode map (also called a "Screen Font Map") for the current console to standard output.
The -C option may be used with Linux 2.6.1 and later to get the map for a console different from the current one. Its argument is a path-
name.
The output of getunimap is of the form
0xAA U+1234 # comment
where 0xAA is the font character code and U+1234 is a unicode character, that if displayed, will be displayed using glyph 0xAA in the font.
Many unicode characters may be mapped to the same glyph.
the Hash symbol # is used as a comment delimiter; characters after a hash sign (to the end of the line) are comments.
The -s option will sort and merge elements, sorting on font character. Hence, it will produce output of the form:
0x22 U+1234 U+5678 U+3456
0x23 U+0023
etc., listing the multiple unicode characters that map to a font glyph.
The output of getunimap is of the form accepted by setfont and psfaddtable
SEE ALSO
psfaddtable(1), setfont(1).
Console Tools 2004-01-01 GETUNIMAP(8)