Sponsored Content
Full Discussion: Merging data in a file
Top Forums UNIX for Dummies Questions & Answers Merging data in a file Post 302568416 by CarloM on Thursday 27th of October 2011 09:09:27 AM
Old 10-27-2011
You could do something like this:
Code:
# cat xx.awk
function dumpline ()
{
   for (i=2;i<=linesize;i++) {
      if (i > 2) {
         printf ("%s",FS);
      }
      printf ("%s",currline[i]);
   }
   printf ("\n");
}
$1 ~ /*/ {
   if (NR != 1) {
      dumpline();
   }
   linesize=split ($0, currline);
}
$1 !~ /*/ {
   currline[5]=currline[5]+$5
   currline[6]=currline[6]+$6
}
END {
   dumpline();
}
# awk -F, -f xx.awk test.csv
None Pack,1003036,Curr Emp Ref Request Quote No 2,109,10
None Pack,1004345,KFI Chase Quote No 1,2,2
None Pack,1006148,KFI Chase Quote No 1,1,1
None Pack,1004979,Curr Emp Ref Request Quote No 1,2,2
None Pack,1003031,Curr Emp Ref Request Quote No 3,2,2
None Pack,1003030,Curr Emp Ref Request Quote No 2,4,4
None Pack,1003037,Curr Acc Ref Request Quote No 2,3,3
None Pack,1004820,Curr Acc Ref Request Quote No 1,3,3
None Pack,1003037,Curr Emp Ref Request Quote No 2,7,7
None Pack,1003030,Curr Emp Ref Request Quote No 2,4,4

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merging data

Hi, I have the following problem: Input: "num1","num2","num3",num4,num5,"num6" required output: "num1num2","num3",num4,num5,"num6" I need to join field 1 and field 2 together but I always end up getting: "num1""num2","num3",num4,num5,"num6" Note that not all fields have " at both... (8 Replies)
Discussion started by: ReV
8 Replies

2. Shell Programming and Scripting

Need help for 2 data file merging

Hello Please help me to write Shell script. I want to merge 2 data files . The data files have common columns The data file A have 3 columns Host Version Numberof Failuers The data file B have also 3 coulmns Host Version NumberofFailuers . I want to merge A and B file... (2 Replies)
Discussion started by: getdpg
2 Replies

3. Shell Programming and Scripting

merging CSV data using a one liner from shell?

I'm trying to merge multiple CSV (comma separated value) files into one large master file. All files have a field that is unique to act as the key for entry/merging into the master file & and all files have the same number of fields that are in the master file. I'll give an example here: ... (2 Replies)
Discussion started by: jjinca
2 Replies

4. Shell Programming and Scripting

Merging last and syslog data on time

This is on a HP-UX system. I need to merge the 2 reports, for each line in syslog I need to lookup who was logged in to the pts/# based on the time from the last.txt report. Here is what I get from sulog.log cat syslog | grep "su:" | grep "Jun 14" Jul 14 08:02:48 server1 su: - 2 ... (8 Replies)
Discussion started by: Ikon
8 Replies

5. Shell Programming and Scripting

Removing Carriage return and merging data

Hi, I am trying to remove the carriage return on the record which starts with ADD, MODIFY, or DELETE keyword as the first value in the record. If the records does not start with anyone of these keywords then combine the records with the previous record (line). Input File name xyz.txt... (6 Replies)
Discussion started by: naveed
6 Replies

6. Shell Programming and Scripting

formatting and merging 2 data files

Hi, I have 2 files that I got as an output from another program. They are : File 1 ((((((CtBJa:197.0,CtBTz:197.0):85.0,CtAHr:197.0):116.0,CtDUw:197.0):176.0,CtSwe:197.0):110.0, (CtL2b:197.0,Ct4Bu:197.0):196.0):197.0,CmuNg:197.0);... (5 Replies)
Discussion started by: Lucky Ali
5 Replies

7. Shell Programming and Scripting

Merging data from 2 files of different lengths?

Hi all, Sorry if someone has answered something like this already, but I have a problem. I am not brilliant with "awk" but think it should be the command to use to get what I am after. I have 2 files: job-file (several hundred lines like): 1018003,LONG MU WAN,1113S 1018004,LONG MU... (4 Replies)
Discussion started by: sgb2301
4 Replies

8. Shell Programming and Scripting

Merging data from one file into another

Hello, I have a master database of a dictionary with the following structure: a=b (b is a Unicode string) a is the English part and b is the equivalent in a foreign language I have also another file which has a database where the /b/ part of the string has been corrected by an expert. let us... (5 Replies)
Discussion started by: gimley
5 Replies

9. Shell Programming and Scripting

Help with merging data into single line.

Hi, My input is <message> looking for a big <message>Does fit my G74 laptop. Makes the 10 pound. <message> <message>This bag is the only one I could find to fit my awesome ASUS G74S. <message> <message> Great bag my only wish is that they had put a pocket in which to store and... (6 Replies)
Discussion started by: pamu
6 Replies

10. Shell Programming and Scripting

Merging data horizontally with newlines in files

Hi Everyone, I have two files file1 and file2 with these contents cat file1 AAAAA 01/03/2014 04:01:23 BBBB 01/03/2014 03:03:34 CCCcc 01/03/2014 03:03:34 cat file2 1 RED 1 HHHH 1 TTTT 1 BBBBB I tried the below... (2 Replies)
Discussion started by: Aditya_001
2 Replies
TRACECONVERT(1) 						   User Commands						   TRACECONVERT(1)

NAME
traceconvert - convert a trace from one format to another SYNOPSIS
traceconvert inputuri outputuri ... DESCRPTION
traceconvert copies all packets from an inputuri to an output uri converting the trace as necessary. traceconvert is a shellscript wrapper around tracesplit(1) EXAMPLES
traceconvert erf:/traces/bigtrace.gz pcap:- | tcpdump -r - -n LINKS
More details about traceconvert (and libtrace) can be found at http://www.wand.net.nz/trac/libtrace/wiki/UserDocumentation SEE ALSO
libtrace(3), tracemerge(1), tracesplit(1), tracefilter(1), tracesummary(1), tracereport(1), tracesplit_dir(1), tracestats(1), tracert- stats(1), tracepktdump(1), traceanon(1), tracereplay(1), tracediff(1), traceends(1), tracetopends(1) AUTHORS
Perry Lorier <perry@cs.waikato.ac.nz> traceconvert (libtrace) October 2005 TRACECONVERT(1)
All times are GMT -4. The time now is 11:06 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy