To you last request: these fora are an excellent source of examples on how to apply awk (and other tools) to solve tricky, special problems.
In general: I think you need to learn to exercise due care when posting a request, like correctly collecting and formatting representative sample data, describing logical relations and context, and phrasing conditions. And, don't ignore questions to unclear specifications and / or data.
All that done, you won't need several other posts to hop around correcting / modifying sample data, and explaining (or even correcting) statements.
A very small adaption of my post#6 proposal will make the output
when applied to the ORIGINAL data in post#1, before you modified it (which, BTW, is regarded impolite at least as it makes later references look silly...). You are wholeheartly invited to find and apply the adaption should the output come close to what you need.
Hi. How do I find an expression with awk in only one column, and if it fits, then print that whole column.
1 apple oranges
2 bannanas pears
3 cats dogs
4 hesaid shesaid
echo "which number:"
read NUMBER (user inputs number 2 for this example)
awk " /$NUMBER/ {field to search is field... (2 Replies)
Hello,
I have 2 columns (1st column has multiple entries but the corresponding values in the column 2 may be the same or different.) however I want to extract unique values for each entry in column 1 by assigning the max value from column 2
SDF4 -0.211654
SDF4 0.978068
... (1 Reply)
Hi,
I have a wide and long dataset which looks as follows:
0 3 4 2 3 0 2 2 ...
3 2 4 0 2 2 2 3 ...
0 3 4 2 0 4 4 4 ...
3 0 4 2 2 4 2 4 ...
....
I would like to obtain the minimum of each column (ignoring zero values) so the output would look like:
3 2 4 2 2 2 2 2
I have the... (3 Replies)
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
I am trying to complete a script which will allow me to find:
a) reads a value from the keyboard. (ask the... (4 Replies)
From the below table I want to print highest value and lowest value using awk script.
aaa 55 66 96 77
ggg 22 96 77 23
ddd 74 58 18 3
kkk 45 89 47 92
zzz 34 58 89 92
Thanks, Green
edit by bakunin: it sure is not news to you that you should use CODE-tags, no? And that we do not want such... (3 Replies)
Dear Unix Gurus,
I have a text file with multiple columns, for example, see sample.txt below
0 1 301
1 4 250
2 6 140
3 2 610
7 1 180I want to find the maximum in, say, column 3, normalise all the values to this maximum value (to 4 decimal places) and spit everything into a new... (2 Replies)
Hello,
I need to find out the minimum and maximum values based on specific column, and then print out the entire row with the max value.
Infile.txt:
scf6 290173 290416 . + X_047241 T_00113118-1
scf6 290491 290957 . + X_047241 T_00113118-2
scf6 290898 290957 . + X_047241 T_00113119-3
scf6... (2 Replies)
Hello,
I want to get the maximum value of each record separated by empty line based on the 3rd column of each row within each record?
Input:
A1 chr5D 634 7 82 707
A2 chr5D 637 6 82 713
A3 chr5D 637 5 82 713
A4 chr5D 626 1 82 704... (4 Replies)
Hello everyone,
I am using ksh on Solaris 10 and I'm gathering data in a CSV file that looks like this:
20170628-23:25:01,1,0,0,1,1,1,1,55,55,1
20170628-23:30:01,1,0,0,1,1,1,1,56,56,1
20170628-23:35:00,1,0,0,1,1,2,1,57,57,2
20170628-23:40:00,1,0,0,1,1,1,1,58,58,2... (6 Replies)
Hi All,
I would like get the minimum value in the certain column with respect to other column.
For example, I have a text file like this.
ATOM 1 QSS SPH S 0 -2.790 -1.180 -2.282 2.28 2.28
ATOM 1 QSS SPH S 1 -2.915 -1.024 -2.032 2.31 2.31
ATOM 1 ... (4 Replies)
Discussion started by: bala06
4 Replies
LEARN ABOUT DEBIAN
jifty::manual::tutorialrest
Jifty::Manual::TutorialRest(3pm) User Contributed Perl Documentation Jifty::Manual::TutorialRest(3pm)NAME
Jifty::Manual::TutorialRest - Web Services
DESCRIPTION
This builds on Jifty::Manual::Tutorial, so make sure you have a running jifty that roughly resembles the step-by-step from there.
SETUP
You must add this to your site_config.yml
framework:
Plugins:
- REST: {}
See Jifty::Plugin::REST.
The commands assume that you have LWP installed with the GET alias. If not, you'll need to use the longhand lwp-request -m GET, or curl,
or your browser.
help
Make sure it is working:
$ GET http://localhost:8888/=/help
Accessing resources:
...
You should see some text describing the services, not html (that's longhand for 404.) Check the config and restart the server.
GET
Just list the models.
$ GET http://localhost:8888/=/model.yml
---
- MyWeblog.Model.Post
List the Post schema.
$ GET http://localhost:8888/=/model/Post.yml
---
body:
label: Content
name: body
readable: 1
sort_order: 1
type: text
writable: 1
id:
mandatory: 1
name: id
readable: 1
type: serial
writable: 0
title:
default: Untitled post
label: Title
name: title
readable: 1
sort_order: 0
type: text
writable: 1
You did make some posts, right?
$ GET http://localhost:8888/=/model/Post/id.yml
---
- 1
- 2
Dump the data:
$ GET http://localhost:8888/=/model/Post/id/1.yml
---
body: 'This is my post, the content of which is this, which is mine.'
id: 1
title: my first post
$ GET http://localhost:8888/=/model/Post/id/2.yml
---
body: "Content of another post. Got to go, the cat's on fire."
id: 2
title: post deux
POST
TODO not working
Actually, it looks like it is not supposed to work this way. Why not?
$ echo '---
body: "A post via web services"
id: 3
title: "posting from the command-line"
' | lwp-request -m POST http://localhost:8888/=/model/Post.yml
POST http://localhost:8888/=/model/Post/id/3.yml --> 404 Not Found
PUT
TODO not working
$ echo '---
title: "posting from the cli"
' | lwp-request -m PUT http://localhost:8888/=/model/Post/3.yml
500 Can't read entity body: Connection reset by peer
DELETE
$ lwp-request -m DELETE http://localhost:8888/=/model/Post/id/3.yml
---
content: {}
error: ~
field_errors: {}
field_warnings: {}
message: Deleted
success: 1
perl v5.14.2 2010-09-25 Jifty::Manual::TutorialRest(3pm)