Sponsored Content
Top Forums Shell Programming and Scripting Files summary using awk based on index key Post 302994096 by alex2005 on Saturday 18th of March 2017 06:17:52 PM
Old 03-18-2017
Many thanks for your help ,and sorry for introducing the "IN" instead of "X".

Now everything works like a charm.

Again very smart solution provided.

Kind Regards
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

merging two files based on some key

I have to merge two files: The files are having the same format like A0this is first line TOlast line silmilarly other lines. I have to search for A0 line in the second file also and then put the data in the third file under A0 heading ,then for A1 and so on. A0 portion will be treminated... (1 Reply)
Discussion started by: Vandana Yadav
1 Replies

2. Shell Programming and Scripting

Merge files based on key

Hi Friends, Can any one help me with merging these file based on two columns : File1: A|123|99|SAMS B|456|95|GEORGE D|789|85|HOVARD File2: S|123|99|NANcY|6357 S|123|99|GREGRO|83748 A|456|95|HARRY|827|somers S|456|95|ANTONY|546841|RUDOLPH|7263 B|456|95|SMITH|827|BOISE STATE|834... (3 Replies)
Discussion started by: sbasetty
3 Replies

3. Shell Programming and Scripting

joining files based on key column

Hi I have to join two files based on 1st column where 4th column of a2.txt=at and take 2nd column of a1.txt and 3rd column of a2.txt and check against source files ,if matches list those source file names. a1.txt a1|20090809|20090810 a2|20090907|20090908 a2.txt a1|d|file1.txt|at... (9 Replies)
Discussion started by: akil
9 Replies

4. Shell Programming and Scripting

Gawk / Awk Merge Lines based on Key

Hi Guys, After windows died on my netbook I installed Lubuntu and discovered Gawk about a month ago. After using Excel for 10+ years I'm amazed how quick and easily Gawk can process data but I'm stuck with a little problem merging data from multiple lines. I'm an SEO Consultant and provide... (9 Replies)
Discussion started by: Jamesfirst
9 Replies

5. Shell Programming and Scripting

Merge two files based on a 3rd key file

Hi, I want to merge the two files based on the key file's columns. The key file: DATE~DATE HOUSE~IN_HOUSE CUST~IN_CUST PRODUCT~PRODUCT ADDRESS~CUST_ADDR BASIS_POINTS~BASIS_POINTS ... The other 2 files are From_file & To_file - The From_file: DATE|date/time|29|9 ... (9 Replies)
Discussion started by: dips_ag
9 Replies

6. Shell Programming and Scripting

Using AWK to format output based on key field

I have file which contains gene lines something like this Transcript Name GO POPTR_0016s06290.1 98654 POPTR_2158s00200.1 11324 POPTR_0004s22390.1 12897 POPTR_0001s11490.1 POPTR_0016s13950.1 14532 POPTR_0015s05840.1 13455 POPTR_0013s06470.1 12344... (6 Replies)
Discussion started by: shen
6 Replies

7. Shell Programming and Scripting

Fetch the values based on a Key using awk from single file

Hi, Please help to fetch the values for a key from below data format in linux. Sample Input Data Format 11055005|PurchaseCondition|GiftQuantity|1 11055005|PurchaseCondition|MinimumPurchase|400 11055005|GiftCatalogEntryIdentifier|Id|207328014 11429510|PurchaseCondition|GiftQuantity|1... (2 Replies)
Discussion started by: mohanalakshmi
2 Replies

8. Shell Programming and Scripting

awk - Merge two files based on one key

Hi, I am struggling with the an awk command to merge two files based on a common key. I want to append the value from File2 ($2) onto the end of File1 where $1 from each file matches - If no match then nothing is apended File1 COL1|COL2|COL3|COL4|COL5|COL6|COL7... (3 Replies)
Discussion started by: Ads89
3 Replies

9. UNIX for Beginners Questions & Answers

Match tab-delimited files based on key

I thought I had this figured out but was wrong so am humbly asking for help. The task is to add an additional column to FILE 1 based on records in FILE 2. The key is in COLUMN 1 for FILE 1 and in COLUMN 1 OR COLUMN 2 for FILE 2. I want to add the third column from FILE 2 to the beginning of... (8 Replies)
Discussion started by: andmal
8 Replies

10. UNIX for Beginners Questions & Answers

Matching 2 files based on key

Hi all I have two files I need to match record from first file and second file on column 1,8 and and output only match records on file1 File1: 020059801803180116130926800002090000800231000245204003160000000002000461OUNCE000000350000100152500BM01007W0000 ... (5 Replies)
Discussion started by: arunkumar_mca
5 Replies
OCF_PACEMAKER_HEALTH(7) 				      Pacemaker Configuration					   OCF_PACEMAKER_HEALTH(7)

NAME
ocf_pacemaker_HealthSMART - SMART health status SYNOPSIS
OCF_RESKEY_state=string OCF_RESKEY_drives=string OCF_RESKEY_devices=string OCF_RESKEY_temp_lower_limit=string OCF_RESKEY_temp_upper_limit=string OCF_RESKEY_temp_warning=string HealthSMART [start | stop | monitor | meta-data | validate-all] DESCRIPTION
Systhem health agent that checks the S.M.A.R.T. status of the given drives and updates the #health-smart attribute. SUPPORTED PARAMETERS
OCF_RESKEY_state = string [/HealthSMART-{OCF_RESOURCE_INSTANCE}.state] State file Location to store the resource state in. OCF_RESKEY_drives = string [/dev/sda] Drives to check The drive(s) to check as a SPACE separated list. Enter the full path to the device, e.g. "/dev/sda". OCF_RESKEY_devices = string Device types The device type(s) to assume for the drive(s) being tested as a SPACE separated list. OCF_RESKEY_temp_lower_limit = string [0] Lower limit for the red smart attribute Lower limit of the temperature in deg C of the drive(s). Below this limit the status will be red. OCF_RESKEY_temp_upper_limit = string [60] Upper limit for red smart attribute Upper limit of the temperature if deg C of the drives(s). If the drive reports a temperature higher than this value the status of #health-smart will be red. OCF_RESKEY_temp_warning = string [5] Deg C below/above the upper limits for yellow smart attribute Number of deg C below/above the upper/lower temp limits at which point the status of #health-smart will change to yellow. AUTHOR
Andrew Beekhof <andrew@beekhof.net> Author. Pacemaker Configuration 04/17/2012 OCF_PACEMAKER_HEALTH(7)
All times are GMT -4. The time now is 04:30 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy