Help in writing a KSH script to filter the latest record?
Hi All,
I have a text file with the folowing content.
I want to extract the latest (The third column can be used to identify the latest record) records in the above file for each name (the last field).
Finaly the output should be like this.
Can any one help me to write the unix shell script to get this output?
Thanks in advance.
Karpak
Last edited by Scott; 02-05-2010 at 04:44 AM..
Reason: Fixed code tags
hello,
how can I filter and get the latest order number (last five digits) below:
input file:
johnmm00001
maryyy00121
johnm100222
johnmm00003
maryyy00122
output file:
johnmm00003
maryyy00122
johnm100222 (6 Replies)
Anyone can help for filter the uniq record for below example? Thank you very much
Input file
20090503011111|test|abc
20090503011112|tet1|abc|def
20090503011112|test1|bcd|def
20090503011131|abc|abc
20090503011131|bbc|bcd
20090503011152|bcd|abc
20090503011151|abc|abc... (8 Replies)
Reposting since I didnt not get any reply.
I have a problem while filtering records from a file. Can somebody help please?
For eg: Consider the below files
Record file:
0003@00000000000190@20100401@201004012010040120100401@003@... (1 Reply)
Hello all!! I am new here and new in scripting!
I want to write a ksh script to select the most recent file from a dir and use it in a variable.
I have a directory with files named like: YYYMMDD
A basic idea of the script I want to write is
#!/usr/bin/ksh
latest= latest_dated_file at... (2 Replies)
Hi,
I need a ksh script for the below requirement:
i have a Delimited flat file with 200 records delimiter is '|~|'
i need a script to insert space at the end if the record is ending with delimiter '|~|'
if it didnt end with delimiter it should not append space.
Example: ram|~|2|~| ... (16 Replies)
Dear friend,
I have a file 2 files with column wise
FILE_A
------------------------------
x,1,@
y,3,$
x,5,%
FILE_B
--------------------
x,1,@
i like to delete the all lines in FILE_A ,if first column available in FILE_B.
output (in FILE_A)
y,3,$
x,5,% (10 Replies)
Dear All,
I have getting data as follows, the second field signifies table name and last one is time stamp. I have return always latest record based on time stamp. Could you please help me ?
I/P
====
... (1 Reply)
Using ksh, I am using SQLPlus to execute a query with a filter using a string variable.
REPO_DB=DEV1
FOLDER_NM='U_nmalencia'
FOLDER_CHECK=$(sqlplus -s /nolog <<EOF
CONNECT user/pswd_select@${REPO_DB}
set echo off heading off feedback off
select subj_name
from subject
where... (5 Replies)
I have requirement to print latest record from file based on multiple columns combination.
EWAPE EW1SLE0000 EW1SOMU01 ABORTED 03/16/2015 100004 03/16/2015 100005 001
EWAPE EW1SLE0000 EW1SOMU01 ABORTED 03/18/2015 140003 03/18/2015 140004 001
EWAPE EW1SLE0000 EW1SOMU01 ABORTED 03/18/2015 220006... (1 Reply)
Discussion started by: tmalik79
1 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)