06-11-2015
Remove entire line from a file if 1st column matches a pattern
I have one requirement to delete all lines from a file if it matches below scenario. File contains three column. Employee Number, Employee Name and Employee ID
Scenario is: delete all line if Employee Number (1st column) contains below
1. Non-numeric Employee Number
2. Employee Number that are over 99999 (data length is over 5 characters)
3. Employee Number that have any alpha characters
At present my file looks like as below
HTML Code:
0000-|John T|johnT
4906790742|amit kumar|akumar
SM36950SE2|Mike henry|mhenry1
03942|ronald F|ronaldf
36152|anshu ran|aran2
C0490|micheal z|michael3
I want my file should look like
HTML Code:
03942|ronald F|ronaldf
36152|anshu ran|aran2
I need your assistance and guidance on this.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hey guys, I have a file that I've slowly been awking, seding, and greping for data entry. I am down to pull the addresses out to insert them into an excel file. Each address is a few lines, but i want to put a semicolon delimiter in between each address so I can export the text file into excel and... (6 Replies)
Discussion started by: Cocoabean
6 Replies
2. Shell Programming and Scripting
Hi,
I want to replace a column in a file if it matches certain pattern. Can you help me on this.
Here is the file content.
000000 1111111 2222222
011111 0123445 1234556
023445 1111111 2343455
if second column contains 1111111 i need to replace it with 0000000
Can you... (6 Replies)
Discussion started by: Krrishv
6 Replies
3. Shell Programming and Scripting
I'm having problems since few days ago, and i'm not able to make it works with a simple awk+grep script (or other way to do this).
For example, i have a input file1.txt:
cat inputfile1.txt
218299910417
1172051195
1172070231
1172073514
1183135117
1183135118
1183135119
1281440202
... (3 Replies)
Discussion started by: poliver
3 Replies
4. Shell Programming and Scripting
but keep if does not
I have a file: --> my.out
foo: bar
foo: moo
blarg
i am on vacation
foo: goose
foo: lucy
foo: moose
foo: stucky
groover@monkey.org
foo: bozo
grimace@gonzo.net
dear sir - blargo blargo
foo: goon
foo: sloppy
foo: saudi
gimme gimme gimme (3 Replies)
Discussion started by: spacegoose
3 Replies
5. Shell Programming and Scripting
Can anyone please help with this? I have 2 files as given below.
If 2nd column of file1 has pattern foo1@a, find the matching 1st column in file2 & replace 2nd column of file1 with file2's value.
file1
abc_1 foo1@a ....
abc_1 soo2@a ...
def_2 soo2@a ....
def_2 foo1@a ........ (7 Replies)
Discussion started by: prashali
7 Replies
6. Shell Programming and Scripting
Hi All,
I have a file testarun.txt contains the below lines and i want to print the lines if the character positions 7-8 matches 01.
201401011111
201401022222
201402013333
201402024444
201403015555
201403026666
201404017777
201404028888
201405019999
201405020000
I am trying the... (4 Replies)
Discussion started by: Arunprasad
4 Replies
7. Shell Programming and Scripting
Hi all,
I have file on which I do grep on "/tmp/data" then I get 5 lines as
dir Path: /tmp/data/20162343134
Starting to listen on ports logging:
--
Moving results files from local storage: /tmp/resultsFiles/20162343134/*.gz to NFS: /data/temp/20162343134/outgoing
from above got to get... (7 Replies)
Discussion started by: girijajoshi
7 Replies
8. Shell Programming and Scripting
I have a file with class c IP addresses that I need to match to a column and print the matching lines of another file.
I started playing with grep -if file01.out file02.out but I am stuck as to how to match it to a column and print the matching lines;
cat file01.out
10.150.140... (5 Replies)
Discussion started by: lewk
5 Replies
9. UNIX for Beginners Questions & Answers
hi
I have 2 file with more than 10 columns for both
1st file
apple,0,0,0......
orange,1,2,3.....
mango,2,4,5.....
2nd file
apple,2,3,4,5,6,7...
orange,2,3,4,5,6,8...
watermerlon,2,3,4,5,6,abc...
mango,5,6,7,4,6,def.... (1 Reply)
Discussion started by: tententen
1 Replies
10. UNIX for Beginners Questions & Answers
Hi all,
I have searched and searched, but I have not found a solution that quite fits what I am trying to do.
I have a long list of data in three columns. Below is a sample:
1,10,8
2,12,10
3,13,12
4,14,14
5,15,16
6,16,18
Please use code tags
What I need to do is as follows: If a... (4 Replies)
Discussion started by: bleedingturnip
4 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)