maybe this is very redundant for such task,
but maybe this will anticipate possible problems with more complex input
This instance with integrated version control requires gnu awk
Code:
awk '
NR == FNR { T[$2] = $1 (T[$2]?FS T[$2]:""); next }
{ lin = 0; for (i=1; i<=NF; i++)
if ($i in T) lin++
}
lin == NF { for (i=1; i<=NF; i++) {
if (T[$i]) print $i FS gensub(/^.*\s/, "", 1, T[$i])
sub(/\s?[^ ]+$/, "", T[$i])
}
}
' Table2 Table1
Last edited by nezabudka; 12-24-2019 at 04:13 PM..
These 2 Users Gave Thanks to nezabudka For This Post:
Hey guys,
I needed to add a route to my routing table and I got it to work but on reboot it gets removed. Anyone know what file I can add this route to so it stays on the machine after a reboot? (9 Replies)
I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated.
Input:
test_data_1
1 2 90%
4 3 91%
5 4 90%
6 5 90%
9 6 90%
test_data_2
3 5 92%
5 4 92%
7 3 93%
9 2 92%
1 1 92%
...
Output:... (7 Replies)
Hi ,
I have two tables with same length t1 and t2, I want to cretae a new third table where i put the difference between the elements of t2 and t1,
t3= t1 - t2
t3= t1 - t2
I am new to scripts, any help please? thanks (7 Replies)
I am comparing two table structure in different databases,Put into 2 txt files , when comparing if column sequnce and data type is not matching ,it has to display that info else Table structure is ok.
wrote shell script ,its not working .I am getting "Table structure is not ok" even if both... (1 Reply)
I have a host table that looks similar like this:
# IP Name Comment
10.10.10.1 Lab1-1 # Static for Lab1 subnet
10.10.10.2 Lab1-2 # Static for Lab1 subnet
10.10.10.3 Lab1-3 ... (2 Replies)
Hi, I have text file:
Name: xyz
Gender: M
Address: "120_B_C; ksilskdj; lsudlfw"
Zip: 20392
Name: KLM
Gender: F
Address: "65_D_F; wnmlsi;lsuod;,...."
Zip:90233I want to insert 2 new lines before the 'Address: ' line deriving value from this Address line value
The Address value in quotes... (1 Reply)
Hi,
Can anyone help me that, How to see the table fields in Oracle database through shell script(ksh).
I have tried with the following:
sqlplus -s $user/$passwd@$sid << SQL >> session.log
select * from Testtab.sql
I'm not able to see anything..
Thanks (4 Replies)
Hello,
I have two files file 1 and file 2 each having result of a query on certain database tables and need to compare for Col1 in file1 with Col3 in file2, compare Col2 with Col4 and output the value of Col1 from File1 which is a) not present in Col3 of File2 b) value of Col2 is different from... (2 Replies)
Using the awk below I am able to combine all the matching dates in $1, but I can not seem to remove the non-matching from the file. Thank you :).
file
20161109104500.0+0000,x,5631
20161109104500.0+0000,y,2
20161109104500.0+0000,z,2
20161109104500.0+0000,a,4117... (3 Replies)
Discussion started by: cmccabe
3 Replies
LEARN ABOUT LINUX
mnesia_registry
mnesia_registry(3erl) Erlang Module Definition mnesia_registry(3erl)NAME
mnesia_registry - Dump support for registries in erl_interface.
DESCRIPTION
The module mnesia_registry is usually part of erl_interface , but for the time being, it is a part of the Mnesia application.
mnesia_registry is mainly an module intended for internal usage within OTP, but it has two functions that are exported for public use.
On C-nodes erl_interface has support for registry tables. These reside in RAM on the C-node but they may also be dumped into Mnesia tables.
By default, the dumping of registry tables via erl_interface causes a corresponding Mnesia table to be created with mnesia_registry:cre-
ate_table/1 if necessary.
The tables that are created with these functions can be administered as all other Mnesia tables. They may be included in backups or repli-
cas may be added etc. The tables are in fact normal Mnesia tables owned by the user of the corresponding erl_interface registries.
EXPORTS
create_table(Tab) -> ok | exit(Reason)
This is a wrapper function for mnesia:create_table/2 which creates a table (if there is no existing table) with an appropriate set
of attributes . The table will only reside on the local node and its storage type will be the same as the schema table on the local
node, ie. {ram_copies,[node()]} or {disc_copies,[node()]} .
It is this function that is used by erl_interface to create the Mnesia table if it did not already exist.
create_table(Tab, TabDef) -> ok | exit(Reason)
This is a wrapper function for mnesia:create_table/2 which creates a table (if there is no existing table) with an appropriate set
of attributes . The attributes and TabDef are forwarded to mnesia:create_table/2 . For example, if the table should reside as
disc_only_copies on all nodes a call would look like:
TabDef = [{{disc_only_copies, node()|nodes()]}],
mnesia_registry:create_table(my_reg, TabDef)
SEE ALSO mnesia(3erl), erl_interface(3erl)Ericsson AB mnesia 4.4.17 mnesia_registry(3erl)
12-24-2019
requires gnu awk