|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Taking nth column and putting its value in n+1 column using awk
Post 302963466 by umarsatti on Thursday 31st of December 2015 01:45:54 AM
12-31-2015
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi everyone, this is my first post here, I hope someone can help me.
I have a file which I need to delete characters '_F3' from the end of the text in the first column. The problem is that the characters may also occur elsewhere in the file (i.e. second columns onwards). I tried sed (thinking I... (6 Replies)
Discussion started by: hlwright
6 Replies
2. Shell Programming and Scripting
I have an awk script to find the maximum value of the 2nd column of a 2 column datafile, but I need to find the top 5 maximum values of the 2nd column.
Here is the script that works for the maximum value.
awk 'BEGIN { subjectmax=$1 ; max=0} $2 >= max {subjectmax=$1 ; max=$2} END {print... (3 Replies)
Discussion started by: ncwxpanther
3 Replies
3. Shell Programming and Scripting
Is there an awk script that can easily perform the following operation?
I have a data file that is in the format of
1944-12,5.6
1945-01,9.8
1945-02,6.7
1945-03,9.3
1945-04,5.9
1945-05,0.7
1945-06,0.0
1945-07,0.0
1945-08,0.0
1945-09,0.0
1945-10,0.2
1945-11,10.5
1945-12,22.3... (3 Replies)
Discussion started by: ncwxpanther
3 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,
i have the following code :
somevariable=`mysql -u root --password="" databasename -e "select count(column_name) from table_name where id=1 and id_age=2 ; " --skip-column-names -s -N`
if ]
then ....
It gives the message
")syntax error: invalid arithmetic operator (error... (2 Replies)
Discussion started by: juve11
2 Replies
6. Shell Programming and Scripting
Hello Members,
I have a csv file in the format below. Need help with awk statement to break nth column into 3 separate columns and export the changes to new file.
input file --> file.csv
cat file.csv|less
"product/fruit/mango","location/asia/india","type/alphonso"
need output in... (2 Replies)
Discussion started by: awk-admirer
2 Replies
7. Shell Programming and Scripting
awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column
Hi,
My input files is like this
axis1 0 1 10
axis2 0 1 5
axis1 1 2 -4
axis2 2 3 -3
axis1 3 4 5
axis2 3 4 -1
axis1 4 5 -6
axis2 4 5 1
Now, these are my following tasks
1. Print a first column for every two rows that has the same value followed by a string.
2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies
8. Shell Programming and Scripting
I need to be able to search for a string in the first column and if that string exists than replace the nth column with "-9.99".
AW12000012012 2.38 1.51 3.01 1.66 0.90 0.91 1.22 0.82 0.57 1.67 2.31 3.63 0.00
AW12000012013 1.52 0.90 1.20 1.34 1.21 0.67 ... (14 Replies)
Discussion started by: ncwxpanther
14 Replies
9. Shell Programming and Scripting
I am passing a variable and replace nth value with the variable.
I tried using many options in awk command but unable to ignore the special characters in the output and also unable to pass the actual value.
Input : "1","2","3"
Output : "1","1000","3"
TempVal=`echo 1000`
Cat... (2 Replies)
Discussion started by: onesuri
2 Replies
10. Shell Programming and Scripting
Hi guys,
I have problem to append new data at the end of each line of the files where it takes whole value of the nth column. My expected result i just want to take a specific value only. This new data is based on substring of 11th, 12th 13th column that has comma seperated value.
My code:
awk... (4 Replies)
Discussion started by: null7
4 Replies
LEARN ABOUT OSF1
suggest
diction(1) General Commands Manual diction(1) NAME
diction, explain, suggest - Prints wordy sentences and looks them up in an interactive thesaurus. SYNOPSIS
diction [-fpattern_file] [-k] [-ma] [-me] [-ml] [-ms] [-n] [file...] explain suggest The diction command finds all sentences in an English language document that contain phrases from a database of bad or wordy diction. The explain command is an interactive thesaurus for the English language phrases found by the diction command and only for those phrases. The diction command reads from standard in if no file operand is provided. The suggest command is a synonym for explain. OPTIONS
Names a user-created pattern file to be used in addition to the default file. Passes the -k option to the deroff command. The -k option keeps blocks of text specified nroff by requests or macros; for example, the request. Passes the -ma option to deroff. The -ma option interprets nroff man macros only. Overrides the default nroff -ms macro package. Causes deroff to skip lists; should be used if a docu- ment contains many lists of nonsentences. Overrides the default nroff -ms macro package. Suppresses use of the default file (used with -f). Only the user-created pattern file is used. DESCRIPTION
Each phrase found by the diction command is enclosed in [ ] (brackets). Because diction runs deroff before looking at the text, include formatting header files as part of the input. Before using the explain command, use the diction command to obtain a list of poorly worded phrases. When you use the explain command, the system prompts you for a phrase and responds with a grammatically acceptable alternative. You can continue typing phrases, or you can exit by pressing the End-of-File key sequence. The explain command can also take input redirected from a file. No other command line arguments are valid. NOTES
Use of nonstandard formatting macros may cause incorrect sentence breaks. In particular, diction does not understand -me. FILES
Default pattern file. Thesaurus used by the explain command. SEE ALSO
Commands: deroff(1), nroff(1) diction(1)