11-28-2009
count numbers of matching rows and replace its value in another file
Hello all,
can you help me in this problem, assume We have two txt file (file_1 and file_3) one is file_1 contains the data:
a 0
b 1
c 3
a 7
b 4
c 5
b 8
d 6
.
.
.
.
and I need to count the lines with the matching data (a,b,..) and print in new file called file_2 such as the output:
a 2
b 3
c 2
d 1
the other file file_3 contains the data:
a A
b B
c C
d D
.
.
.
now i want two merge the two file to obtain the file format as shown:
A 2
B 3
C 2
D 1
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
suppose u have a file
aas P-H 123
gdg O-U 223
hdy I-Y 12
fgd K-O 333
ssa L-P 32
output shud be like that
aas P123H
gdg O223U
hdy I12Y
fgd K333O
ssa L32P
thanks (7 Replies)
Discussion started by: cdfd123
7 Replies
2. AIX
How to replace many numbers with one number in a file.
Many numbers like 444565,454678,443298,etc. i want to replace these with one number (300).Please halp me out. (2 Replies)
Discussion started by: vpandey
2 Replies
3. Shell Programming and Scripting
Here is a description what i need:
Document1:
start...
aaa
bbb
ccc
...end
=======================
Document2:
start...
<paste the copied lines here>
...end
All rows of document1 between "start...end" should be copied into the empty section "start...end" of document2.
The... (3 Replies)
Discussion started by: smitty11
3 Replies
4. Shell Programming and Scripting
I have a text file that contains numbers (listed from the smallest to the largest).
For ex.
34
817
1145
1645
1759
1761
3368
3529
4311
4681
5187
5193
5199
5417
5682
.
. (5 Replies)
Discussion started by: Lucky Ali
5 Replies
5. Shell Programming and Scripting
I have to find the number of rows in a file and delete those many rows in another file.
For example, if I have 3 rows in a file A, i have to delete first 3 rows in anothe file B,
I have the code, it works as standalone, when I merge this with m application (c with unix), it doesnt work.
... (2 Replies)
Discussion started by: Muthuraj K
2 Replies
6. Shell Programming and Scripting
Hi All,
I have a file which is like this:
rows.dat
1 2 3 4 5 6
3 4 5 6 7 8
7 8 9 0 4 3
2 3 4 5 6 7
1 2 3 4 5 6
I have another file with numbers like these (numbers.txt):
1
3
4
5
I want to read numbers.txt file line by line. The extract the row from rows.dat based on the... (3 Replies)
Discussion started by: shoaibjameel123
3 Replies
7. UNIX for Dummies Questions & Answers
Hi
I am very new to unix and please help me in solving the below problem
I have a file with 50000+ rows. Each row(line) start with 01 or 02 or 03.
Now i have to get the count of rows starting with 01 only,
Thanks in advance (3 Replies)
Discussion started by: nmakkena
3 Replies
8. UNIX for Dummies Questions & Answers
Could you please tell e how to find the total number of rows in a .dat file.
edit by bakunin: this is exactly why in "advanced and expert" section?? I transfer this thread to "Unix for Dummies Questions and Answers" (2 Replies)
Discussion started by: Deeptanshu
2 Replies
9. Shell Programming and Scripting
Hi - I have a file "file1" of below format. Its a comma seperated file. Note that each string is enclosed in double quotes.
"abc","-0.15","10,000.00","IJK"
"xyz","1,000.01","1,000,000.50","OPR"
I want the result as:
"abc","-0.15","10000.00","IJK"
"xyz","1,000.01","1000000.50","OPR"
I... (8 Replies)
Discussion started by: njny
8 Replies
10. Shell Programming and Scripting
Hi all;
Here is my file:
V1.3=4
V1.4=5
V1.1=3
V1.2=6
V1.3=6
Please, can you help me to write a script shell that counts the sum of values in my file (4+5+3+6+6) ?
Thank you so much for help.
Kind regards. (3 Replies)
Discussion started by: chercheur111
3 Replies
LEARN ABOUT DEBIAN
directory::scratch::structured
Directory::Scratch::Structured(3pm) User Contributed Perl Documentation Directory::Scratch::Structured(3pm)
NAME
Directory::Scratch::Structured - creates temporary files and directories from a structured description
SYNOPSIS
my %tree_structure =
(
dir_1 =>
{
subdir_1 =>{},
file_1 =>[],
file_a => [],
},
dir_2 =>
{
subdir_2 =>
{
file_22 =>[],
file_2a =>[],
},
file_2 =>[],
file_a =>['12345'],
file_b =>[],
},
file_0 => [] ,
) ;
use Directory::Scratch::Structured qw(create_structured_tree) ;
my $temporary_directory = create_structured_tree(%tree_structure) ;
or
use Directory::Scratch ;
use Directory::Scratch::Structured qw(piggyback_directory_scratch) ;
my $temporary_directory = Directory::Scratch->new;
$temporary_directory->create_structured_tree(%tree_structure) ;
DESCRIPTION
This module adds a create_structured_tree subroutine to the Directory::Scratch.
DOCUMENTATION
I needed a subroutine to create a bunch of temporary directories and files while running tests. I used the excellent Directory::Scratch to
implement such a functionality. I proposed the subroutine to the Directory::Scratch author but he preferred to implement a subroutine
using an unstructured input data based on the fact that Directory::Scratch didn't use structured data. This is, IMHO, flawed design, though
it may require slightly less typing.
I proposed a hybrid solution to reduce the amount of subroutines and integrate the subroutine using structured input into
Directory::Scratch but we didn't reach an agreement on the API. Instead I decided that I would piggyback on Directory::Scratch.
You can access create_structured_tree through a subroutine or a method through a Directory::Scratch object.
Whichever interface you choose, the argument to the create_structured_tree consists of tuples (hash entries). The key represents the name
of the object to create in the directory.
If the value is of type:
ARRAY
A file will be created, it's contents are the contents of the array (See Directory::Scratch)
HASH
A directory will be created. the element of the hash will also be , recursively, created
OTHER
The subroutine will croak.
SUBROUTINES
/METHODS
create_structured_tree
use Directory::Scratch::Structured qw(create_structured_tree) ;
my $temporary_directory = create_structured_tree(%tree_structure) ;
my $base = $temporary_directory->base() ;
Returns a default Directory::Scratch object.
directory_scratch_create_structured_tree
Adds create_structured_tree to Directory::Scratch when you Load Directory::Scratch::Structured with the piggyback_directory_scratch
option.
use Directory::Scratch ;
use Directory::Scratch::Structured qw(piggyback_directory_scratch) ;
my $temporary_directory = Directory::Scratch->new;
$temporary_directory->create_structured_tree(%tree_structure) ;
_create_structured_tree
Used internally by both interfaces
piggyback
Used internally to piggyback Directory::Scratch.
BUGS AND LIMITATIONS
None so far.
AUTHOR
Khemir Nadim ibn Hamouda
CPAN ID: NKH
mailto:nadim@khemir.net
LICENSE AND COPYRIGHT
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SUPPORT
You can find documentation for this module with the perldoc command.
perldoc Directory::Scratch::Structured
You can also look for information at:
o AnnoCPAN: Annotated CPAN documentation
<http://annocpan.org/dist/Directory-Scratch-Structured>
o RT: CPAN's request tracker
Please report any bugs or feature requests to L <bug-directory-scratch-structured@rt.cpan.org>.
We will be notified, and then you'll automatically be notified of progress on your bug as we make changes.
o Search CPAN
<http://search.cpan.org/dist/Directory-Scratch-Structured>
SEE ALSO
Directory::Scratch
perl v5.10.1 2010-03-22 Directory::Scratch::Structured(3pm)