Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Compare two text file and output the same to third file
Top Forums Shell Programming and Scripting Compare two text file and output the same to third file Post 302601618 by suresh7730 on Friday 24th of February 2012 05:06:03 AM
Old 02-24-2012
Compare two text file and output the same to third file
Need help.

I have a source file that listed sets of numbers/words and what i'm trying to do is, by each line of the source file i want to look for same numbers/words in second file and if it match then write it to third file. Third file should have whole line from source file plus whole line that matches from second file and its separated by space/tap.

Any idea how to do it in perl?

ex:

Source file
Code:
123-23456-2341
783-ueu72-k812

second file:
Code:
linenumber1-sometext:123-23456-2341:another text
linenumber2--sometext:637-7288-ju18:some other text
linenumber3--sometext:783-ueu72-k812:some more text


result expected:
123-23456-2341 linenumber1-sometext:123-23456-2341:another text

783-ueu72-k812 linenumber3--sometext:783-ueu72-k812:some more text
Last edited by Franklin52; 02-26-2012 at 05:11 AM.. Reason: Please use code tags for data and code samples, thank you
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

compare file size from a output file from a script

Hi guys, firstly I'm working on SunOS 5.10 Generic_125100-10 sun4u sparc SUNW,Sun-Fire-V240 I've made a script to compress two directory and then send them to an other server via ftp. This is working very well. Inside theis script I decide to log usefull data for troubleshooting in case of... (7 Replies)
Discussion started by: moustik
7 Replies

2. Shell Programming and Scripting

Ping text file of ip addressese and output to text file

I am basically a scripting noob, I have some programming logic, and I wouldn't post here if my 3 hours of searching actually found something. So far this is what I have: " #! /bin/ksh List=./pinglist1.txt cat $List | while read ip do Pingable="" ping $ip -n 2 | awk '/100%/ {print... (11 Replies)
Discussion started by: Lasthitlarry
11 Replies

3. Shell Programming and Scripting

Compare two file & output

Hi every body i have a problem need help urgently file 1 (approx 200K entries) aaaaa bbbb cccccc dddd ffff file 2 (approx 2 million entries) aaaaa,1,ee,44,5t,6y, bbbb,3,ff,66,5u,8r, cccccc, ..... dddd, ..... eeeeee, ..... ffff, ...... (5 Replies)
Discussion started by: The_Archer
5 Replies

4. Shell Programming and Scripting

Dynamic output file generation using a input text file with predefined output format

Hi, I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format. Example: File.txt AP|{SSHA}VEEg42CNCghUnGhCVg== APVG3|{SSHA}XK|"password" AP3|{SSHA}XK|"This is test" .... etc --------- test.sh has... (1 Reply)
Discussion started by: hudson03051nh
1 Replies

5. Shell Programming and Scripting

Match list of strings in File A and compare with File B, C and write to a output file in CSV format

Hi Friends, I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving... File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Discussion started by: asnandhakumar
6 Replies

6. Shell Programming and Scripting

Compare 2 text file with 1 column in each file and write mismatch data to 3rd file

Hi, I need to compare 2 text files with around 60000 rows and 1 column. I need to compare these and write the mismatch data to 3rd file. File1 - file2 = file3 wc -l file1.txt 58112 wc -l file2.txt 55260 head -5 file1.txt 101214200123 101214700300 101250030067 101214100500... (10 Replies)
Discussion started by: Divya Nochiyil
10 Replies

7. UNIX for Dummies Questions & Answers

To compare two files,Output into a new file

Hi Please help me to compare two files and output into a new file file1.txt 15114933 |4001 15291649 |933502 15764675 |4316 15764678 |4316 15761974 |282501 15673104 |933505 15673577 |933505 15673098 |933505 15673096 |933505 15673092 |933505 15760705 ... (13 Replies)
Discussion started by: Ankita Talukdar
13 Replies

8. Shell Programming and Scripting

Compare output of UNIX command and match data to text file

I am working on an outage script and I run a command from the command line which tells me the amount of generator failures in my market. The output of this command only gives me three digits to identify the site by. I have a master list of all sites in a separate file, call it list.txt. If my... (7 Replies)
Discussion started by: jbrass
7 Replies

9. Shell Programming and Scripting

Read in search strings from text file, search for string in second text file and output to CSV

Hi guys, I have a text file named file1.txt that is formatted like this: 001 , ID , 20000 002 , Name , Brandon 003 , Phone_Number , 616-234-1999 004 , SSNumber , 234-23-234 005 , Model , Toyota 007 , Engine ,V8 008 , GPS , OFF and I have file2.txt formatted like this: ... (2 Replies)
Discussion started by: An0mander
2 Replies

10. Shell Programming and Scripting

Shell script (sh file) logic to compare contents of one file with another file and output to file

Shell script logic Hi I have 2 input files like with file 1 content as (file1) "BRGTEST-242" a.txt "BRGTEST-240" a.txt "BRGTEST-219" e.txt File 2 contents as fle(2) "BRGTEST-244" a.txt "BRGTEST-244" b.txt "BRGTEST-231" c.txt "BRGTEST-231" d.txt "BRGTEST-221" e.txt I want to get... (22 Replies)
Discussion started by: pottic
22 Replies

LEARN ABOUT DEBIAN

viewperl

VIEWPERL(1)							   User Commands						       VIEWPERL(1)

NAME

       viewperl - quickly view syntax highlighted Perl code

SYNOPSIS

       viewperl [OPTION]... FILE...

DESCRIPTION

       View a Perl source code file, syntax highlighted.

       -c, --code=CODE
	      view CODE, syntax highlighted

       -l, --lines
	      display line numbers

       -L, --no-lines
	      supress display of line numbers (default)

       -m, --module=FILE
	      consider FILE the name of a module, not a file name

       -n, --name
	      display the name of each file (default)

       -N, --no-name
	      supress display of file names (implied by --no-reset)

       -p, --pod
	      display inline POD documentation (default)

       -P, --no-pod
	      hide POD documentation (line numbers still increment)

       -r, --reset
	      reset formatting and line numbers each file (default)

       -R, --no-reset
	      supress resetting of formatting and line numbers

       -s, --shift=WIDTH
	      set tab width (default is 4)

       -t, --tabs
	      translate tabs into spaces (default)

       -T, --no-tabs
	      supress translating of tabs into spaces

       --help display this help and exit

       Note that module names should be given as they would appear after a Perl `use' or `require' statement.  `Getopt::Long', for example.

       Each string given using -c is considered a different file, so line number and formatting resets will apply.

       View a Perl source code file, syntax highlighted.

       -c, --code=CODE
	      view CODE, syntax highlighted

       -l, --lines
	      display line numbers

       -L, --no-lines
	      supress display of line numbers (default)

       -m, --module=FILE
	      consider FILE the name of a module, not a file name

       -n, --name
	      display the name of each file (default)

       -N, --no-name
	      supress display of file names (implied by --no-reset)

       -p, --pod
	      display inline POD documentation (default)

       -P, --no-pod
	      hide POD documentation (line numbers still increment)

       -r, --reset
	      reset formatting and line numbers each file (default)

       -R, --no-reset
	      supress resetting of formatting and line numbers

       -s, --shift=WIDTH
	      set tab width (default is 4)

       -t, --tabs
	      translate tabs into spaces (default)

       -T, --no-tabs
	      supress translating of tabs into spaces

       --help display this help and exit

       Note that module names should be given as they would appear after a Perl `use' or `require' statement.  `Getopt::Long', for example.

       Each string given using -c is considered a different file, so line number and formatting resets will apply.

viewperl							    August 2007 						       VIEWPERL(1)
All times are GMT -4. The time now is 12:21 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy