02-06-2008
condensed question
So the condensed version of what I'm seeking help on is ...
Suppose I have a file
#time(epoch) data1 data2 ... dataN
10000000 9.5 13.4 ... 1
10000001 9.3 13.3 ... 1
10000002 9.0 13.4 ... 1
10000003 9.1 13.2 ... 1
.
.
.
.
10000000 9.9 13.5 ... 2
10000001 999 13.6 ... 2
10000002 9.9 13.6 ... 2
.
.
.
.
10000000 ? ? ... N
And what I want to do is create a file that looks like
#time(epoch) data2 data2 ... dataN
10000000 9.5 9.9 ... ?
10000001 9.3 NAN ... ?
10000002 9.0 9.9 ... ?
.
.
.
So basically I'm looking to concatenate a file by a certain column AND filter that column such that values exceeding, let's say 20, will be given a NAN or blank, whichever gnuplot can handle.
I hope this a little more clear in terms of what I'm seeking help for as well as is a little more inline with the title ...
THANKS
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
i have a file and i need the text to line up
currently the file looks like so
job scheduled complete
12 12:00 wendsday
13 1:00 wednsday
its a text file but not sure how to manipulate the file for it to line up (3 Replies)
Discussion started by: leprichaun
3 Replies
2. Shell Programming and Scripting
hi
I have two file that I would like to paste line by line. I use to use paste for this. But my current platform will not have paste utility. Could anyone please suggest how I it can be done using sed,awk or even simple bourne shell scripts?
Thanks
Sabina (1 Reply)
Discussion started by: ssayeed
1 Replies
3. UNIX for Dummies Questions & Answers
Hi,
Let's say that I have a file called table, I know that if I need to see a the second column for exampls I use:
awk ' {print $2}' table.txt
Is there anyway to use awk to actually cut a column and put it somewhere else in the table?:confused: (8 Replies)
Discussion started by: cosmologist
8 Replies
4. Shell Programming and Scripting
Hello,
I am trying to solve for a couple of hours now the following problem:
I have n files and would like to add the third column of each file to a new file:
temp1.txt
1 2 3
1 2 3
1 2 3
temp2.txt
1 2 4
1 2 4
1 2 4
1 2 4
temp3.txt (2 Replies)
Discussion started by: creamcheese
2 Replies
5. Shell Programming and Scripting
Hi all,
I'm a unix newb andI'm trying to write a script that can copy some text paste it in a certian place and then add a number. It's not really clear but I'll show an example.
what the file looks like right now:
Linux 2.6.24-24-generic (abc) 07/15/09
23:25:01 CPU ... (6 Replies)
Discussion started by: the1hand3r
6 Replies
6. 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
7. Shell Programming and Scripting
Hi everybody,
I have two XML files.
I am working on a script that could copy and paste the contents of the first xml file to the desired location in the second xml file.
Here is my first XML file.
This is the second XML file.
Finaly, I wnat to obtain something like that :
... (2 Replies)
Discussion started by: lsaas
2 Replies
8. Shell Programming and Scripting
Hi,
For the below problem, awk script is needed..
input file :
jill
jack
jill
jill
jack
jill
jack
jill
Required:
here,
i need to check from first line.
reference is jack. jill need to verified with next line jack. if found print
jill & jack combination hill1
jack & jill &... (0 Replies)
Discussion started by: vasanth.vadalur
0 Replies
9. Shell Programming and Scripting
I have rrd file which is have the gaps and I want to fill it out with some value , I've got 10 NaN record and I try to populate data from 10 records be for NaN to change instead of NaN :(
<!-- 2016-05-19 14:10:00 CST / 1463638200 -->... (11 Replies)
Discussion started by: boobytrap
11 Replies
10. Shell Programming and Scripting
Input file will be
Name: serve1
has disk :Yes
dev (8):
Name: serve2
has disk :No
dev (8):
Name: serve3
has disk :No
Name: serve4
has disk :Yes
dev (8):
Need output like that. I was using pate -d, - - - . But that need all the line in same format in this some server it has... (4 Replies)
Discussion started by: ranjancom2000
4 Replies