Merging 2 text files when there is a common time stamp column in them
Dear Unix experts and users
I have 2 kinds of files like below, of which I need to merge them in the order of time.
File1: Data columns from file1 are indicated with 'x'.
File2:
Data columns from file2 are indicated with 'y'.
Here except the first entry from Date_Time column in both files all rest of the time stamp entries are different.
My result (or merged) file should be like below.
So describe the output it is sorted by time stamp but the sorting should preserve the position of other column data cells and we should include blanks where where the other file data doesn't exist. The context data field(s) should be as it is between and print int he output. By the way my files are of .csv type.
Please revert to me if my problem description is not clear.
Thanks
Sidda
Last edited by ks_reddy; 04-25-2013 at 04:00 AM..
Reason: Column names and data aligned
Hi, I have two files file1 and file2. I have to merge the columns of those two files into file3 based on common column of two files. To be simple.
file1:
Row-id name1
13456 Rahul
16789 Vishal
18901 Karan
file2 :
Row-id place
18901 Mumbai
... (2 Replies)
Hi All,
I do have 2 files
file 1 has 4 tab delimited columns
234 a c dfgyu
294 b g fih
302 c h jzh
328 z c san
597 f g son
File 2 has 2 tab delimted columns
234 23
302 24
597 24
I want to merge file 2 with file 1 based on the data common in both files which is the first column so... (6 Replies)
So I have two text files. The first one looks like this:
refsnp_id chr_name chrom_start
1 rs1000000 12 126890980
2 rs10000010 4 21618674
3 rs10000012 4 1357325
4 rs10000013 4 37225069
5 rs1000002 3 183635768
And the second one looks like this:
AUC rs1000000 0.03 0.1240
AUC ... (4 Replies)
I have two text files. One has two columns and looks like below:
rs# otherallele_freq
rs10399749 0
rs4030303 0
rs4030300 0
rs940550 1.000
rs13328714 0
rs11490937 0
rs6683466 0
rs12025928 1.000
rs6650104 0
rs11240781 0... (5 Replies)
Hi,
I need help to read file in a directory on basis of time stamp.
e.g. If file access in last 2 minutes it should not be copy to remote directory.
Below is my script.
+++++++++++++++++++++++++
#!/bin/ksh
DATE=`date +"%Y-%m-%d_%H%M"`
SEPARATER=" "
exec < out_interfaces.cfg... (1 Reply)
Hi,
I have to text files that I want to merge by the first column. The values in the first column pretty much match for the first part. However there are some values that are present in column 1 and not present in column 2 or vice versa. For such values I would like to substitute X for the... (9 Replies)
Hi, I am trying to merge information across 2 files. The first file is a "master" file, with all IDS. File 2 contains a subset of IDs of those in File 1.
I would like to match up individuals in File 1 and File 2, and add information in File 2 to that of File 1 if they appear. However, if an... (3 Replies)
Hi
I have file1 as
IJU_NSOMOW;
SOWWOD_TWUIQ;
and file2 as
how are you?;
fine there;
Now my problem is i need the output file as
IJU_NSOMOW; how are you?;
SOWWOD_TWUIQ; fine there; (2 Replies)
Hi Folks,
Need a clarification on files with date and time stamp.
Here is my requirement. There is a file created everyday with the following format "file.txt.YYYYMMDDHHMMSS".
Now i need to check for this file and if it is available then i need to do some task to the file.
I tried... (6 Replies)
Hi ,
I want to add a new column 'current_time stamp' in my existing csv file with current time stamp for all the records.I tried something this but this is printing 0 with date & time and printed date one line above header.Please help
awk -F "," 'BEGIN{ OFS="," } {$6=system("date... (5 Replies)
Discussion started by: netdbaind
5 Replies
LEARN ABOUT OSX
memberd
dsmemberutil(1) BSD General Commands Manual dsmemberutil(1)NAME
dsmemberutil -- various operations for the membership APIs, including state dump, check memberships, UUIDs, etc.
SYNOPSIS
dsmemberutil [-v] [-h] command [options]
DESCRIPTION
dsmemberutil is a program that implements the membership API calls in a command line utility.
FLAGS
A list of flags and their descriptions:
-h Lists the options for calling dsmemberutil
-v Causes dsmemberutil to operate in verbose mode.
COMMANDS
The action of each command is described below:
getuuid -ugUGsS value
Takes any of the options and returns the associated UUID.
getid -UGsSX value
Takes any of the options and returns the associated UID or GID depending on option provided.
getsid -ugUGX value
Takes any of the options and returns the associated SID.
checkmembership -uUxs param -gGXS param
Returns if a user or group with the associated option is a member of the group.
flushcache Flushes the current membership cache.
Legacy commands such as dumpstate and statistics are gone. See odutil(1) for show cache and statistics operations.
A list of options available. In some cases -xX and -sS can be used synonymously due to nature of the value.
-u uid Using user with UID
-U name Using user with name
-s sid Using user with SID
-x uuid Using user with UUID
-g gid Using group with GID
-G name Using group with name
-S sid Using group with SID
-X uuid Using group with UUID
EXAMPLES
Get a user's uuid:
% dsmemberutil getuuid -u 501
EEA4F2F6-B268-49E7-9C6F-E3C4A37DA4FD
Get a group's uuid
% dsmemberutil getuuid -g 0
ABCDEFAB-CDEF-ABCD-EFAB-CDEF00000000
Get a user's or group's id from a uuid
% dsmemberutil getid -X ABCDEFAB-CDEF-ABCD-EFAB-CDEF0000000C
gid: 12
Check a user's membership in a group (using UID and GID)
% dsmemberutil checkmembership -u 501 -g 0
user is not a member of the group
Check a user's membership in a group (using names)
% dsmemberutil checkmembership -U root -G wheel
user is a member of the group
SEE ALSO odutil(1), dseditgroup(1), dscacheutil(1)Darwin Jan 1, 2007 Darwin