02-12-2018
Sort by record column, Compare with conditons and export the result
Hello,
I am new to Unix and would like to seek a help, please.
I have 2 files (file_1 and file_2), I need to perform the following actions.
1 ) Sort the both file by the column 26-36 (which is Invoice number)
what is sort command with the column sort?
2) Compare the file_1.sorted and file_2.sorted. I would like Unix to ignore the difference when the differences are data stamp.
The data stamp is in Record 0010 and Record 2000. (Record ID is in column 92-95)
Date stamp in Record 0010 is in the column 451 -471.
Date stamp in Record 2000 is in the column 356 -385.
My goal is only displays the difference other than the date stamps.
what is the Unix command for the compare?
3) Would like to set nowrap and export the result in text file.
Thank you so much for your help in advance.
Usagi
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi.
If we have this file
A B C
7 8 9
1 2 10
and this other file
A C D F
7 9 2 3
9 2 3 4
The result i´m looking for is intersection with A B C D F
so the answer here will be (10 Replies)
Discussion started by: alcalina
10 Replies
2. Shell Programming and Scripting
Hello,
I need to compare two files which have the following structure
File1:
No : 1
Name : George/Brown
Value2 : type2
Value3 : type3
Date : Wed Oct 20 11:12:58 2010
Value : yes
No : 2
Name : John/Cash
Value2 :... (4 Replies)
Discussion started by: @dagio
4 Replies
3. Shell Programming and Scripting
Hi,
I need a script to start searching a word from the particular record on the result of first occurence i need to change the value in that record.
I have a input file like this
<properties>
<add key="DeliveryWithinDay" value="False" />
<add key="ABC" value="23:00:00 PM" />
<add... (5 Replies)
Discussion started by: NareshN
5 Replies
4. UNIX for Advanced & Expert Users
Hi I am working on a script in which I am firing a query on database through Unix and getting the result set. I want to export that in an excel file. I am able to do so nut the result are exported horizontally one below the other. Can anyone plss help me out in exporting the Result in Tabular... (4 Replies)
Discussion started by: Saritau3
4 Replies
5. Shell Programming and Scripting
Hi! all
can any one tell me how to compare current record of column with next and previous record in awk without using array
my case is like this
input.txt
0 32
1 26
2 27
3 34
4 26
5 25
6 24
9 23
0 32
1 28
2 15
3 26
4 24 (7 Replies)
Discussion started by: Dona Clara
7 Replies
6. Shell Programming and Scripting
Hi,
Input file 1 :
37170 37196 77 51
37174 37195 73 52
37174 37194 73 53
Desired Output file 1 :
37170 37196 77 51
Input file 2 :
37174 37195 73 0
37170 37196 77 0
Desired Output file 2 :
37174 37195 73 0 (1 Reply)
Discussion started by: cpp_beginner
1 Replies
7. UNIX for Dummies Questions & Answers
Hi All,
I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record.
For example, let's assume for column D... (9 Replies)
Discussion started by: tpk
9 Replies
8. Shell Programming and Scripting
Hi Gurus,
I have requirement to compare current result with previous reuslt.
The sample case is below.
1 job1 1
1 job2 2
1 job3 3
2 job_a1 1
2 job_a2 2
2 job_a3 3
3 job_b1 1
3 job_b2 2
for above sample file, GID is group ID, for input line, the job run... (1 Reply)
Discussion started by: ken6503
1 Replies
9. Shell Programming and Scripting
Split column data if the table has n number of column's with some record then how to split n number of colmn's line by line with records
Table
---------
Col1 col2 col3 col4 ....................col20
1 2 3 4 .................... 20
a b c d .................... v
... (11 Replies)
Discussion started by: Priti2277
11 Replies
10. UNIX for Beginners Questions & Answers
Input file is as follows:
1 | 6
2 | 7
3 | 8
4 | 9
5 | 10
Output reuired (sum of the first column $1*$2)
1 | 6 | 90
2 | 7 | 105
3 | 8 | 120
4 |9 | 135
5 |10 | 150
Please enclose sample input, sample output, and code... (5 Replies)
Discussion started by: Sagar Singh
5 Replies
LEARN ABOUT DEBIAN
jifty::action::record
Jifty::Action::Record(3pm) User Contributed Perl Documentation Jifty::Action::Record(3pm)
NAME
Jifty::Action::Record -- An action tied to a record in the database.
DESCRIPTION
Represents a web-based action that is a create, update, or delete of a Jifty::Record object. This automatically populates the arguments
method of Jifty::Action so that you don't need to bother.
To actually use this class, you probably want to inherit from one of Jifty::Action::Record::Create, Jifty::Action::Record::Update, or
Jifty::Action::Record::Delete. You may need to override the "record_class" method, if Jifty cannot determine the record class of this
action.
METHODS
record
Access to the underlying Jifty::Record object for this action is through the "record" accessor.
record_class
This method can either be overridden to return a string specifying the name of the record class, or the name of the class can be passed to
the constructor.
report_detailed_messages
If the action returns true for "report_detailed_message", report the message returned by the model classes as the resulting message. For
Update actions, Put the per-field message in "detailed_messages" field of action result content. The default is false.
new PARAMHASH
Construct a new "Jifty::Action::Record" (as mentioned in Jifty::Action, this should only be called by "framework->new_action". The
"record" value, if provided in the PARAMHASH, will be used to load the "record"; otherwise, the primary keys will be loaded from the
action's argument values, and the "record" loaded from those primary keys.
arguments
Overrides the "arguments" in Jifty::Action method, to automatically provide a form field for every writable attribute of the underlying
"record".
This also creates built-in validation and autocompletion methods (validate_$fieldname and autocomplete_$fieldname) for action fields that
are defined "validate" or "autocomplete". These methods can be overridden in any Action which inherits from this class.
Additionally, if our model class defines canonicalize_, validate_, or autocomplete_ FIELD, generate appropriate an appropriate
canonicalizer, validator, or autocompleter that will call that method with the value to be validated, canonicalized, or autocompleted.
"validate_FIELD" should return a (success boolean, message) list.
"autocomplete_FIELD" should return a the same kind of list as Jifty::Action::_autocomplete_argument
"canonicalized_FIELD" should return the canonicalized value.
possible_columns
Returns the list of columns objects on the object that the action can update. This defaults to all of the "containers" or the
non-"private", non-"virtual" and non-"serial" columns of the object.
possible_fields
Returns the list of the "possible_columns"' names.
Usually at the end names are required, however for subclassing column objects are better, or this method in a subclass turns out to be "map
to column" - "filter" - "map to name" chain.
take_action
Throws an error unless it is overridden; use Jifty::Action::Record::Create, ::Update, or ::Delete
SEE ALSO
Jifty::Action, Jifty::Record, Jifty::DBI::Record, Jifty::Action::Record::Create, Jifty::Action::Record::Update,
Jifty::Action::Record::Delete
LICENSE
Jifty is Copyright 2005-2010 Best Practical Solutions, LLC. Jifty is distributed under the same terms as Perl itself.
perl v5.14.2 2011-02-21 Jifty::Action::Record(3pm)