Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Sort by record column, Compare with conditons and export the result Post 303012945 by Usagi on Monday 12th of February 2018 05:03:52 PM
Old 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

find common lines using just one column to compare and result with all columns

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

Compare to files and export only different values

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

start searching a word from the particular record on the result of first occurence change the value

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

How to export Result to Excel Tabular format from UNIX?

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

How to compare current record,with next and previous record in awk without using array?

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

Problem facing to compare different column and print out record with smallest number

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

Match sum of values in each column with the corresponding column value present in trailer record

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

How to compare the current result with previous line result.?

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

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

Add column and multiply its result to all elements of another column

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
Jifty::DBI::Record::Memcached(3pm)			User Contributed Perl Documentation			Jifty::DBI::Record::Memcached(3pm)

NAME
Jifty::DBI::Record::Memcached - records with caching behavior SYNOPSIS
package Myrecord; use base qw/Jifty::DBI::Record::Memcached/; DESCRIPTION
This module subclasses the main Jifty::DBI::Record package to add a caching layer. The public interface remains the same, except that records which have been loaded in the last few seconds may be reused by subsequent get or load methods without retrieving them from the database. METHODS
load_from_hash Overrides the implementation from Jifty::DBI::Record to add support for caching. load_by_cols Overrides the implementation from Jifty::DBI::Record to add support for caching. _cache_config You can override this method to change the duration of the caching from the default of 5 seconds. For example, to cache records for up to 30 seconds, add the following method to your class: sub _cache_config { { 'cache_for_sec' => 30 } } memcached_config Returns a hash containing arguments to pass to Cache::Memcached during construction. The defaults are like: ( services => [ '127.0.0.1:11211' ], debug => 0, ) You may want to override this method if you want a customized cache configuration: sub memcached_config { ( servers => [ '10.0.0.15:11211', '10.0.0.15:11212', '10.0.0.17:11211', [ '10.0.0.17:11211', 3 ] ], debug => 0, compress_threshold => 10_000, ); } cache_key_prefix Returns the prefix we should prepend to all cache keys. If you're using one memcached for multiple applications, you want this to be different for each application or they might end up mingling data. AUTHOR
Matt Knopp <mhat@netlag.com> SEE ALSO
Jifty::DBI, Jifty::DBI::Record perl v5.14.2 2010-09-21 Jifty::DBI::Record::Memcached(3pm)
All times are GMT -4. The time now is 04:26 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy