08-12-2008
merging files
I will just add to simplyfy it more
file 11 abc jonny 1234
cde jigsw 1234
efg hary 1234
2 hjk nilof 2345
klm sumpr 2345
file 2john 1234
hanf 2345
output file john 1 abc jonny 1234
cde jigsw 1234
efg hary 1234
hanf 2 hjk nilof 2345
klm sumpr 2345
Here the file1 has 4th field and file 2 has 2nd field common.But the problem
is when the second line has only three field in file 1 , that is where the join
and paste command fails.
Is it possible?? Please guide ?? Thanks for your guidence.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have got two files
1.txt
1111|apple|
2222|orange|
2.txt
1111|1234|000000000004356|
1111|1234|000000001111|
1111|1234|002000011112|
2222|5678|000000002222|
2222|9102|000000002222|
I need to merge these two so that my out put looks like below:
Search code being used should be... (4 Replies)
Discussion started by: jisha
4 Replies
2. Shell Programming and Scripting
i would like to merge two files that have the same format but have different data.
i would like to create one output file that contains information from both the original files.:rolleyes: (2 Replies)
Discussion started by: joe black
2 Replies
3. Shell Programming and Scripting
Hi everyone,
I have two files which will be exactly same at first. After sometime there will be inserts in one file. My problem is how to reflect these changes in second file also.
I found out that any compare and merge utility would do the job like, GNU " sdiff " command. But the... (14 Replies)
Discussion started by: rameshonline
14 Replies
4. Shell Programming and Scripting
Hi,
I want to merge the two files on the basis of columns like...
file 1
Data Key
A 12
B 13
file2
Data Value
A A1
A A2
B B1
B B2 (5 Replies)
Discussion started by: clx
5 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I have two files a.txt and b.txt.
a.txt
1
2
3
4
b.txt
a
b
c
d
e
I want to generate a file c.txt by merging these two file and the resultant file would contain
c.txt
1 (4 Replies)
Discussion started by: siba.s.nayak
4 Replies
6. Shell Programming and Scripting
I have two files
file 1 containing x rows and 1 column
file 2 containing x rows and 1 column
I want to merge both the files and add a comma between the two
eg
plz guide (1 Reply)
Discussion started by: test_user
1 Replies
7. Shell Programming and Scripting
Hello all,
I have limited experience in shell scripting. Here goes my question:
I have two directories that have same number of files with same file names i.e. consider 2 directories A and B. Both directories have files 1.txt, 2.txt......
I need to merge the file 1.txt of A with file 1.txt... (5 Replies)
Discussion started by: jaysean
5 Replies
8. Shell Programming and Scripting
:::::::::
::FileA::
:::::::::
A1-------A2--------A3---A4---A5--
=================================
AC5VXVLT-XX----------------------
B57E434--XXXX1-----MMMM-ZZZ--111-
C325G20--XXXXX3----CCCC------3332
DC35S51--XXXXY1----DDDD------44X-
DC35S52--XXXXY2----DDDD------44Y-... (5 Replies)
Discussion started by: lordsmiter
5 Replies
9. Shell Programming and Scripting
Guys,
I am having little problem with getting a daily report!
The daily process that I do is as follows
1. Unload Header for the report from the systables to one unl file, say Header.unl
2. Unload the data from the required table/tables to another unl file, say Data.unl
3. Send a... (2 Replies)
Discussion started by: PikK45
2 Replies
10. Shell Programming and Scripting
Hi All ,
I have a scenario where we need to combine two files .
Below are the sample files and expected output ,
File 1:
1|ab
1|ac
1|ae
2|ad
2|ac
File 2:
1|xy
1|fc
2|gh
2|ku
Output file :
1|ab|xy (3 Replies)
Discussion started by: saj
3 Replies
LEARN ABOUT REDHAT
strfmon
STRFMON(3) Linux Programmer's Manual STRFMON(3)
NAME
strfmon - convert monetary value to a string
SYNOPSIS
#include <monetary.h>
ssize_t strfmon(char *s, size_t max, const char *format,
...);
DESCRIPTION
The strfmon() function formats the specified amounts according to the format specification format and places the result in the character
array s of size max.
Ordinary characters in format are copied to s without conversion. Conversion specifiers are introduced by a `%' character. Immediately
following it there can be zero or more of the following flags:
=f The single-byte character f is used as the numeric fill character (to be used with a left precision, see below). When not speci-
fied, the space character is used.
^ Do not use any grouping characters that might be defined for the current locale. By default, grouping is enabled.
( or + The ( flag indicates that negative amounts should be enclosed between parentheses. The + flag indicates that signs should be handled
in the default way, that is, amounts are preceded by the locale's sign indication, e.g., nothing for positive, "-" for negative.
! Omit the currency symbol.
- Left justify all fields. The default is right justification.
Next, there may be a field width: a decimal digit string specifying a minimum field width in bytes. The default is 0. A result smaller
than this width is padded with spaces (on the left, unless the left-justify flag was given).
Next, there may be a left precision of the form "#" followed by a decimal digit string. If the number of digits left of the radix character
is smaller than this, the representation is padded on the left with the numeric fill character. Grouping characters are not counted in
this field width.
Next, there may be a right precision of the form "." followed by a decimal digit string. The amount being formatted is rounded to the spec-
ified number of digits prior to formatting. The default is specified in the frac_digits and int_frac_digits items of the current locale.
If the right precision is 0, no radix character is printed. (The radix character here is determined by LC_MONETARY, and may differ from
that specified by LC_NUMERIC.)
Finally, the conversion specification must be ended with a conversion character. The three conversion characters are
% (In this case the entire specification must be exactly "%%".) Put a `%' character in the result string.
i One argument of type double is converted using the locale's international currency format.
n One argument of type double is converted using the locale's national currency format.
RETURN VALUE
The strfmon() function returns the number of characters placed in the array s, not including the terminating NUL character, provided the
string, including the terminating NUL, fits. Otherwise, it sets errno to E2BIG, returns -1, and the contents of the array is undefined.
EXAMPLE
The call
strfmon(buf, sizeof(buf), "[%^=*#6n] [%=*#6i]",
1234.567, 1234.567);
outputs
[ fl **1234,57] [ NLG **1 234,57]
in the Dutch locale (with fl for "florijnen" and NLG for Netherlands Guilders). The grouping character is very ugly because it takes as
much space as a digit, while it should not take more than half that, and will no doubt cause confusion. Surprisingly, the "fl" is preceded
and followed by a space, and "NLG" is preceded by one and followed by two spaces. This may be a bug in the locale files. The Italian, Aus-
tralian, Swiss and Portuguese locales yield
[ L. **1235] [ ITL **1.235]
[ $**1234.57] [ AUD **1,234.57]
[Fr. **1234,57] [CHF **1.234,57]
[ **1234$57Esc] [ **1.234$57PTE ]
SEE ALSO
setlocale(3), sprintf(3), locale(7)
Linux 2000-12-05 STRFMON(3)