Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Replacing data of output file with input
Top Forums Shell Programming and Scripting Replacing data of output file with input Post 302281322 by rwuerth on Wednesday 28th of January 2009 04:13:57 PM
Old 01-28-2009
I've taken your input:

Quote:
Originally Posted by bhagya2340
20090124,00:02:31,00:00:11,2776,00:01:38,00:01:31,00:56:36,108938,
20090125,00:02:31,00:00:11,2776,00:01:38,00:01:31,00:56:36,108938,
20090126,00:02:33,00:00:35,8187,00:01:42,00:01:32,02:02:08,321055,
and created two files. The first test1.dat is as above. The second, test2.dat I took the first line above starting with "20090124" and changed that to "20090127" to spoof a date on the 27th, and moved it to the end so it looks like this:

Code:
20090125,00:02:31,00:00:11,2776,00:01:38,00:01:31,00:56:36,108938, 
20090126,00:02:33,00:00:35,8187,00:01:42,00:01:32,02:02:08,321055, 
20090127,00:02:31,00:00:11,2776,00:01:38,00:01:31,00:56:36,108938,

Then I ran the following 'comm' command:

Code:
comm test1.dat test2.dat | tr -d '\t'

and got the following output:

Code:
20090124,00:02:31,00:00:11,2776,00:01:38,00:01:31,00:56:36,108938, 
20090125,00:02:31,00:00:11,2776,00:01:38,00:01:31,00:56:36,108938, 
20090126,00:02:33,00:00:35,8187,00:01:42,00:01:32,02:02:08,321055,
20090127,00:02:31,00:00:11,2776,00:01:38,00:01:31,00:56:36,108938,

Which could be put into it's own file.

comm prints output in three columns. Col 1 is data only in the first file,
col 2 is data only in the second file and Col 3 is data in both files. The "columns" are created using tabs, and there is not more than one column's worth of data on a line. So by removing the tabs, I have output that lines up neatly, and gives me all the unique and non duplicated data from the previous two files.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

replacing spaces with null or 0 in the input file

hi i have records in my input file like this aaa|1234||2bc||rahul|tamilnadu bba|2234||b4c||bajaj|tamilnadu what i am expecting is in between two pipes if there is no character it should be replaced with null or 0 so my file will look like this aaa|1234|null|2bc|0|rahul|tamilnadu... (4 Replies)
Discussion started by: trichyselva
4 Replies

2. UNIX for Dummies Questions & Answers

Replacing part of a text file with user input.

Ok, I am brand new to UNIX and I am trying to learn a cross between basic script and database use. I had got some ideas off the net on simple ideas for learning UNIX. I am working on creating a simple phone book program that allows myself to enter our employees from work into a phone book text... (0 Replies)
Discussion started by: georgefurbee
0 Replies

3. Shell Programming and Scripting

Need script to take input from file, match on it in file 2 and input data

All, I am trying to figure out a script to run in windows that will allow me to match on First column in file1 to 8th Column in File2 then Insert file1 column2 to file2 column4 then create a new file. File1: 12345 Sam 12346 Bob 12347 Bill File2:... (1 Reply)
Discussion started by: darkoth
1 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

How to add data from 2 input files and save it in 1 output file

Hi, i have 2 input files which are file1.txt and file2.txt. I need to extract data from file1.txt and file2.txt and save it in file3.txt like example below:- File1.txt ID scrap1 Name scrap1 start 1 end 10 ID scrap2 Name scrap2 start 11 end ... (4 Replies)
Discussion started by: redse171
4 Replies

6. Shell Programming and Scripting

split input data file and put into same output file

Hi All, I have two input file and need to generate a CSV file. The existing report just "GREP" the records with the Header and Tailer records with the count of records. Now i need to split the data into 25 records each in the same CSV file. id_file (Input file ) 227050994 232510151... (4 Replies)
Discussion started by: rasmith
4 Replies

7. Shell Programming and Scripting

adding data in input file if 2nd script output SUCCESS

Hi All, how can i edit my original data and add more data if my 2nd script outputs SUCESS? ex. input file: 1.txt nik,is,the 1script.sh if 2ndscript.sh output SUCCESS then i'm going to edit my input file and add data best,pogi.. sample outputdata. nik,is,the,best,pogi 2ndscript.sh... (3 Replies)
Discussion started by: nikki1200
3 Replies

8. Shell Programming and Scripting

Replacing data in one file with data in another

Hello, I have 2 files delimited by "|". File1: 1|New York 12| Buffalo 599| Syracuse File2: 56 Kennedy |1 9 Burridge Pl|15 98 BELL ROCK |599 My goal: Is to replace the numerical numbers in "File 2" (second field, not street address) with the corresponding city names from... (2 Replies)
Discussion started by: vestport
2 Replies

9. Shell Programming and Scripting

Awk replacing file with user input

this section of the awk code i have here takes file to work with from the user. the user specifies the file name from the command line and the file name is assigned to the variable $FLIST awk 'BEGIN { while((getline < "'${FLIST}'")>0) S FS="\n"; RS="}\n" } now, i dont want... (5 Replies)
Discussion started by: SkySmart
5 Replies

10. Shell Programming and Scripting

awk to reformat output if input file is empty, but not if file has data in it

The below awk improved bu @MadeInGermany, works great as long as the input file has data in it in the below format: input chrX 25031028 25031925 chrX:25031028-25031925 ARX 631 18 chrX 25031028 25031925 chrX:25031028-25031925 ARX 632 14... (3 Replies)
Discussion started by: cmccabe
3 Replies

LEARN ABOUT DEBIAN

datetime::format::natural::lang::en

DateTime::Format::Natural::Lang::EN(3pm)		User Contributed Perl Documentation		  DateTime::Format::Natural::Lang::EN(3pm)

NAME

       DateTime::Format::Natural::Lang::EN - English language metadata

DESCRIPTION

       "DateTime::Format::Natural::Lang::EN" provides the english specific grammar and variables. This class is loaded if the user either
       specifies the english language or implicitly.

EXAMPLES

       Below are some examples of human readable date/time input in english (be aware that the parser does not distinguish between lower/upper
       case; furthermore, many expressions allow for additional leading/trailing time and all times are also parsable with precision in seconds):

   Simple
	now
	yesterday
	today
	tomorrow
	morning
	afternoon
	evening
	noon
	midnight
	yesterday at noon
	yesterday at midnight
	today at noon
	today at midnight
	tomorrow at noon
	tomorrow at midnight
	this morning
	this afternoon
	this evening
	yesterday morning
	yesterday afternoon
	yesterday evening
	today morning
	today afternoon
	today evening
	tomorrow morning
	tomorrow afternoon
	tomorrow evening
	thursday morning
	thursday afternoon
	thursday evening
	6:00 yesterday
	6:00 today
	6:00 tomorrow
	5am yesterday
	5am today
	5am tomorrow
	4pm yesterday
	4pm today
	4pm tomorrow
	last second
	this second
	next second
	last minute
	this minute
	next minute
	last hour
	this hour
	next hour
	last day
	this day
	next day
	last week
	this week
	next week
	last month
	this month
	next month
	last year
	this year
	next year
	last friday
	this friday
	next friday
	tuesday last week
	tuesday this week
	tuesday next week
	last week wednesday
	this week wednesday
	next week wednesday
	10 seconds ago
	10 minutes ago
	10 hours ago
	10 days ago
	10 weeks ago
	10 months ago
	10 years ago
	in 5 seconds
	in 5 minutes
	in 5 hours
	in 5 days
	in 5 weeks
	in 5 months
	in 5 years
	saturday
	sunday 11:00
	yesterday at 4:00
	today at 4:00
	tomorrow at 4:00
	yesterday at 6:45am
	today at 6:45am
	tomorrow at 6:45am
	yesterday at 6:45pm
	today at 6:45pm
	tomorrow at 6:45pm
	yesterday at 2:32 AM
	today at 2:32 AM
	tomorrow at 2:32 AM
	yesterday at 2:32 PM
	today at 2:32 PM
	tomorrow at 2:32 PM
	yesterday 02:32
	today 02:32
	tomorrow 02:32
	yesterday 2:32am
	today 2:32am
	tomorrow 2:32am
	yesterday 2:32pm
	today 2:32pm
	tomorrow 2:32pm
	wednesday at 14:30
	wednesday at 02:30am
	wednesday at 02:30pm
	wednesday 14:30
	wednesday 02:30am
	wednesday 02:30pm
	friday 03:00 am
	friday 03:00 pm
	sunday at 05:00 am
	sunday at 05:00 pm
	2nd monday
	100th day
	4th february
	november 3rd
	last june
	next october
	6 am
	5am
	5:30am
	8 pm
	4pm
	4:20pm
	06:56:06 am
	06:56:06 pm
	mon 2:35
	1:00 sun
	1am sun
	1pm sun
	1:00 on sun
	1am on sun
	1pm on sun
	12:14 PM
	12:14 AM

   Complex
	yesterday 7 seconds ago
	yesterday 7 minutes ago
	yesterday 7 hours ago
	yesterday 7 days ago
	yesterday 7 weeks ago
	yesterday 7 months ago
	yesterday 7 years ago
	today 5 seconds ago
	today 5 minutes ago
	today 5 hours ago
	today 5 days ago
	today 5 weeks ago
	today 5 months ago
	today 5 years ago
	tomorrow 3 seconds ago
	tomorrow 3 minutes ago
	tomorrow 3 hours ago
	tomorrow 3 days ago
	tomorrow 3 weeks ago
	tomorrow 3 months ago
	tomorrow 3 years ago
	2 seconds before now
	2 minutes before now
	2 hours before now
	2 days before now
	2 weeks before now
	2 months before now
	2 years before now
	4 seconds from now
	4 minutes from now
	4 hours from now
	4 days from now
	4 weeks from now
	4 months from now
	4 years from now
	6 in the morning
	4 in the afternoon
	9 in the evening
	monday 6 in the morning
	monday 4 in the afternoon
	monday 9 in the evening
	last sunday at 21:45
	monday last week
	6th day last week
	6th day this week
	6th day next week
	12th day last month
	12th day this month
	12th day next month
	1st day last year
	1st day this year
	1st day next year
	1st tuesday last november
	1st tuesday this november
	1st tuesday next november
	11 january next year
	11 january this year
	11 january last year
	6 hours before yesterday
	6 hours before tomorrow
	3 hours after yesterday
	3 hours after tomorrow
	10 hours before noon
	10 hours before midnight
	5 hours after noon
	5 hours after midnight
	noon last friday
	midnight last friday
	noon this friday
	midnight this friday
	noon next friday
	midnight next friday
	last friday at 20:00
	this friday at 20:00
	next friday at 20:00
	1:00 last friday
	1:00 this friday
	1:00 next friday
	1am last friday
	1am this friday
	1am next friday
	1pm last friday
	1pm this friday
	1pm next friday
	5 am last monday
	5 am this monday
	5 am next monday
	5 pm last monday
	5 pm this monday
	5 pm next monday
	last wednesday 7am
	this wednesday 7am
	next wednesday 7am
	last wednesday 7pm
	this wednesday 7pm
	next wednesday 7pm
	last tuesday 11 am
	this tuesday 11 am
	next tuesday 11 am
	last tuesday 11 pm
	this tuesday 11 pm
	next tuesday 11 pm
	yesterday at 13:00
	today at 13:00
	tomorrow at 13
	2nd friday in august
	3rd wednesday in november
	tomorrow 1 year ago
	saturday 3 months ago at 17:00
	saturday 3 months ago at 5:00am
	saturday 3 months ago at 5:00pm
	11 january 2 years ago
	4th day last week
	8th month last year
	8th month this year
	8th month next year
	6 mondays from now
	fri 3 months ago at 5am
	wednesday 1 month ago at 8pm
	final thursday in april
	last thursday in april

   Timespans
	monday to friday
	1 April to 31 August
	1999-12-31 to tomorrow
	now to 2010-01-01
	2009-03-10 9:00 to 11:00
	26 oct 10:00 am to 11:00 am
	jan 1 to 2
	16:00 nov 6 to 17:00
	may 2nd to 5th
	100th day to 200th
	6am dec 5 to 7am
	1/3 to 2/3
	2/3 to in 1 week
	3/3 21:00 to in 5 days
	first day of 2009 to last day of 2009
	first day of may to last day of may
	first to last day of 2008
	first to last day of september
	for 4 seconds
	for 4 minutes
	for 4 hours
	for 4 days
	for 4 weeks
	for 4 months
	for 4 years

   Specific
	march
	january 11
	11 january
	18 oct 17:00
	18 oct 5am
	18 oct 5pm
	18 oct 5 am
	18 oct 5 pm
	dec 25
	feb 28 3:00
	feb 28 3am
	feb 28 3pm
	feb 28 3 am
	feb 28 3 pm
	19:00 jul 1
	7am jul 1
	7pm jul 1
	7 am jul 1
	7 pm jul 1
	jan 24, 2011 12:00
	jan 24, 2011 12am
	jan 24, 2011 12pm
	may 27th
	2005
	march 1st 2009
	October 2006
	february 14, 2004
	jan 3 2010
	3 jan 2000
	2010 october 28
	2011-jan-04
	27/5/1979
	1/3
	1/3 16:00
	4:00
	17:00
	3:20:00
	-5min
	+2d
	20111018000000

   Aliases
	5 mins ago
	yesterday @ noon
	tues this week
	final thurs in sep
	tues
	thurs
	thur

SEE ALSO

       DateTime::Format::Natural

AUTHOR

       Steven Schubiger <schubiger@cpan.org>

LICENSE

       This program is free software; you may redistribute it and/or modify it under the same terms as Perl itself.

       See <http://dev.perl.org/licenses/>

perl v5.14.2							    2012-05-31				  DateTime::Format::Natural::Lang::EN(3pm)
All times are GMT -4. The time now is 06:55 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy