Hey,
I have two files that have exactly the same format. They are both tab-delimited and contain 12 columns. However the # of rows vary. What I want to do is match columns # 5,6 and 7 between the two files. If they do match exactly (based on numbers) then I want the whole row from file 2 to... (1 Reply)
Hi to all,
I have two separated files:
FILE1
"V1" "V2" "V3"
Mary James Nicole
Robert Francisco Sophie
Nancy Antony Matt
Josephine Louise Rose
Mark Simon
Charles
FILE2
"V1" "V2" "V3"... (2 Replies)
Hi!
I need to merge two files when col1 (x:x:x) matching and adds second column from file1.txt.
# cat 1.txt
aaa;a12
bbb;b13
ccc;c33
ddd;d55
eee;e11
# cat 2.txt
bbb;b55;34444;d55
aaa;a15;35666;a44
I try with this awk and I get succesfully first column from 1.txt:
# awk -F";"... (2 Replies)
Hi,
I need to join two files together with one common value in a column. I think I can use awk or join or a combination but I can't quite get it.
Basically my data looks like this, with the TICKER columns matching up in each file
File1
TICKER,column 1, column, 2, column, 3, column 4
... (6 Replies)
Hello Help,
2356798 7689867 999 000
123678 20385907 9797 666
17978975 87468976 968978 98798
I am trying to have out put which actually look for the third column value of 9797 and then it insert line there after with first, second column value exactly as the previous line and replace the third... (3 Replies)
Given this file (I separated them in block to make my explanation clearer):
92157768877;Sof_deme_Fort_Email_am_%yyyy%%mm%%dd%;EMAIL;20/02/2015;1;0;0
92157768877;Sof_trav_Fort_Email_am_%yyyy%%mm%%dd%;EMAIL;20/02/2015;1;0;0
91231838895;Sof_deme_faible_Email_am;EMAIL;26/01/2015;1 0;0... (1 Reply)
I know I'm not the first one asking this but my code still does not work:
File 1: gi|1283| tRNAscan exon 87020 88058 . - . transcript_id "Parent=tRNA-Tyr5.r01";
gi|3283| tRNAscan exon 97020 97058 . + . transcript_id "Parent=tRNA-Tyr6.r01";
gi|4283| rRNAscan exon 197020 197058 . - . transcript_id... (5 Replies)
Hi All,
I am looking to join two files where column 1 of file A matches with column 1 of file B and column 5 of files A matches with column 2 of file B. After joining the files based on above condition, out should contain entire line of file A and column 3, 4 and 5 of file B.
Here is sample... (8 Replies)
I am using awk to match columns and output based on those matches. For some reason it is not printing matching columns, am I missing something?
Operating system - windows with cygwin.
Command that I am using:
sed 's/]*,]*/,/g' $tempdir/file1 > $tempdir/file1.$$ && awk -F, 'FNR==NR{f2=$2... (7 Replies)
Discussion started by: dis0wned
7 Replies
LEARN ABOUT DEBIAN
ledgersmb::dbobject::admin
LedgerSMB::DBObject::Admin(3pm) User Contributed Perl Documentation LedgerSMB::DBObject::Admin(3pm)NAME
LedgerSMB::DBObject::Admin - User/group management for LedgerSMB
SYNOPSIS
User/group management for LedgerSMB
INHERITS
Universal
LedgerSMB
LedgerSMB::DBObject
METHODS
save_user
Saves a user optionally with location and contact data.
If the password or import hash values is set, will not save contact or address information.
This API is not fully documented at this time because it is expected that it will be broken down into more manageable chunks in future
versions. Please do not count on the behavior.
delete_user($delete_role)
Deletes a user specified by $self->{user_id}.
if $delete_role is true, deletes the role too.
search_users
Returns a list of users matching search criteria, and attaches that list to the user_results hash value.
Search criteria:
username
first_name
last_name
ssn
dob
Undef matches all values. All matches exact except username which allows for partial matches.
list_sessions
returns a list of active sessions, when they were last used, and how many discretionary locks they hold. The list is also attached to
the active_sessions hash value. No inputs required or used.
delete_session
Deletes a session identified by the session_id hashref.
save_roles
Saves the roles assigned to a user. Each role is specified as a hashref true value, where the key is the full name of the role (i.e.
starting with lsmb_[dbname]__).
get_salutations
Returns a list of salutation records from the db for the dropdowns.
get_roles
Returns a list of role names with the following format:
{role => $full_role_name, description => $short_role_name}
The short role name is the full role name with the prefix removed (i.e. without the lsmb_[dbname]__ prefix).
get_countries
Returns a reference to an array of hashrefs including the country data in the db.
Sets the same reference to the countries hash value.
get_contact_classes
Returns a list of hashrefs ({id =>, class =>}) relating to the contact classes.
COPYRIGHT
Copyright (c) 2009, the LedgerSMB Core Team. This is licensed under the GNU General Public License, version 2, or at your option any later
version. Please see the accompanying License.txt for more information.
perl v5.14.2 2012-03-25 LedgerSMB::DBObject::Admin(3pm)