Sponsored Content
Top Forums Shell Programming and Scripting Merge Two Files based on First column Post 302305528 by apjneeraj on Thursday 9th of April 2009 07:01:28 AM
Old 04-09-2009
Thanks buddy. But still the order is not correct. The lines from both files got together correctly but order is not correct.

for example:

input1:
Code:
123  abc
456  def

input2:
Code:
123  ijk
123  ijk
456  lmn
456  lmn

output using sort command is :
Code:
456  def
456  lmn
456  lmn
123  abc
123  ijk
123  ijk

But i need output as:
Code:
123  abc
123  ijk
123  ijk
456  def
456  lmn
456  lmn

Hope you understand my point.

Thanks
Neeraj

Last edited by Yogesh Sawant; 04-10-2009 at 04:34 AM.. Reason: added code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merge files based on key

Hi Friends, Can any one help me with merging these file based on two columns : File1: A|123|99|SAMS B|456|95|GEORGE D|789|85|HOVARD File2: S|123|99|NANcY|6357 S|123|99|GREGRO|83748 A|456|95|HARRY|827|somers S|456|95|ANTONY|546841|RUDOLPH|7263 B|456|95|SMITH|827|BOISE STATE|834... (3 Replies)
Discussion started by: sbasetty
3 Replies

2. Shell Programming and Scripting

merge rows based on a common column

Hi guys, Please guide me if you have a solution to this problem. I have tried paste -s but it's not giving the desired output. I have a file with the following content- A123 box1 B345 bat2 C431 my_id A123 service C431 box1 A123 my_id I need two different outputs- OUTPUT1 A123... (6 Replies)
Discussion started by: smriti_shridhar
6 Replies

3. Shell Programming and Scripting

merge two two txt files into one file based on one column

Hi, I have file1.txt and file2.txt and would like to create file3.txt based on one column in UNIX Eg: file1.txt 17328756,0000786623.pdf,0000786623 20115537,0000793892.pdf,0000793892 file2.txt 12521_74_4.zip,0000786623.pdf 12521_15_5.zip,0000793892.pdf Desired Output ... (5 Replies)
Discussion started by: techmoris
5 Replies

4. Shell Programming and Scripting

"Join" or "Merge" more than 2 files into single output based on common key (column)

Hi All, I have working (Perl) code to combine 2 input files into a single output file using the join function that works to a point, but has the following limitations: 1. I am restrained to 2 input files only. 2. Only the "matched" fields are written out to the "matched" output file and... (1 Reply)
Discussion started by: Katabatic
1 Replies

5. Shell Programming and Scripting

Help with merge two file based on similar column content

Input file 1: A1BG A1BG A1BG A1CF A1CF BCAS BCAS A2LD1 A2M A2M HAT . . Input file 2: A1BG All A1CF TEMP (5 Replies)
Discussion started by: perl_beginner
5 Replies

6. Shell Programming and Scripting

Merge files based on the column value

Hi Friends, I have a file file1.txt 1|ABC|3|jul|dhj 2|NHU|4|kil|eu 3|hjd|34|hfd|43 file2.txt 1||3|KING|dhj 2|NHU||k| 3|hjd|34|hd|43 i want to merge file1.txt file2.txt based on the column null values in file2.txif there are any nulls in column values , (5 Replies)
Discussion started by: i150371485
5 Replies

7. Shell Programming and Scripting

Merge files based on columns

011111123444 1234 1 20000 011111123444 1235 1 30000 011111123446 1234 3 40000 011111123447 1234 4 50000 011111123448 1234 3 50000 File2: 011111123444,Rsttponrfgtrgtrkrfrgtrgrer 011111123446,Rsttponrfgtrgtr 011111123447,Rsttponrfgtrguii 011111123448,Rsttponrfgtrgtjiiu I have 2 files... (4 Replies)
Discussion started by: vinus
4 Replies

8. UNIX for Dummies Questions & Answers

How to merge two tables based on a matched column?

Hi, Please excuse me , i have searched unix forum, i am unable to find what i expect , my query is , i have 2 files of same structure and having 1 similar field/column , i need to merge 2 tables/files based on the one matched field/column (that is field 1), file 1:... (5 Replies)
Discussion started by: karthikram
5 Replies

9. Shell Programming and Scripting

awk - Merge two files based on one key

Hi, I am struggling with the an awk command to merge two files based on a common key. I want to append the value from File2 ($2) onto the end of File1 where $1 from each file matches - If no match then nothing is apended File1 COL1|COL2|COL3|COL4|COL5|COL6|COL7... (3 Replies)
Discussion started by: Ads89
3 Replies

10. Linux

Merge two files based on matching criteria

Hi, I am trying to merge two csv files based on matching criteria: File description is as below : Key_File : 000|ÇÞ|Key_HF|ÇÞ|Key_FName 001|ÇÞ|Key_11|ÇÞ|Sort_Key22|ÇÞ|Key_31 002|ÇÞ|Key_12|ÇÞ|Sort_Key23|ÇÞ|Key_32 003|ÇÞ|Key_13|ÇÞ|Sort_Key24|ÇÞ|Key_33 050|ÇÞ|Key_15|ÇÞ|Sort_Key25|ÇÞ|Key_34... (3 Replies)
Discussion started by: PK29
3 Replies
strfmon(3C)															       strfmon(3C)

NAME
strfmon - convert monetary value to string SYNOPSIS
Remarks The ANSI C "" construct denotes a variable length argument list whose optional [or required] members are given in the associated comment DESCRIPTION
The function places characters into the array pointed to by s as controlled by the string pointed to by format. No more than maxsize 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, and conver- sion specifications, each of which results in the fetching of zero or more arguments that are converted and formatted. The arguments are of type see the section for details. The results are undefined if there are insufficient arguments for the format. If the format is exhausted while arguments remain, the excess arguments are ignored. A conversion specification is the string flag]...[field_width][right_precision] conversion_character Each element of the sequence is specified as follows: Flags One or more of the following optional flags can be specified to control the conversion: An (equal sign) followed by a single character f which is used as the numeric fill character. The fill character must be repre- sentable 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. Specify the style for representing positive and negative currency amounts. Only one of or (plus sign or left parenthesis) may be specified. If is specified, the locale's equivalent of + and - are used (for example, in the locale: an empty string if positive and - if negative). 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. A minus sign specifying 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 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 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 formatted 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 numeric fill character (see the 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 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: The argument is formatted according to the locale's international currency format (for example, in the locale: The argument is formatted according to the locale's national currency format (for example, in the locale: Convert to a no argument is converted. The entire conversion specification must be %%. Notes The behavior of the function in a UNIX 2003 conforming application differs from its behavior in a non-conforming application. With the conversion character the function uses the fourth character of the string defined in of the current locale instead of a space as a separa- tor for separating different items in a monetary quantity as dictated by the values of and Only the first three characters will be taken as the currency symbol. As a result, the formatting of internationally formatted monetary quantities may change. EXTERNAL INFLUENCES
Locale The 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 category), the grouping separator, the currency symbols and formats. RETURN VALUE
If the total number of resulting bytes including the terminating null byte is not more than maxsize, the function 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 function will fail if: Conversion stopped due to lack of space in the buffer. EXAMPLES
The following program segment formats the monetary value using the locale with a left precision of and as the fill character. char string[31]; double amt = -4321.123; setlocale(LC_MONETARY, "en_US.roman8"); strfmon(string, 31, "The amount is %=*#5n.", amt); The string array will contain: The amount is -$*4,321.12. As an other example, given the locale of and the values and --------------------------------------------------------------------------- Conversion Output Comments Specification --------------------------------------------------------------------------- %n $123.45 default formatting -$123.45 $3,456.78 --------------------------------------------------------------------------- %11n $123.45 right align within an 11 character field -$123.45 $3,456.78 --------------------------------------------------------------------------- %#5n $ 123.45 align columns for values up to 99,999 -$ 123.45 $ 3,456.78 --------------------------------------------------------------------------- %=*#5n $***123.45 specify a fill character -$***123.45 $*3,456.78 --------------------------------------------------------------------------- %=0#5n $000123.45 fill characters do not use grouping -$000123.45 even if the fill character is a digit $03,456.78 --------------------------------------------------------------------------- %^#5n $ 123.45 disable the grouping separator -$ 123.45 $ 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 positive/negative style ($ 123.45) $ 3,456.78 --------------------------------------------------------------------------- %!(#5n 123.45 disable the currency symbol ( 123.45) 3,456.78 --------------------------------------------------------------------------- AUTHOR
was developed by HP. SEE ALSO
localeconv(3C), thread_safety(5). STANDARDS CONFORMANCE
strfmon(3C)
All times are GMT -4. The time now is 09:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy