|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
awk script concatenate two column and perform mutiplication
Post 303015396 by as7951 on Wednesday 4th of April 2018 05:41:31 AM
04-04-2018
Hi Rudic,
You are right, getting correct output..
sorry..i think sleepless nights have made me Mad..
Apologies again...
You are right, getting correct output..
sorry..i think sleepless nights have made me Mad..
Apologies again...
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a large CSV files (e.g. 2 million records) and am hoping to do one of two things. I have been trying to use awk and sed but am a newbie and can't figure out how to get it to work. Any help you could offer would be greatly appreciated - I'm stuck trying to remove the colon and wildcards in... (6 Replies)
Discussion started by: metronomadic
6 Replies
2. Shell Programming and Scripting
Hi everyone,
I'm trying to use the "join" function for more than 1 field. Since it's not possible as it is, I want to take my input files and concatenate the joining fields as 1 field (separated by "|"). I wrote 2 awk script to do and undo it (see below). However I'm new to awk and I'm certain I... (5 Replies)
Discussion started by: anthony.cros
5 Replies
3. 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
4. Shell Programming and Scripting
Hi,
I am new to awk/unix and am trying to put together an awk script to perform an action similar to vlookup between the two csv files.
Here are the contents of the two files:
File 1:
Date,ParentID,Number,Area,Volume,Dimensions
2014-01-01,ABC,247,83430.33,857.84,8110.76... (9 Replies)
Discussion started by: Prit Siv
9 Replies
5. Shell Programming and Scripting
Filter on one column and then perform conditional calculations on another column with a Linux script
Hi,
I have a file (stats.txt) with columns like in the example below. Destination IP address, timestamp, TCP packet sequence number and packet length.
destIP time seqNo packetLength
1.2.3.4 0.01 123 500
1.2.3.5 0.03 44 1500
1.3.2.5 0.08 44 1500
1.2.3.4 0.44... (12 Replies)
Discussion started by: Zooma
12 Replies
6. Shell Programming and Scripting
I have a file (myfile.txt) with contents like this:
1.txt apple is
3.txt apple is
5.txt apple is
2.txt apple is a
7.txt apple is a
8.txt apple is a fruit
4.txt orange not a fruit
6.txt zero isThe above file is already sorted using this command:
sort -k2 myfile.txtMy objective is to get... (3 Replies)
Discussion started by: shoaibjameel123
3 Replies
7. Shell Programming and Scripting
Have three files. Any other approach with regards to file concatenation or splitting, etc is appreciated
If column55(billngtype) of file1 contains YMNC or YPBC then pick the value of column13(documentnumber). Now find this documentnumber in column1(Billdoc) of file2 and grep the corresponding... (4 Replies)
Discussion started by: as7951
4 Replies
8. Shell Programming and Scripting
Hi Experts,
Need your support
I want to group/concatenate column 1,2,12 and 13 and if found duplicate then need to sum value of column 17,20,21 and column22. After concatenation if found unique then no action to be taken.
Secondly want to make duplicate rows basis on grouping/concatenation of... (1 Reply)
Discussion started by: as7951
1 Replies
9. Shell Programming and Scripting
Please help me to get required output for both scenario 1 and scenario 2 and need separate code for both scenario 1 and scenario 2
Scenario 1
i need to do below changes only when column1 is CR and column3 has duplicates rows/values. This inputfile can contain 100 of this duplicated rows of... (1 Reply)
Discussion started by: as7951
1 Replies
10. Shell Programming and Scripting
Need awk or Shell script to compare Column-1 of two different CSV files and print if column-1 matche
Example:
I have files in below format
file 1:
zxc,133,joe@example.com
cst,222,xyz@example1.com
File 2 Contains:
hxd
hcd
jws
zxc
cst
File 1 has 50000 lines and file 2 has around 30000 lines :
Expected Output has to be :
hxd
hcd
jws (5 Replies)
Discussion started by: TestPractice
5 Replies
LEARN ABOUT DEBIAN
sm2file
SM2FILE(1) ICI executables SM2FILE(1) NAME
sm2file - shared-memory linked list data extraction test program SYNOPSIS
sm2file DESCRIPTION
sm2file stress-tests shared-memory linked list data extraction by retrieving and deleting all text file lines inserted into a shared-memory linked list that is the root object of a PSM partition named "file2sm". The operation of sm2file echoes the cyclical operation of file2sm: the EOF lines inserted into the linked list by file2sm punctuate the writing of files that are copies of file2sm's original source text file. The name of each file written by sm2file is file_copy_cycleNbr, where cycleNbr is, in effect, the count of EOF lines encountered in the linked list up to the point at which the writing of this file began. sm2file may catch up with the data ingestion activity of file2sm, in which case it blocks (taking the file2sm test semaphore) until the linked list is no longer empty. EXIT STATUS
0 sm2file has terminated. FILES
No configuration files are needed. ENVIRONMENT
No environment variables apply. DIAGNOSTICS
can't attach to shared memory Operating system error. Check errtext, correct problem, and rerun. Can't manage shared memory. PSM error. Check for earlier diagnostics describing the cause of the error; correct problem and rerun. Can't create shared memory list. PSM error. Check for earlier diagnostics describing the cause of the error; correct problem and rerun. Can't create semaphore. ION system error. Check for earlier diagnostics describing the cause of the error; correct problem and rerun. Can't open output file Operating system error. Check errtext, correct problem, and rerun. can't write to output file Operating system error. Check errtext, correct problem, and rerun. BUGS
Report bugs to <ion-bugs@korgano.eecs.ohiou.edu> SEE ALSO
file2sm(1), smlist(3), psm(3) perl v5.14.2 2012-05-25 SM2FILE(1)