01-09-2015
i've enter example. i can use excel but its huge data so i can't work in excel...
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
I am trying to use vlookup (Excel function) using awk but there is some problem :(
--file1--
ABC123
101F
X1 A $P=Z
X2 A $P=X
X3 B $P=F
X4 C $P=G
MNK180
END
--file2--
X1 A_t $P=Z
X2 A_t $P=X
X3 B_u $P=F
X4 C_o $P=G (2 Replies)
Discussion started by: young
2 Replies
2. Shell Programming and Scripting
Hi,
I am new to awk/unix and am trying to put together an awk script to perform an action similar to vlookup between the two csv files.
Here are the contents of the two files:
File 1:
Date,ParentID,Number,Area,Volume,Dimensions
2014-01-01,ABC,247,83430.33,857.84,8110.76... (9 Replies)
Discussion started by: Prit Siv
9 Replies
3. Shell Programming and Scripting
Hi folks,
awk 'NR==FNR {m=$0; next} $1 in m{$0=m} {print}' file2 file1
Works a charm for a vlookup type query, sourced from https://www.unix.com/shell-programming-and-scripting/215998-vlookup-using-awk.html
However my column content has white spaces and numbers. Example
file1
The Man... (6 Replies)
Discussion started by: pshields1984
6 Replies
4. Shell Programming and Scripting
I have two files
File1
175552 st_497858.1 rs86052.1 rs92185.1 st_001022416.1 174841 175552_174841
179912 st_001122967.2 rs90435.1 rs89122.1 st_001022583.1 175545 179912_175545
179912 st_001122967.2 rs90435.1 rs89122.1 st_001022584.1 175545 179912_175545
179967 st_001256606.1 rs93516.2... (1 Reply)
Discussion started by: sammy777888
1 Replies
5. Shell Programming and Scripting
Source file 1
335 R1-snapfound 0098F RDFType:R1 R2-Dev R2-snapfound ,010C0 RemoteSymmetrixID:345
335 R1-snapfound 00990 RDFType:R1 R2-Dev R2-snapfound ,010C1 RemoteSymmetrixID:345
335 R1-snapfound 009C0 RDFType:R1 R2-Dev R2-snapfound ,009C1 RemoteSymmetrixID:345
335 R1-snapfound 009C1... (5 Replies)
Discussion started by: ranjancom2000
5 Replies
6. Shell Programming and Scripting
Code used to find the server from cloum 3 and update needtotakesnap
Output came from above command
awk 'NR==FNR{A;next}$3 in A{$3 = "needtotakesnap " $3}1' /home/Others/active-server.txt /home/Others/all-server |grep server1
879 dummy server1_217_silver dummy 00870 TDEV 2071575
831 Tier1... (3 Replies)
Discussion started by: ranjancom2000
3 Replies
7. Shell Programming and Scripting
I need to vlookup and check the server not found.
Source file 1
server1
server2
server3
server4
server5_root
server6_silver
server7
server7-test
server7-temp
Source file 2
server1_bronze (6 Replies)
Discussion started by: ranjancom2000
6 Replies
8. Shell Programming and Scripting
Hello Folks,
What I wish to do is:
If first column matches in main and new file, then
paste $COL2 into output file. Something like vlookup. Please see also bold text in expected output.
mainfile
11
22
33
44
55
66
77
88
99
100
101
102 (4 Replies)
Discussion started by: baris35
4 Replies
9. UNIX for Beginners Questions & Answers
Hello, i am trying to print group name column(etc/group) on script (etc/passwd) since group name is not listed on etc/passwd columns. Im trying to do a vlookup. but i cant figure out how i can insert the vlookup command FNR==NR inside the print out command or the output. I also tried exporting... (2 Replies)
Discussion started by: joonisio
2 Replies
10. UNIX for Beginners Questions & Answers
Hi I just want again to ask for help on what command to use to vlookup f1 group name in "/etc/group" matching f3 of it to "/etc/passwd" f4. I do need to display group name in the output of /etc/passwd without using awk or NR==FNR command. thank you
while
IFS=: read -r f1 f2 f3 f4 f5 f6 f7... (4 Replies)
Discussion started by: joonisio
4 Replies
LEARN ABOUT LINUX
ndb_drop_index
NDB_DROP_INDEX(1) MySQL Database System NDB_DROP_INDEX(1)
NAME
ndb_drop_index - drop index from an NDB table
SYNOPSIS
ndb_drop_index options
DESCRIPTION
ndb_drop_index drops the specified index from an NDB table. It is recommended that you use this utility only as an example for writing NDB
API applications--see the Warning later in this section for details.
Usage
ndb_drop_index -c connect_string table_name index -d db_name
The statement shown above drops the index named index from the table in the database.
The following table includes options that are specific to ndb_drop_index. Additional descriptions follow the table. For options common to
most MySQL Cluster programs (including ndb_drop_index), see Options Common to MySQL Cluster Programs(1).
Table 17.18. ndb_drop_index Options and Variables: MySQL Cluster NDB 7.2
+--------------------------+-----------------------------------+-------------------------------------+
|Format | Description | Added / Removed |
+--------------------------+-----------------------------------+-------------------------------------+
| | Name of the database in which the | |
| --database=dbname, | table is found | All MySQL 5.5 based releases |
| | | |
| -d | | |
+--------------------------+-----------------------------------+-------------------------------------+
Warning
Operations performed on Cluster table indexes using the NDB API are not visible to MySQL and make the table unusable by a MySQL server.
If you use this program to drop an index, then try to access the table from an SQL node, an error results, as shown here:
shell> ./ndb_drop_index -c localhost dogs ix -d ctest1
Dropping index dogs/idx...OK
NDBT_ProgramExit: 0 - OK
shell> ./mysql -u jon -p ctest1
Enter password: *******
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 7 to server version: 5.5.35-ndb-7.2.15
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> SHOW TABLES;
+------------------+
| Tables_in_ctest1 |
+------------------+
| a |
| bt1 |
| bt2 |
| dogs |
| employees |
| fish |
+------------------+
6 rows in set (0.00 sec)
mysql> SELECT * FROM dogs;
ERROR 1296 (HY000): Got error 4243 'Index not found' from NDBCLUSTER
In such a case, your only option for making the table available to MySQL again is to drop the table and re-create it. You can use either
the SQL statementDROP TABLE or the ndb_drop_table utility (see ndb_drop_table(1)) to drop the table.
COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Oracle Corporation (http://dev.mysql.com/).
MySQL 5.5 01/30/2014 NDB_DROP_INDEX(1)