Sponsored Content
Top Forums Shell Programming and Scripting Merge two columns from two files into one if another column matches Post 302723103 by guruprasadpr on Monday 29th of October 2012 11:45:26 AM
Old 10-29-2012
Hi

Code:
$ join -1 1 -2 1  f1  f2 | awk '!a[$2$3]++{print $1,$2$3}'
A:B:C 123456
D:E:F 234567
G:H:I 345678
M:N:O 456789
P:Q:R 567890

Guru.
This User Gave Thanks to guruprasadpr For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Joining columns from two files, if the key matches

I am trying to join/paste columns from two files for the rows with matching first field. Any help will be appreciated. Files can not be sorted and may not have all rows in both files. Thanks. File1 aaa 111 bbb 222 ccc 333 File2 aaa sss mmmm ccc kkkk llll ddd xxx yyy Want to... (1 Reply)
Discussion started by: sk_sd
1 Replies

2. Shell Programming and Scripting

merge the two files which has contain columns

Hi may i ask how to accomplish this task: I have 2 files which has multiple columns first file 1 a 2 b 3 c 4 d second file 14 a 9 .... 13 b 10.... 12 c 11... 11 d 12... I want to merge the second file to first file that will looks like this ... (2 Replies)
Discussion started by: jao_madn
2 Replies

3. Shell Programming and Scripting

Merge columns of different files

Hi, I have tab limited file 1 and tab limited file 2 The output should contain common first column vales and corresponding 2nd column values; AND also unique first column value with corresponding 2nd column value of the file that contains it and 0 for the second file. the output should... (10 Replies)
Discussion started by: polsum
10 Replies

4. Shell Programming and Scripting

How to merge multiple rows into single row if first column matches ?

Hi, Can anyone suggest quick way to get desired output? Sample input file content: A 12 9 A -0.3 2.3 B 1.0 -4 C 34 1000 C -111 900 C 99 0.09 Output required: A 12 9 -0.3 2.3 B 1.0 -4 C 34 1000 -111 900 99 0.09 Thanks (3 Replies)
Discussion started by: cbm_000
3 Replies

5. UNIX for Dummies Questions & Answers

How do I merge multiple columns into one column?

Hi all, I'm looking for a way to merge multiple columns (from one file) into a single column in an output file. The file I have looks somewhat like this: @HWI-ST212 1:N:0 AGTCCTACCGGGAGT + @@@DDDDDHHHHHII @HWI-ST212 1:N:0 CGTTTAAAAATTTCT + @;@B;DDDDH?:F;F... (4 Replies)
Discussion started by: Vnguyen
4 Replies

6. Shell Programming and Scripting

How to get difference of the same column between two files when other column matches?

File 1: 20130416,235800,10.78.25.104,BR2-loc,60.0,1624,50.0,0,50.0,0 20130416,235800,10.78.25.104,BR1-LOC,70.0,10,50.0,0,70.0,0 20130416,235800,10.78.25.104,Hub_None,60.0,15,60.0,0,50.0,0 File 2: 20130417,000200,10.78.25.104,BR2-loc,60.0,1626,50.0,0,50.0,0... (3 Replies)
Discussion started by: Lakshmikumari
3 Replies

7. Shell Programming and Scripting

Merge columns on different files

Hello, I have two files that have this format: file 1 86.82 0.00 86.82 43.61 86.84 0.00 86.84 43.61 86.86 0.00 86.86 43.61 86.88 0.00 86.88 43.61 file 2 86.82 0.22 86.84 0.22 86.86 0.22 86.88 0.22 I would like to merge these two files such that the final file looks like... (5 Replies)
Discussion started by: kayak
5 Replies

8. Shell Programming and Scripting

Seperated by columns, merge in a file, sort them on common column

Hi All, I have 4 files in below format. I took them as an example. File 1: Cut from position 1-4 then 6-7 then 8-14 then rest left and make them as columns in one new file. Inserting character H to the initial of all line like HCTOT. CTOT 456787897 Low fever CTOR 556712345 High fever... (2 Replies)
Discussion started by: Mannu2525
2 Replies

9. UNIX for Beginners Questions & Answers

Matches columns from two different files in shell script

Hi friends, i want to compare first columns from two different files ,if equal print the file2's second column else print the zero.Please help me... file1: a b c d efile2: a 1 c 20 e 30 desired output: 1 0 20 0 30 Please use CODE tags as required by forum rules! Please post in... (1 Reply)
Discussion started by: bhaskar illa
1 Replies

10. Shell Programming and Scripting

awk add all columns if column 1 name matches

Hi - I want to add all columns if column1 name matches. TOPIC1 5 1 4 TOPIC2 3 2 1 TOPIC3 7 2 5 TOPIC1 6 3 3 TOPIC2 4 1 3 TOPIC3 9 5 4 . . . . . . . . . . . . Result should look like TOPIC1 11 4 7 TOPIC2 7 3 4 (1 Reply)
Discussion started by: oraclermanpt
1 Replies
strfmon(3C)						   Standard C Library Functions 					       strfmon(3C)

NAME
strfmon - convert monetary value to string SYNOPSIS
#include <monetary.h> ssize_t strfmon(char *restrict s, size_t maxsize, const char *restrict format, ...); DESCRIPTION
The strfmon() function places characters into the array pointed to by s as controlled by the string pointed to by format. No more than max- size bytes are placed into the array. The format is a character string that contains two types of objects: plain characters, which are simply copied to the output stream, and conversion specifications, each of which results in the fetching of zero or more arguments which are converted and formatted. The results are undefined if there are insufficient arguments for the format. If the format is exhausted while arguments remain, the excess arguments are simply ignored. A conversion specification consists of the following sequence: o a % character o optional flags o optional field width o optional left precision o optional right precision o a required conversion character that determines the conversion to be performed. Flags One or more of the following optional flags can be specified to control the conversion: =f An = followed by a single character f which is used as the numeric fill character. The fill character must be representable in a single byte in order to work with precision and width counts. The default numeric fill character is the space character. This flag does not affect field width filling which always uses the space character. This flag is ignored unless a left precision (see below) is specified. ^ Do not format the currency amount with grouping characters. The default is to insert the grouping characters if defined for the current locale. + or ( Specify the style of representing positive and negative currency amounts. Only one of `+' or `(' may be specified. If `+' is spec- ified, the locale's equivalent of + and `-' are used (for example, in the U.S.A.: the empty string if positive and `-' if nega- tive). If `(' is specified, negative amounts are enclosed within parentheses. If neither flag is specified, the `+' style is used. ! Suppress the currency symbol from the output conversion. - Specify the alignment. If this flag is present all fields are left-justified (padded to the right) rather than right-justified. Field Width w A decimal digit string w specifying a minimum field width in bytes in which the result of the conversion is right-justified (or left-justified if the flag `-' is specified). The default is zero. Left Precision #n A `#' followed by a decimal digit string n specifying a maximum number of digits expected to be formatted to the left of the radix character. This option can be used to keep the formatted output from multiple calls to the strfmon() aligned in the same columns. It can also be used to fill unused positions with a special character as in $***123.45. This option causes an amount to be format- ted as if it has the number of digits specified by n. If more than n digit positions are required, this conversion specification is ignored. Digit positions in excess of those actually required are filled with the numeric fill character (see the =f flag above). If grouping has not been suppressed with the `^' flag, and it is defined for the current locale, grouping separators are inserted before the fill characters (if any) are added. Grouping separators are not applied to fill characters even if the fill character is a digit. To ensure alignment, any characters appearing before or after the number in the formatted output such as currency or sign symbols are padded as necessary with space characters to make their positive and negative formats an equal length. Right Precision .p A period followed by a decimal digit string p specifying the number of digits after the radix character. If the value of the right precision p is zero, no radix character appears. If a right precision is not included, a default specified by the current locale is used. The amount being formatted is rounded to the specified number of digits prior to formatting. Conversion Characters The conversion characters and their meanings are: i The double argument is formatted according to the locale's international currency format (for example, in the U.S.A.: USD 1,234.56). n The double argument is formatted according to the locale's national currency format (for example, in the U.S.A.: $1,234.56). % Convert to a %; no argument is converted. The entire conversion specification must be %%. Locale Information The LC_MONETARY category of the program's locale affects the behavior of this function including the monetary radix character (which may be different from the numeric radix character affected by the LC_NUMERIC category), the grouping separator, the currency symbols and formats. The international currency symbol should be in conformance with the ISO 4217: 1987 standard. RETURN VALUES
If the total number of resulting bytes (including the terminating null byte) is not more than maxsize, strfmon() returns the number of bytes placed into the array pointed to by s, not including the terminating null byte. Otherwise, -1 is returned, the contents of the array are indeterminate, and errno is set to indicate the error. ERRORS
The strfmon() function will fail if: ENOSYS The function is not supported. E2BIG Conversion stopped due to lack of space in the buffer. USAGE
The behavior of strfmon() in an SUSv3-conforming application differs from its behavior in a non-conforming application as follows: o With the conversion 'i', strfmon() uses information set to int_p_cs_precedes, int_n_cs_precedes, int_p_sep_by_space, int_n_sep_by_space, int_p_sign_posn, and int_n_sign_posn of the current locale instead of p_cs_precedes, n_cs_precedes, p_sep_by_space, n_sep_by_space, p_sign_posn, and n_sign_posn, respectively. o With the conversion 'i', strfmon() uses the fourth character of the string set to int_curr_symbol of the current locale instead of a space for int_p_sep_by_space and int_n_sep_by_space. o When the value of p_sep_by_space, n_sep_by_space, int_p_sep_by_space, or int_n_sep_by_space is set to 2 in the current locale, strf- mon() separates the currency symbol from the sign string by a space, if adjacent; otherwise, strfmon() separates the sign string from the value by a space. EXAMPLES
Example 1: A sample output of strfmon(). Given a locale for the U.S.A. and the values 123.45, -123.45, and 3456.781: +------------------------------------------------------------------------+ | Conversion Output Comments | |Specification | |%n $123.45 default formatting | | -$123.45 | | $3,456.78 | |%11n $123.45 right align within an 11 | | -$123.45 character field | | $3,456.78 | |%#5n $123.45 aligned columns for values | | -$123.45 up to 99,999 | | $3,456.78 | |%=*#5n $***123.45 specify a fill character | | -$***123.45 | | $*3,456.78 | |%=0#5n $000123.45 fill characters do not use | | -$000123.45 grouping even if the fill | | $03,456.78 character is a digit | |%^#5n $123.45 disable the grouping | | -$123.45 separator | | $3456.78 | |%^#5.0n $123 round off to whole units | | -$123 | | $3457 | |%^#5.4n $123.4500 increase the precision | | -$123.4500 | | $3456.7810 | |%(#5n 123.45 use an alternative | | ($123.45) pos/neg style | | $3,456.78 | |%!(#5n 123.45 disable the currency | | (123.45) symbol | | 3,456.78 | +------------------------------------------------------------------------+ ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |CSI |Enabled | +-----------------------------+-----------------------------+ |Interface Stability |Standard | +-----------------------------+-----------------------------+ |MT-Level |MT-Safe with exceptions | +-----------------------------+-----------------------------+ Th strfmon() function can be used safely in multithreaded applications, as long as setlocale(3C) is not called to change the locale. SEE ALSO
localeconv(3C), setlocale(3C), attributes(5), standards(5) SunOS 5.10 1 Nov 2003 strfmon(3C)
All times are GMT -4. The time now is 09:18 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy