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
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT DEBIAN
ocf_pacemaker_healthsmart
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)