I have "n" files in directory A and "n" files in directory B. The files are expected to be the same with same data. Each file has 14 columns and "x" rows. Of the 14 column, 2 columns are to be considered as key identifiers. Based on this unique combination, I need to compare each field value... (2 Replies)
First, thanks for the help in previous posts... couldn't have gotten where I am now without it!
So here is what I have, I use AWK to match $1 and $2 as 1 string in file1 to $1 and $2 as 1 string in file2. Now I'm wondering if I can extend this AWK command to incorporate the following:
If $1... (4 Replies)
It seems like a common task, but I haven't been able to find the solution.
vitallog.txt
1310,John,Hancock
13211,Steven,Mills
122,Jane,Doe
138,Thoms,Doe
1500,Micheal,May
vitalinfo.txt
12122,Jane,Thomas
122,Janes,Does
123,Paul,Kite
**OUTPUT**
vitalfiltered.txt
12122,Jane,Thomas... (2 Replies)
I have two files in UNIX.
1st file is Entity and Second File is References. 1st File has only one column named Entity ID and 2nd file has two columns Entity ID | Person ID.
I want to produce a output file where entity id's are matching in both the files.
Entity File
624197
624252
624264... (4 Replies)
Hi Guys
I have the following file
Essentially, I am trying to find the right awk/sed syntax in order to produce the following 3 distinct files from the file above:
Basically, I want to print the lines of the file as long as the second field of the current line is equal to the... (9 Replies)
Hi Friends,
I am new to Shell Scripting and need your help in the below situation.
- I have two files (File 1 and File 2) and the contents of the files are mentioned below.
- "Application handle" is the common field in both the files.
(NOTE :- PLEASE REFER TO THE ATTACHMENT "Compare files... (2 Replies)
Hi Freinds,
I have 2 files . one is source.txt and second one is target.txt. I want to keep source.txt as baseline and compare target.txt. please find the data in 2 files and Expected output.
Source.txt
1|HYD|NAG|TRA|34.5|1234
2|CHE|ESW|DES|36.5|134
3|BAN|MEH|TRA|33.5|234... (5 Replies)
I am having two csv files i need to compare these files and the output file should have the information of the differences at the field level.
For Example,
File 1:
A,B,C,D,E,F
1,2,3,4,5,6
File 2:
A,C,B,D,E,F
1,2,4,5,5,6
out put file: (12 Replies)
Hello, I want to run a field from an awk command through a command in bash.
For example my input file is
1,2,3
20,30,40
60,70,80
I want tot run $2 thought the command
date +%d/%m/%y -d"01/01/15 + $2 days -1 day"
and get the output
1,02/01/15,3
20,30/01/15,40
60,11/03/15,80
... (2 Replies)
Hi,
For example:
I have:
HostA,XYZ
HostB,XYZ
HostC,ABC
I would like the output to be:
HostA,HostB: XYZ
HostC:ABC
How can I achieve this?
So far what I though of is: (1 Reply)
Discussion started by: alvinoo
1 Replies
LEARN ABOUT MOJAVE
datetime::locale::en5.18
DateTime::Locale::en(3) User Contributed Perl Documentation DateTime::Locale::en(3)NAME
DateTime::Locale::en
SYNOPSIS
use DateTime;
my $dt = DateTime->now( locale => 'en' );
print $dt->month_name();
DESCRIPTION
This is the DateTime locale package for English.
DATA
This locale inherits from the DateTime::Locale::root locale.
It contains the following data.
Days
Wide (format)
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Abbreviated (format)
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Narrow (format)
M
T
W
T
F
S
S
Wide (stand-alone)
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Abbreviated (stand-alone)
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Narrow (stand-alone)
M
T
W
T
F
S
S
Months
Wide (format)
January
February
March
April
May
June
July
August
September
October
November
December
Abbreviated (format)
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Narrow (format)
J
F
M
A
M
J
J
A
S
O
N
D
Wide (stand-alone)
January
February
March
April
May
June
July
August
September
October
November
December
Abbreviated (stand-alone)
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Narrow (stand-alone)
J
F
M
A
M
J
J
A
S
O
N
D
Quarters
Wide (format)
1st quarter
2nd quarter
3rd quarter
4th quarter
Abbreviated (format)
Q1
Q2
Q3
Q4
Narrow (format)
1
2
3
4
Wide (stand-alone)
1st quarter
2nd quarter
3rd quarter
4th quarter
Abbreviated (stand-alone)
Q1
Q2
Q3
Q4
Narrow (stand-alone)
1
2
3
4
Eras
Wide
Before Christ
Anno Domini
Abbreviated
BC
AD
Narrow
B
A
Date Formats
Full
2008-02-05T18:30:30 = Tuesday, February 5, 2008
1995-12-22T09:05:02 = Friday, December 22, 1995
-0010-09-15T04:44:23 = Saturday, September 15, -10
Long
2008-02-05T18:30:30 = February 5, 2008
1995-12-22T09:05:02 = December 22, 1995
-0010-09-15T04:44:23 = September 15, -10
Medium
2008-02-05T18:30:30 = Feb 5, 2008
1995-12-22T09:05:02 = Dec 22, 1995
-0010-09-15T04:44:23 = Sep 15, -10
Short
2008-02-05T18:30:30 = 2/5/08
1995-12-22T09:05:02 = 12/22/95
-0010-09-15T04:44:23 = 9/15/-10
Default
2008-02-05T18:30:30 = Feb 5, 2008
1995-12-22T09:05:02 = Dec 22, 1995
-0010-09-15T04:44:23 = Sep 15, -10
Time Formats
Full
2008-02-05T18:30:30 = 6:30:30 PM UTC
1995-12-22T09:05:02 = 9:05:02 AM UTC
-0010-09-15T04:44:23 = 4:44:23 AM UTC
Long
2008-02-05T18:30:30 = 6:30:30 PM UTC
1995-12-22T09:05:02 = 9:05:02 AM UTC
-0010-09-15T04:44:23 = 4:44:23 AM UTC
Medium
2008-02-05T18:30:30 = 6:30:30 PM
1995-12-22T09:05:02 = 9:05:02 AM
-0010-09-15T04:44:23 = 4:44:23 AM
Short
2008-02-05T18:30:30 = 6:30 PM
1995-12-22T09:05:02 = 9:05 AM
-0010-09-15T04:44:23 = 4:44 AM
Default
2008-02-05T18:30:30 = 6:30:30 PM
1995-12-22T09:05:02 = 9:05:02 AM
-0010-09-15T04:44:23 = 4:44:23 AM
Datetime Formats
Full
2008-02-05T18:30:30 = Tuesday, February 5, 2008 6:30:30 PM UTC
1995-12-22T09:05:02 = Friday, December 22, 1995 9:05:02 AM UTC
-0010-09-15T04:44:23 = Saturday, September 15, -10 4:44:23 AM UTC
Long
2008-02-05T18:30:30 = February 5, 2008 6:30:30 PM UTC
1995-12-22T09:05:02 = December 22, 1995 9:05:02 AM UTC
-0010-09-15T04:44:23 = September 15, -10 4:44:23 AM UTC
Medium
2008-02-05T18:30:30 = Feb 5, 2008 6:30:30 PM
1995-12-22T09:05:02 = Dec 22, 1995 9:05:02 AM
-0010-09-15T04:44:23 = Sep 15, -10 4:44:23 AM
Short
2008-02-05T18:30:30 = 2/5/08 6:30 PM
1995-12-22T09:05:02 = 12/22/95 9:05 AM
-0010-09-15T04:44:23 = 9/15/-10 4:44 AM
Default
2008-02-05T18:30:30 = Feb 5, 2008 6:30:30 PM
1995-12-22T09:05:02 = Dec 22, 1995 9:05:02 AM
-0010-09-15T04:44:23 = Sep 15, -10 4:44:23 AM
Available Formats
d (d)
2008-02-05T18:30:30 = 5
1995-12-22T09:05:02 = 22
-0010-09-15T04:44:23 = 15
EEEd (d EEE)
2008-02-05T18:30:30 = 5 Tue
1995-12-22T09:05:02 = 22 Fri
-0010-09-15T04:44:23 = 15 Sat
Hm (H:mm)
2008-02-05T18:30:30 = 18:30
1995-12-22T09:05:02 = 9:05
-0010-09-15T04:44:23 = 4:44
hm (h:mm a)
2008-02-05T18:30:30 = 6:30 PM
1995-12-22T09:05:02 = 9:05 AM
-0010-09-15T04:44:23 = 4:44 AM
Hms (H:mm:ss)
2008-02-05T18:30:30 = 18:30:30
1995-12-22T09:05:02 = 9:05:02
-0010-09-15T04:44:23 = 4:44:23
hms (h:mm:ss a)
2008-02-05T18:30:30 = 6:30:30 PM
1995-12-22T09:05:02 = 9:05:02 AM
-0010-09-15T04:44:23 = 4:44:23 AM
M (L)
2008-02-05T18:30:30 = 2
1995-12-22T09:05:02 = 12
-0010-09-15T04:44:23 = 9
Md (M/d)
2008-02-05T18:30:30 = 2/5
1995-12-22T09:05:02 = 12/22
-0010-09-15T04:44:23 = 9/15
MEd (E, M/d)
2008-02-05T18:30:30 = Tue, 2/5
1995-12-22T09:05:02 = Fri, 12/22
-0010-09-15T04:44:23 = Sat, 9/15
MMM (LLL)
2008-02-05T18:30:30 = Feb
1995-12-22T09:05:02 = Dec
-0010-09-15T04:44:23 = Sep
MMMd (MMM d)
2008-02-05T18:30:30 = Feb 5
1995-12-22T09:05:02 = Dec 22
-0010-09-15T04:44:23 = Sep 15
MMMEd (E, MMM d)
2008-02-05T18:30:30 = Tue, Feb 5
1995-12-22T09:05:02 = Fri, Dec 22
-0010-09-15T04:44:23 = Sat, Sep 15
MMMMd (MMMM d)
2008-02-05T18:30:30 = February 5
1995-12-22T09:05:02 = December 22
-0010-09-15T04:44:23 = September 15
MMMMEd (E, MMMM d)
2008-02-05T18:30:30 = Tue, February 5
1995-12-22T09:05:02 = Fri, December 22
-0010-09-15T04:44:23 = Sat, September 15
ms (mm:ss)
2008-02-05T18:30:30 = 30:30
1995-12-22T09:05:02 = 05:02
-0010-09-15T04:44:23 = 44:23
y (y)
2008-02-05T18:30:30 = 2008
1995-12-22T09:05:02 = 1995
-0010-09-15T04:44:23 = -10
yM (M/yyyy)
2008-02-05T18:30:30 = 2/2008
1995-12-22T09:05:02 = 12/1995
-0010-09-15T04:44:23 = 9/-010
yMEd (EEE, M/d/yyyy)
2008-02-05T18:30:30 = Tue, 2/5/2008
1995-12-22T09:05:02 = Fri, 12/22/1995
-0010-09-15T04:44:23 = Sat, 9/15/-010
yMMM (MMM y)
2008-02-05T18:30:30 = Feb 2008
1995-12-22T09:05:02 = Dec 1995
-0010-09-15T04:44:23 = Sep -10
yMMMEd (EEE, MMM d, y)
2008-02-05T18:30:30 = Tue, Feb 5, 2008
1995-12-22T09:05:02 = Fri, Dec 22, 1995
-0010-09-15T04:44:23 = Sat, Sep 15, -10
yMMMM (MMMM y)
2008-02-05T18:30:30 = February 2008
1995-12-22T09:05:02 = December 1995
-0010-09-15T04:44:23 = September -10
yQ (Q yyyy)
2008-02-05T18:30:30 = 1 2008
1995-12-22T09:05:02 = 4 1995
-0010-09-15T04:44:23 = 3 -010
yQQQ (QQQ y)
2008-02-05T18:30:30 = Q1 2008
1995-12-22T09:05:02 = Q4 1995
-0010-09-15T04:44:23 = Q3 -10
Miscellaneous
Prefers 24 hour time?
No
Local first day of the week
Monday
SUPPORT
See DateTime::Locale.
AUTHOR
Dave Rolsky <autarch@urth.org>
COPYRIGHT
Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
same terms as Perl itself.
This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's
license.
perl v5.18.2 2017-10-06 DateTime::Locale::en(3)
07-20-2012
Compare two files Field by field and output the result in another file
I am very new to Shell scripting