Sponsored Content
Top Forums Shell Programming and Scripting Help with replace column one content based on reference file Post 302525606 by perl_beginner on Friday 27th of May 2011 07:52:34 AM
Old 05-27-2011
Help with replace column one content based on reference file

Input file
Code:
1 testing 10 20 1
A testing 20 40 1
3 testing 23 232 2
1 testing 10 243 2
.
.

Reference file
Code:
1 final
3 used
.
.

Output file
Code:
final testing 10 20
A testing 20 40
used testing 23 232
final testing 10 243
.
.

I would like to replace those content that shown in column 1 of input file with the content that shown in reference file (if available).
Thanks.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace character based on reference file problem asking

I got two files right now, input file (target file), reference file 1 (query file) reference file 1 (long list of data) KOLOPWMOPOPO ADASDASD ADSASDASDAD . . target file (one long liner content) ADASDASDTYUKOKOLOPWMOPOPOOPLUAADSASDASDADPOPOUYADADASDASD desired output file content ... (1 Reply)
Discussion started by: patrick87
1 Replies

2. Shell Programming and Scripting

Help with rename header content based on reference file problem

I got long list of reference file >data_tmp_number_22 >data_tmp_number_12 >data_tmp_number_20 . . Input file: >sample_data_1 Math, 5, USA, tmp SDFEWRWERWERWRWER FSFDSFSDFSDGSDGSD >sample_data_2 Math, 15, UK, tmp FDSFSDFF >sample_data_3 Math, 50, USA, tmp ARQERREQR . . Desired... (7 Replies)
Discussion started by: perl_beginner
7 Replies

3. 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

4. Shell Programming and Scripting

Help with replace column one content based on reference file

Input file 1 testing 10 20 1 A testing 20 40 1 3 testing 23 232 2 1 testing 10 243 2 . . Reference file 1 final 3 used . . Output file (1 Reply)
Discussion started by: perl_beginner
1 Replies

5. Shell Programming and Scripting

multiplication of two files based on the content of the first column

Hi, This is something that probably it is more difficult to explain than to do. I have two files e.g. FILE1 A15 8.3102E+00 3.2000E-04 A15 8.5688E+00 4.3000E-05 B13 5.1100E-01 1.9960E+00 B16 5.1100E-01 2.3000E-03 B16 8.6770E-01 1.0000E-07 B16 9.8693E-01 3.4000E-05... (4 Replies)
Discussion started by: f_o_555
4 Replies

6. Shell Programming and Scripting

Help with analysis data based on particular column content

Input file: Total_counts 1306726155 100% Number_of_count_true 855020282 Number_of_count_true_1 160014283 Number_of_count_true_2 44002825 Number_of_count_true_3 18098424 Number_of_count_true_4 24693745 Number_of_count_false 115421870 Number_of_count_true 51048447 Total_number_of_false ... (2 Replies)
Discussion started by: perl_beginner
2 Replies

7. Shell Programming and Scripting

Print the column content based on the header

i have a input of csv file as below but the sequence of column get changed. I,e it is not necessary that name comes first then age and rest all, it may vary. name,age,marks,roll,section kevin,25,80,456,A Satch,23,56,789,B Meena,24,78,H245,C So i want to print that column entires which... (12 Replies)
Discussion started by: millan
12 Replies

8. Shell Programming and Scripting

Replace a value using a reference data from other file

Gents, Can you please help me to solve this case In my input file I have a values in column 49 which always need to be one, but sometimes the system create a value 2, in this case I need to go to search in the original file and replace the values in the row where the value 2 is and in the... (6 Replies)
Discussion started by: jiam912
6 Replies

9. Shell Programming and Scripting

Replace a word based upon the file content

I have a file which contains timestamp and date in the second column. If the line contains one of the word then it need to be replace like below. Any help is appreciated. File: a smallint b timestamp c date d varchar O/P: a smallint ... (1 Reply)
Discussion started by: JoshvaPeter
1 Replies

10. UNIX for Beginners Questions & Answers

Replace a column in tab delimited file with column in other tab delimited file,based on match

Hello Everyone.. I want to replace the retail col from FileI with cstp1 col from FileP if the strpno matches in both files FileP.txt ... (2 Replies)
Discussion started by: YogeshG
2 Replies
Pod::Tests(3pm) 					User Contributed Perl Documentation					   Pod::Tests(3pm)

NAME
Pod::Tests - Extracts embedded tests and code examples from POD SYNOPSIS
use Pod::Tests; $p = Pod::Tests->new; $p->parse_file($file); $p->parse_fh($fh); $p->parse(@code); my @examples = $p->examples; my @tests = $p->tests; foreach my $example (@examples) { print "The example: '$example->{code}' was on line ". "$example->{line} "; } my @test_code = $p->build_tests(@tests); my @example_test_code = $p->build_examples(@examples); DESCRIPTION
This is a specialized POD viewer to extract embedded tests and code examples from POD. It doesn't do much more than that. pod2test does the useful work. Parsing After creating a Pod::Tests object, you parse the POD by calling one of the available parsing methods documented below. You can call parse as many times as you'd like, all examples and tests found will stack up inside the object. Testing Once extracted, the tests can be built into stand-alone testing code using the build_tests() and build_examples() methods. However, it is recommended that you first look at the pod2test program before embarking on this. Methods new $parser = Pod::Tests->new; Returns a new Pod::Tests object which lets you read tests and examples out of a POD document. parse $parser->parse(@code); Finds the examples and tests in a bunch of lines of Perl @code. Once run they're available via examples() and testing(). parse_file $file $parser->parse_file($filename); Just like parse() except it works on a file. parse_fh $fh $parser->parse_fh($fh); Just like parse() except it works on a filehandle. tests @testing = $parser->tests; Returns the tests found in the parsed POD documents. Each element of @testing is a hash representing an individual testing block and contains information about that block. $test->{code} actual testing code $test->{line} line from where the test was taken examples @examples = $parser->examples; Returns the examples found in the parsed POD documents. Each element of @examples is a hash representing an individual testing block and contains information about that block. $test->{code} actual testing code $test->{line} line from where the test was taken build_tests my @code = $p->build_tests(@tests); Returns a code fragment based on the given embedded @tests. This fragment is expected to print the usual "ok/not ok" (or something Test::Harness can read) or nothing at all. Typical usage might be: my @code = $p->build_tests($p->tests); This fragment is suitable for placing into a larger test script. NOTE Look at pod2test before embarking on your own test building. build_examples my @code = $p->build_examples(@examples); Similar to build_tests(), it creates a code fragment which tests the basic validity of your example code. Essentially, it just makes sure it compiles. If your example has an "example testing" block associated with it it will run the the example code and the example testing block. EXAMPLES
Here's the simplest example, just finding the tests and examples in a single module. my $p = Pod::Tests->new; $p->parse_file("path/to/Some.pm"); And one to find all the tests and examples in a directory of files. This illustrates building a set of examples and tests through multiple calls to parse_file(). my $p = Pod::Tests->new; opendir(PODS, "path/to/some/lib/") || die $!; while( my $file = readdir PODS ) { $p->parse_file($file); } printf "Found %d examples and %d tests in path/to/some/lib ", scalar $p->examples, scalar $p->tests; Finally, an example of parsing your own POD using the DATA filehandle. use Fcntl qw(:seek); my $p = Pod::Tests->new; # Seek to the beginning of the current code. seek(DATA, 0, SEEK_SET) || die $!; $p->parse_fh(*DATA); SUPPORT This module has been replaced by the newer Test::Inline 2. Most testing code that currently works with "pod2test" should continue to work with the new version. The most notable exceptions are "=for begin" and "=for end", which are deprecated. After upgrading, Pod::Tests and "pod2test" were split out to provide a compatibility package for legacy code. "pod2test" will stay in CPAN, but should remain unchanged indefinately, with the exception of any minor bugs that will require squishing. Bugs in this dist should be reported via the following URL. Feature requests should not be submitted, as further development is now occuring in Test::Inline. http://rt.cpan.org/NoAuth/ReportBug.html?Queue=Pod-Tests <http://rt.cpan.org/NoAuth/ReportBug.html?Queue=Pod-Tests> AUTHOR
Michael G Schwern <schwern@pobox.com> Adam Kennedy <adamk@cpan.org> SEE ALSO
Test::Inline pod2test, Perl 6 RFC 183 http://dev.perl.org/rfc183.pod Short set of slides on Pod::Tests http://www.pobox.com/~schwern/talks/Embedded_Testing/ Similar schemes can be found in SelfTest and Test::Unit. COPYRIGHT
Copyright 2005 - 2008 Adam Kennedy. Copyright 2001 - 2003 Michael G Schwern. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The full text of the license can be found in the LICENSE file included with this module. perl v5.12.4 2008-07-13 Pod::Tests(3pm)
All times are GMT -4. The time now is 07:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy