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::employee
LedgerSMB::DBObject::Employee(3pm) User Contributed Perl Documentation LedgerSMB::DBObject::Employee(3pm)NAME
LedgerSMB::DBObject::Employee - LedgerSMB class for managing Employees
SYOPSIS
This module creates object instances based on LedgerSMB's in-database ORM.
METHODS
The following method is static:
new ($LedgerSMB object);
save
Saves an employee. Inputs required
entity_id
May not be undef
start_date
end_date
dob date
may not be undef
role
Not the database role. Either manager or user
ssn
sales
manager_id
employee_number
search
Returns a list of employees matching set criteria:
employeenumber (exact match)
startdate_from (start of date range)
startdate_to (end of date range)
first_name (partial match)
middle_name (partial match)
last_name (partial match)
notes (partial match)
Undef values match all values.
set_entity_class
Sets the entity class to 3.
get_managers
Retrieves a set of managers and attaches to $self->{all_managers}
save_location
Saves the location data for the contact.
Inputs are standard location inputs (line_one, line_two, etc)
save_contact
Saves contact information. Inputs are standard contact inputs:
entity_id
contact_class
contact
description
save_bank_account
Saves a bank account to an employee.
Standard inputs (entity_id, iban, bic)
get_metadata()
This retrieves various information vor building the user interface. Among other things, it sets the following properties:
$self->{ar_ap_acc_list} = qw(list of ar or ap accounts) $self->{cash_acc_list} = qw(list of cash accounts)
get Returns the employee record with all the inputs required for "save" populated.
Also populates:
locations
List of location info
contacts
List of contact info
notes
List of notes
bank account
List of bank accounts
save_notes
Saves a note to an employee entity.
Standard inputs (note, subject, entity_id)
delete_contact
required request variables:
contact_class_id: int id of contact class contact: text of contact information person_id: int of entity_credit_account.id,
preferred value
delete_location
Deletes a record from the location side.
Required request variables:
location_id location_class_id person_id
Returns true if a record was deleted. False otherwise.
delete_bank_account
Deletes a bank account
Requires:
entity_id bank_account_id
Returns true if a record was deleted, false otherwise.
get_user_info
Attaches the user_id and username to the employee object.
If the user does not have manage_users powers, this will simply return false
Copyright (C) 2007, The LedgerSMB core team.
This file is licensed under the Gnu General Public License version 2, or at your option any later version. A copy of the license should
have been included with your software.
perl v5.14.2 2012-03-10 LedgerSMB::DBObject::Employee(3pm)