Sponsored Content
Top Forums Shell Programming and Scripting How to merge columns into lines, using unique keys? Post 302604930 by hemo21 on Tuesday 6th of March 2012 10:13:48 AM
Old 03-06-2012
How to merge columns into lines, using unique keys?

I would really appreciate a sulution for this :


Code:
invoice#    client#
5929    231
4358    231
2185    231
6234    231
1166    464
1264    464
3432    464
1720    464
9747    464
1133    791
4930    791
5496    791
6291    791
8681    989
3023    989
7935    989
8809    989
8873    989

My goal is to achieve this:

Client #    Invoice #
231    5929; 4358; 2185; 6234
464    1166; 1264; 3432; 1720; 9747
791    1133; 4930; 5496; 6291
989    8681; 3023; 7935; 8809; 8873

Thank you very much.
Hemo
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk : extracting unique lines based on columns

Hi, snp.txt CHR_A SNP_A BP_A_st BP_A_End CHR_B BP_B SNP_B R2 p-SNP_A p-SNP_B 5 rs1988728 74904317 74904318 5 74960646 rs1427924 0.377333 0.000740085 0.013930081 5 ... (12 Replies)
Discussion started by: genehunter
12 Replies

2. UNIX for Advanced & Expert Users

In a huge file, Delete duplicate lines leaving unique lines

Hi All, I have a very huge file (4GB) which has duplicate lines. I want to delete duplicate lines leaving unique lines. Sort, uniq, awk '!x++' are not working as its running out of buffer space. I dont know if this works : I want to read each line of the File in a For Loop, and want to... (16 Replies)
Discussion started by: krishnix
16 Replies

3. Shell Programming and Scripting

sort split merge -u unique

Hi, this is about sorting a very large file (like 10 gb) to keep lines with unique entries across SOME of the columns. The line originally looked like this: sort -u -k2,2 -k3,3n -k4,4n -k5,5n -k6,6n file_unsorted > file_sorted please note the -u flag. The problem is that this single... (4 Replies)
Discussion started by: jbr950
4 Replies

4. UNIX for Dummies Questions & Answers

How to count specific columns and merge with unique ones?

Hi. I am not sure the title gives an optimal description of what I want to do. I have several text files that contain data in many columns. All the files are organized the same way, but the data in the columns might differ. I want to count the number of times data occur in specific columns,... (0 Replies)
Discussion started by: JamesT
0 Replies

5. UNIX for Dummies Questions & Answers

Print unique lines without sort or unique

I would like to print unique lines without sort or unique. Unfortunately the server I am working on does not have sort or unique. I have not been able to contact the administrator of the server to ask him to add it for several weeks. (7 Replies)
Discussion started by: cokedude
7 Replies

6. Shell Programming and Scripting

Remove lines with unique information in indicated columns

Hi, I have the 3-column, tab-separated following data: dot is-big 2 dot is-round 3 dot is-gray 4 cat is-big 3 hot in-summer 5 I want to remove all of those lines in which the values of Columns 1 and 2 are identical. In this way, the results would be as follows: dot is-big 2 cat... (4 Replies)
Discussion started by: owwow14
4 Replies

7. Shell Programming and Scripting

Reading multiple values from multiple lines and columns and setting them to unique variables.

Hello, I would like to ask for help with csh script. An example of an input in .txt file is below, the number of lines varies from file to file and I have 2 or 3 columns with values. I would like to read all the values (probably one by one) and set them to independent unique variables that... (7 Replies)
Discussion started by: FMMOLA
7 Replies

8. Shell Programming and Scripting

How to merge two files with unique values matching.?

I have one script as below: #!/bin/ksh Outputfile1="/home/OutputFile1.xls" Outputfile2="/home/OutputFile2.xls" InputFile1="/home/InputFile1.sql" InputFile2="/home/InputFile2.sql" echo "Select hobby, class, subject, sports, rollNumber from Student_Table" >> InputFile1 echo "Select rollNumber... (3 Replies)
Discussion started by: Sharma331
3 Replies

9. UNIX for Beginners Questions & Answers

Merge 4 bim files by keeping only the overlapping variants (unique rs values )

Dear community, I am facing a problem and I kindly ask your help: I have 4 different data sets consisted from 3 different types of array. On each file, column 1 is chromosome position, column 2 is SNP id etc... Lets say I have the following (bim) datasets: x2014: 1 rs3094315... (4 Replies)
Discussion started by: fondan
4 Replies
drand48(3)						     Library Functions Manual							drand48(3)

Name
       drand48, erand48, lrand48, nrand48, mrand48, jrand48, srand48, seed48, lcong48 - generate uniformly distributed pseudo-random numbers

Syntax
       double drand48 ( )

       double erand48 (xsubi)
       unsigned short xsubi[3];

       long lrand48 ( )

       long nrand48 (xsubi)
       unsigned short xsubi[3];

       long mrand48 ( )

       long jrand48 (xsubi)
       unsigned short xsubi[3];

       void srand48 (seedval)
       long seedval;

       unsigned short *seed48 (seed16v)
       unsigned short seed16v[3];

       void lcong48 (param)
       unsigned short param[7];

Description
       NOTE: Your terminal may not be able to accurately display the special math symbols in this reference page. See the ULTRIX Programmer's Man-
       ual, Unsupported for a complete description of the math symbols.

       This family of functions generates pseudo-random numbers using the well-known linear congruential algorithm and 48-bit integer arithmetic.

       Functions and return non-negative double-precision floating-point values uniformly distributed over the interval [0.0, 1.0).

       Functions and return non-negative long integers uniformly distributed over the interval [0, 231).

       Functions and return signed long integers uniformly distributed
       over the interval [-231, 231).

       Functions and are initialization entry points, one of which should be invoked before either or is called.  Although it is  not  recommended
       practice,  constant  default  initializer  values  will be supplied automatically if or is called without a prior call to an initialization
       entry point.  Functions and do not require an initialization entry point to be called first.

       All the routines work by generating a sequence of 48-bit integer values, Xi, according to the linear congruential formula

							    Xn+1 = (aXn+c)mod m        n>=0.

       The parameter m=248; hence 48-bit integer arithmetic is performed.  Unless has been invoked, the multiplier value a and the addend value  c
       are given by

	     a = 5DEECE66D16 = 2736731631558
	     c = B16 = 138.

       The  value  returned  by  any of the functions or is computed by first generating the next 48-bit Xi in the sequence.  Then the appropriate
       number of bits, according to the type of data item to be returned, are copied from the high-order (leftmost) bits  of  Xi  and  transformed
       into the returned value.

       The  functions  and  store the last 48-bit Xi generated in an internal buffer; that is why they must be initialized prior to being invoked.
       The functions and require the calling program to provide storage for the successive Xi values in the array specified as	an  argument  when
       the  functions are invoked.  That is why these routines do not have to be initialized.  The calling program merely has to place the desired
       initial value of Xi into the array and pass it as an argument.  By using different arguments, functions and allow  separate  modules  of  a
       large  program  to generate several independent streams of pseudo-random numbers.  That is, the sequence of numbers in each stream will not
       depend upon how many times the routines have been called to generate numbers for the other streams.

       The initializer function sets the high-order 32 bits of Xi to the 32 bits contained in its argument.  The low-order 16 bits of Xi  are  set
       to the arbitrary value 330E16.

       The  initializer  function sets the value of Xi to the 48-bit value specified in the argument array.  In addition, the previous value of Xi
       is copied into a 48-bit internal buffer, used only by and a pointer to this buffer is the value returned by This  returned  pointer,  which
       can  just  be ignored if not needed, is useful if a program is to be restarted from a given point at some future time -- use the pointer to
       get at and store the last Xi value, and then use this value to reinitialize via when the program is restarted.

       The initialization function allows the user to specify the initial Xi, the multiplier value a, and the addend value c. Argument array  ele-
       ments param[0-2] specify Xi, param[3-5] specify the multiplier a, and param[6] specifies the 16-bit addend c. After has been called, a sub-
       sequent call to either or will restore the ``standard'' multiplier and addend values, a and c, specified on the previous page.

Notes
       The source code for the portable version can even be used on computers which do not have floating-point arithmetic.  In such  a	situation,
       functions and do not exist.  Instead, they are replaced by the two new functions below.

       long irand48 (m)
       unsigned short m;

       long krand48 (xsubi, m)
       unsigned short xsubi[3], m;

       Functions and return non-negative long integers uniformly distributed over the interval [0, m-1].

See Also
       rand(3)
       ULTRIX Programmer's Manual, Unsupported

																	drand48(3)
All times are GMT -4. The time now is 12:57 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy