Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Comparison between 2 large lists with Getting VALUES from one into the other
Top Forums Shell Programming and Scripting Comparison between 2 large lists with Getting VALUES from one into the other Post 302539603 by amurib on Monday 18th of July 2011 08:08:07 AM
Old 07-18-2011
Comparison between 2 large lists with Getting VALUES from one into the other
hi,

I have 2 large lists:

LIST A: containes 6 fields of many entries (VARIABLE number), like:

2011-07-10 | 18:19:47 | 38037300 | 9647808003122 | 2 | success

LIST B: containes 3 fields & 183 entries (FIXED number), like:

9647805651885 9647805651885 SCP_10

What I want is a CODE for:

comparison for each number (say: X) in 7th field of "LIST A", over the complete range of entries in "LIST B", through
for-do-done loop inside another one, such that:

(a) If this X fulfil the inequality: NUM1< X < NUM2 ==> then lock on this entry & take the correspondent VAL (in LIST B), and
append it in the 7th field of LIST A (in front of the "X", within the same line)... AND break out the loop, to take another value
in LIST A (say: Y) to do the same comparison over the whole range of LIST B... and so on till completing all values of LIST A.

(b) Otherwise (if X does not lie between NUM1 & NUM2) ==> then render for another run of loop to check with the next entry, and
so on... till finding it... and BREAK out of loop... & return to LIST A to take another value.

(c) If not found over the whole range of LIST B ==> then append "NotFound"
in the 7th field of LIST A (in front of the "X", within the same line).

To end up with FINAL LIST A of 7 fields (the required VALues in the 7th field).

EX for SUCCESSFUL found VALues:

2011-07-10 | 18:19:47 | 38037300 | 9647808003122 | 2 | success | SCP_5

EX for NOT FOUND VALues:

2011-07-10 | 16:32:47 | 38045300 | 9647818553444 | 5 | success | NotFound



Thanks in advance.

BR,
Ahmed
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to add two large values

Hi, Gives me wrong value when, $ echo `expr 2221753117 + 299363384` -1773850795 How to overcome this? Appreciate any help on this. -Om (5 Replies)
Discussion started by: Omkumar
5 Replies

2. Shell Programming and Scripting

Help In Calculation of large values in loop

Hi Gurus, I am writing a shell script in which i need to strip out the numbers from file the values are unknown i. e. the range cannot be predicted.. and in my current program the sum of values is not coming as desired i think the value of calculation is crossing the range i.e. after some... (6 Replies)
Discussion started by: sandeepb
6 Replies

3. UNIX for Dummies Questions & Answers

compare 2 very large lists of different length

I have two very large datasets (>100MB) in a simple vertical list format. They are of different size and with different order and formatting (e.g. whitespace and some other minor cruft that would thwart easy regex). Let's call them set1 and set2. I want to check set2 to see if it contains... (2 Replies)
Discussion started by: uiop44
2 Replies

4. Shell Programming and Scripting

Shell Script to Create non-duplicate lists from two lists

File_A contains Strings: a b c d File_B contains Strings: a c z Need to have script written in either sh or ksh. Derive resultant files (File_New_A and File_New_B) from lists File_A and File_B where string elements in File_New_A and File_New_B are listed below. Resultant... (7 Replies)
Discussion started by: mlv_99
7 Replies

5. Shell Programming and Scripting

csv 4 columns values comparison!

Hi all, i have a csv file which as the following data: 294;F03;2000;40441 294;F03;2000;40443 284;F01;5400;44051 284;F01;5700;45666 the file holds 11689 lines. I was trying to get a script running to output results from this file that for each line with the condition: if a line is found... (9 Replies)
Discussion started by: stryng
9 Replies

6. Shell Programming and Scripting

How to remove a subset of data from a large dataset based on values on one line

Hello. I was wondering if anyone could help. I have a file containing a large table in the format: marker1 marker2 marker3 marker4 position1 position2 position3 position4 genotype1 genotype2 genotype3 genotype4 with marker being a name, position a numeric... (2 Replies)
Discussion started by: davegen
2 Replies

7. Shell Programming and Scripting

Comparison of floating point values in shell

Hi Everyone , Need a simple code here , I Have a number in a variable say $a=145.67 . This value changes everytime loop begins . I need to print a specific message as shown below when the above variable lies in a specific range i.e. 1.if $a lies within 100 and 200 , it should display... (2 Replies)
Discussion started by: robert89
2 Replies

8. Shell Programming and Scripting

Reading off values from a large file

Hi, I have a large output file (star.log), with many lines of the following type *** T vavg unburnt: 723.187 / burnt: 2662.000 What I would like to do is pick the values 723.187 and 2662.000 and What I've got so far is awk '/unburnt:.*burnt:/{Tu=$6;Tb=$NF}END{print Tu, Tb}'... (6 Replies)
Discussion started by: lost.identity
6 Replies

9. Shell Programming and Scripting

Simple comparison between two lists.

I have two lists (input) Alpha and Beta. Alpha: Beta: Need the output like this: I would like to get an output like this: Alpha vs Beta | -- | a=1 | |z=3 | z=4 | Is it possible ? :cool: (5 Replies)
Discussion started by: linuxadmin
5 Replies

10. Shell Programming and Scripting

Count Unique values from multiple lists of files

Looking for a little help here. I have 1000's of text files within a multiple folders. YYYY/ /MM /1000's Files Eg. 2014/01/1000 files 2014/02/1237 files 2014/03/1400 files There are folders for each year and each month, and within each monthly folder there are... (4 Replies)
Discussion started by: whegra
4 Replies

LEARN ABOUT DEBIAN

platform::shell

platform::shell(3tcl)					       Tcl Bundled Packages					     platform::shell(3tcl)

__________________________________________________________________________________________________________________________________________________

NAME

       platform::shell - System identification support code and utilities

SYNOPSIS

       package require platform::shell ?1.1.4?

       platform::shell::generic shell
       platform::shell::identify shell
       platform::shell::platform shell
_________________________________________________________________

DESCRIPTION

       The platform::shell package provides several utility commands useful for the identification of the architecture of a specific Tcl shell.

       This  package  allows the identification of the architecture of a specific Tcl shell different from the shell running the package. The only
       requirement is that the other shell (identified by its path), is actually executable on the current machine.

       While for most platform this means that the architecture of the interrogated shell is identical to the architecture of  the  running  shell
       this  is  not generally true. A counter example are all platforms which have 32 and 64 bit variants and where a 64bit system is able to run
       32bit code. For these running and interrogated shell may have different 32/64 bit settings and thus different identifiers.

       For applications like a code repository it is important to identify the architecture of the shell which will  actually  run  the  installed
       packages, versus the architecture of the shell running the repository software.

COMMANDS

       platform::shell::identify shell
	      This command does the same identification as platform::identify, for the specified Tcl shell, in contrast to the running shell.

       platform::shell::generic shell
	      This command does the same identification as platform::generic, for the specified Tcl shell, in contrast to the running shell.

       platform::shell::platform shell
	      This command returns the contents of tcl_platform(platform) for the specified Tcl shell.

KEYWORDS

       operating system, cpu architecture, platform, architecture

platform::shell 						       1.1.4						     platform::shell(3tcl)
All times are GMT -4. The time now is 06:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy