Sponsored Content
Top Forums Shell Programming and Scripting Combine data from two files base on uniq data Post 302931511 by pareshkp on Tuesday 13th of January 2015 12:31:13 PM
Old 01-13-2015
Combine data from two files base on uniq data

File 1

Code:
ID    Name       Po1  Po2 
DD134 DD134_4A_1 NN-1 L_0_1
DD134 DD134_4B_1 NN-2 L_1_1
DD134 DD134_4C_1 NN-3 L_2_1
DD142 DD142_4A_1 NN-1 L_0_1
DD142 DD142_4B_1 NN-2 L_1_1
DD142 DD142_4C_1 NN-3 L_2_1
DD142 DD142_3A_1 NN-41 L_3_1
DD142 DD142_3A_1 NN-42 L_3_2

File 2 ( Combination of ID and Po1 have Two Value )

Code:
ID    Po1  Value
DD134 NN-1  GOOD
DD134 NN-1  Bad
DD134 NN-2  GOOD
DD134 NN-2  Bad
DD134 NN-3  GOOD
DD134 NN-3  Bad
DD142 NN-1  GOOD
DD142 NN-1  Bad
DD142 NN-2  GOOD
DD142 NN-2  Bad
DD142 NN-3  GOOD
DD142 NN-3  Bad
DD142 NN-41  GOOD
DD142 NN-41  GOOD
DD142 NN-42  GOOD
DD142 NN-42  Bad


File 3 ( Combination of ID and Po2 have Two Value )

Code:
ID    Po2   Value
DD134 L_0_1 0x00000000
DD134 L_0_1 0x00001002
DD134 L_1_1 0x00000000
DD134 L_1_1 0x00001000
DD134 L_2_1 0x00000000
DD134 L_2_1 0x00001002
DD142 L_0_1 0x00000000
DD142 L_0_1 0x00001002
DD142 L_1_1 0x00000000
DD142 L_1_1 0x00001000
DD142 L_2_1 0x00000000
DD142 L_2_1 0x00001000
DD142 L_3_1 0x00000000
DD142 L_3_1 0x00000000
DD142 L_3_2 0x00000000
DD142 L_3_2 0x00001000


Combine all files Base on Uniq Data :-

File 2 and file 3 have two values so first value shoud me Value1 and Secound Value Should be Value2.

File 4 :-

Code:
ID	Name	         Po1	Po2	Value1   Value2	Value1     	Value2
DD134	DD134_4A_1	NN-1	L_0_1	GOOD	Bad	0x00000000	0x00001002
DD134	DD134_4B_1	NN-2	L_1_1	GOOD	Bad	0x00000000	0x00001000
DD134	DD134_4C_1	NN-3	L_2_1	GOOD	Bad	0x00000000	0x00001002
DD142	DD142_4A_1	NN-1	L_0_1	GOOD	Bad	0x00000000	0x00001002
DD142	DD142_4B_1	NN-2	L_1_1	GOOD	Bad	0x00000000	0x00001000
DD142	DD142_4C_1	NN-3	L_2_1	GOOD	Bad	0x00000000	0x00001002
DD142	DD142_3A_1	NN-41	L_3_1	GOOD	GOOD	0x00000000	0x00000000
DD142	DD142_3A_1	NN-42	L_3_2	GOOD	Bad	0x00000000	0x00001000

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Using loop reading a file,retrieving data from data base.

Hi All, I am having trouble through, I am reading the input from tab delimited file containing several records, e.g. line1 field1 field2 field3 so on.. line2 field1 field2 field3 so on.. .. .. on the basis of certain fields for each record in input file, I have to retrieve... (1 Reply)
Discussion started by: Sonu4lov
1 Replies

2. UNIX for Dummies Questions & Answers

Recover data from 2 files then combine

Using dd or similar tools to recover data from 2 damaged cdroms, I need a way to then combine the 2 files, 1 from each cd, and make a good file: this all result from finding that certain cd's tops scratch easily even when using the "proper" cd markers, hence making the file useless, however the... (1 Reply)
Discussion started by: saint65
1 Replies

3. Shell Programming and Scripting

How to combine data files using for loop

Hi, I have 5 files basically;namely file1.txt situated each at folder A to E respectively. I would like to extract out third column from each of these file1.txt from folder A to folder E. Also, I wanted to extract the first and second column which are common. In other words, e.g ... (6 Replies)
Discussion started by: ahjiefreak
6 Replies

4. Shell Programming and Scripting

combine data of 2 files by variable

my first post ... please be gentle. I have been working on a script to get info out of mysql. Its a support ticket system database OTRS. I can write the subject of open tickets to a text file with a unique user id. I also have a text file with the unique user id, username and email adres. I... (11 Replies)
Discussion started by: dicenl
11 Replies

5. Shell Programming and Scripting

Modify log files to get uniq data

Hello, I have a log file that has following output as below. LAP.sun5 CC LAP.sun5 CQ perl.sun5 CC perl.sun5 CQ TSLogger.sun5 CC TSLogger.sun5 CQ TSLogger.sun5 KR WAS.sun5 CC WAS.sun5 MT WAS.sun5 CQ I want to output to be in the way below, i tried using awk but could not do it. ... (12 Replies)
Discussion started by: asirohi
12 Replies

6. Shell Programming and Scripting

get data from files combine them to a file

hi people; this is my file1.txt:192.168.1.1 192.168.1.2 192.168.1.3 192.168.1.4 ... this is my file2.txt:portnames usernames maxusercap ... i want to write to file3.txt:l ./getports 192.168.1.1 'get all;l+;get . portnames;l-' l ./getports 192.168.1.1 'get all;l+;get . usernames;l-'... (4 Replies)
Discussion started by: gc_sw
4 Replies

7. UNIX for Dummies Questions & Answers

Finding and Extracting uniq data in multiple files

Hi, I have several files that look like this: File1.txt Data1 Data2 Data20 File2.txt Data1 Data5 Data10 File3.txt Data1 Data2 Data17 File4.txt (6 Replies)
Discussion started by: Fahmida
6 Replies

8. Shell Programming and Scripting

How to combine the data of files?

I have a main file as follows aaa 3/2 = 1.5 aba 55+6 = 61 aca 67+8 = 75 hjk 3+3 = 67 ghd 66+30 = 96 ghj 99-3 = 96 ffg 67+3 = 70 I have 4 sub files named sub1, sub2, sub3, sub4 content of sub1 aaa 23+5 = 28 hjk 45+6 = 51 ghd 40-20 = 20 ... (2 Replies)
Discussion started by: jackevan
2 Replies

9. Shell Programming and Scripting

Combine/omit data from 2 files

i made a script on my own. this is for the inventory to all of my AWS servers, and i run it to all of my servers to get the hostname, please look at file2. Then i need some data in file3 as well,. i need to combine them #cat file1 192.10.1.41 server.age.com ###### 192.10.0.40 ssh cant... (10 Replies)
Discussion started by: kenshinhimura
10 Replies

10. Shell Programming and Scripting

Combine data out of 3 files into one new file

Hi, How can I combine the data of of three files into one new file? I try to give as much informations as possible. The three existing files are called file1 file2 and file3 the new file should named output_combined. The size of the files will be around 900 words/lines each .. but always... (5 Replies)
Discussion started by: MyMemberName
5 Replies
audit_class(4)							   File Formats 						    audit_class(4)

NAME
audit_class - audit class definitions SYNOPSIS
/etc/security/audit_class DESCRIPTION
/etc/security/audit_class is a user-configurable ASCII system file that stores class definitions used in the audit system. Audit events in audit_event(4) are mapped to one or more of the defined audit classes. audit_event can be updated in conjunction with changes to audit_class. See audit_control(4) and audit_user(4) for information about changing the preselection of audit classes in the audit system. Programs can use the getauclassent(3BSM) routines to access audit class information. The fields for each class entry are separated by colons. Each class entry is a bitmap and is separated from each other by a newline. Each entry in the audit_class file has the form: mask:name:description The fields are defined as follows: mask class mask name class name description class description Each class is represented as a bit in the class mask which is an unsigned integer. Thus, there are 32 different classes available. Meta- classes can also be defined. These are supersets composed of multiple base classes, and thus will have more than 1 bit in its mask. See EXAMPLES. Two special meta-classes are also pre-defined: all, and no. all Represents a conjunction of all allowed classes, and is provided as a shorthand method of specifying all classes. no Is the invalid class, and any event mapped solely to this class will not be audited. Turning auditing on to the all meta class will not cause events mapped solely to the no class to be written to the audit trail. This class is also used to map obsolete events which are no longer generated. Obsolete events are retained to process old audit trails files. EXAMPLES
Example 1: Using an audit_class File The following is an example of an audit_class file: 0x00000000:no:invalid class 0x00000001:fr:file read 0x00000002:fw:file write 0x00000004:fa:file attribute access 0x00000008:fm:file attribute modify 0x00000010:fc:file create 0x00000020:fd:file delete 0x00000040:cl:file close 0x00000100:nt:network 0x00000200:ip:ipc 0x00000400:na:non-attribute 0x00001000:lo:login or logout 0x00004000:ap:application 0x000f0000:ad:old administrative (meta-class) 0x00070000:am:administrative (meta-class) 0x00010000:ss:change system state 0x00020000:as:system-wide administration 0x00040000:ua:user administration 0x00080000:aa:audit utilization 0x00300000:pc:process (meta-class) 0x00100000:ps:process start/stop 0x00200000:pm:process modify 0x20000000:io:ioctl 0x40000000:ex:exec 0x80000000:ot:other 0xffffffff:all:all classes (meta-class) FILES
/etc/security/audit_class ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Interface Stability | See below | +-----------------------------+-----------------------------+ The file format stability is evolving. The file content is unstable. SEE ALSO
bsmconv(1M), au_preselect(3BSM), getauclassent(3BSM), audit_control(4), audit_event(4), audit_user(4), attributes(5) NOTES
It is possible to deliberately turn on the no class in the kernel, in which case the audit trail will be flooded with records for the audit event AUE_NULL. This functionality is available only if the Basic Security Module (BSM) has been enabled. See bsmconv(1M) for more information. SunOS 5.10 6 Jan 2003 audit_class(4)
All times are GMT -4. The time now is 04:50 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy