Paste two file side by side together based on specific pattern match problem
Input file_1:
Input file_2:
Desired output file:
File_1 consider the back-bone of my desire output file. The data at File_1 must be presented at the desired output file no matter is empty line or data that don't match with file 2.
Besides that, the output data sequence must follow exactly like file_1. Some data at file 1, might apprear more than once as well. My purpose is to paste those file_2 data that got match with file_1 data to the output file.
Thanks for any suggestion.
Hi,
I have to sql queries like
select sno,sname from temptable;
select deptno,dname from depttable;
In excel i want to specify the column number to which my output should be displayed.
please help me in this...
thanks in advance... (6 Replies)
Hi Everyone,
I need a shell/perl script to bring selected columns from all the files located in a directory and place them in a new file side by side.
File1:
a b c d
2 3 4 5
f g h i
..........
File2:
I II III IV
w x y z
..............
and so on many files are there...... (8 Replies)
I have 2 text files, both have one simple, single column. The 2 files might be the same length, or might not, and if not, it's unknown which one would be longer.
For this example, file1 is longer:
---file1
Joe
Bob
Mary
Sally
Fred
Elmer
David
---file2
Tomato
House
Car... (3 Replies)
I have installed WAMPSERVER 2.0 on my windows vista x64 system but still am having issues with getting the webserver to be seen outside my local network. It is working fine within my local network.
Been through several setup tutorials so far, no dice still.
For testing purposes I have... (1 Reply)
Hi All,
I have a file abc.xls which contains data
applciation usage
merlin 24000
hermes 48000
and my script generates an output to a file def.xls
applciation usage
merlin 23000
hermes 50000
Daily i want to schedule this script to run and I need the second column to be appended to the... (2 Replies)
Hi I'm trying to compare 3 or more files based on similar values and outputting them into 3 columns.
For example:
file1
ABC
DEF
GHI
file2
DEF
DER
file3
ABC
DER
The output should come out like this
file1 file2 file3
ABC ABC (4 Replies)
I have about 100s of files of type text in a known directory. I want to merge all files side by side. Number of lines in all the files will remain same.
For example file1 contains
cat
dog
File 2 contains
rat
mat
Output file should be
cat rat
dog mat
Using awk I was able to... (5 Replies)
Hi Team,
I have input like
Input file.txt
Contents:
Total: 939720704 bytes
Total: 521142272 bytes
Total: 262144 bytes
Total: 786432 bytes
Total: 9043968 bytes
Total: 9371648 bytes
I need out put like the content of file should be side by side.that is 1st line beside... (3 Replies)
Hi,
Thank you for your help in advance :D.
I have thousands of files like...
file01
file02
file03
.
.
.
file6324
I would like to paste every other file side by side so it looks like
file01 file02
file03 file04
...e.t.c
file6323 file6324 (3 Replies)
Could I run 2 python scripts at the same time side by side output on the same line in this same format but with scripts?
from itertools import izip_longest
with open("file1") as textfile1, open("file2") as textfile2:
for x, y in izip_longest(textfile1, textfile2, fillvalue=""):
x =... (4 Replies)
Discussion started by: bigvito19
4 Replies
LEARN ABOUT FREEBSD
tzsetup
TZSETUP(8) BSD System Manager's Manual TZSETUP(8)NAME
tzsetup -- set local timezone
SYNOPSIS
tzsetup [-nrs] [-C chroot_directory] [zoneinfo_file | zoneinfo_name]
DESCRIPTION
The tzsetup utility reads a database of timezone information and presents a menu allowing the user to select a specific zone without knowing
the details of the database layout. The selected zone is installed as the system default zone. The tzsetup utility also determines whether
any adjustment is necessary for systems where the hardware clock does not keep UTC.
The following options are available:
-C chroot_directory
Open all files and directories relative to chroot_directory.
-n Do not create or copy files.
-r Reinstall the zoneinfo file installed last time. The name is obtained from /var/db/zoneinfo.
-s Skip the initial question about adjusting the clock if not set to UTC.
It is possible to short-circuit the menu system by specifying the location of a zoneinfo_file or the name of the zoneinfo_name on the command
line; this is intended mainly for pre-configured installation scripts or people who know which zoneinfo they want to install.
TIMEZONE DATABASE
The contents of the timezone database are indexed by /usr/share/zoneinfo/zone.tab. This file lists, for each timezone data file, the ISO
3166 territory code, approximate geographical coordinates (in ISO 6709 format), and location within the territory.
The maintainers of the database maintain the following policies:
1. At least one zone for every country or inhabited geographical territory.
2. One zone for every distinct, documented timezone history since the beginning of the UNIX epoch (January 1, 1970, GMT).
3. Each zone is named for the most populous city therein. (Where possible, the database includes pre-1970 history for its city.)
The source code to the database (/usr/src/share/zoneinfo/[a-z]*) contains many additional comments and documentation references for the his-
torically minded.
FILES
/etc/localtime current time zone file
/etc/wall_cmos_clock see adjkerntz(8)
/usr/share/misc/iso3166 mapping of ISO 3166 territory codes to names
/usr/share/zoneinfo directory for zoneinfo files
/usr/share/zoneinfo/zone.tab mapping of timezone file to country and location
/var/db/zoneinfo saved name of the timezone file installed last
EXAMPLES
Normal usage, to select the right zoneinfo file via the dialog-based user interface:
tzsetup
Install the file /usr/share/zoneinfo/Australia/Sydney:
tzsetup /usr/share/zoneinfo/Australia/Sydney
Install the zoneinfo file for Australia/Sydney, assumed to be located in /usr/share/zoneinfo:
tzsetup Australia/Sydney
After a reinstall of the zoneinfo files, you can reinstall the latest installed zoneinfo file (as specified in /var/db/zoneinfo):
tzsetup -r
SEE ALSO date(1), adjtime(2), ctime(3), timezone(3), tzfile(5), adjkerntz(8), zdump(8), zic(8)DISCLAIMER
The representation of certain localities as being associated with certain countries and/or territories is for the purposes of identification
only, and does not imply any endorsement or rejection on the part of the FreeBSD Project of the territorial claims of any entity.
BUGS
Programs which are already running when tzsetup creates or updates /etc/localtime will not reflect the updated timezone. When the system is
first configured for a non-UTC hardware clock, it is necessary to run adjkerntz(8) (which normally happens as a part of system startup) in
order to update the kernel's idea of the correct timezone offset.
BSD October 21, 2009 BSD