How to append two files(file1 and file2) Please help me? Post: 302900941

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

match value from file1 in file2

Hi, i've two files (file1, file2) i want to take value (in column1) and search in file2 if the they match print the value from file2. this is what i have so far. awk 'FILENAME=="file1"{ arr=$1 } FILENAME=="file2" {print $0} ' file1 file2

2. Shell Programming and Scripting

append text from file1 to the end of each line in file2

hi; my file2.txt:portname=1;list=10.11;l- portname=2;list=10.12;l- portname=3;list=10.13;l- ... my file1.txt:;"{'sector=%27'}"\&> so; i want to see:portname=1;list=10.11;l-;"{'sector=%27'}"\&> portname=2;list=10.12;l-;"{'sector=%27'}"\&> portname=3;list=10.13;l-;"{'sector=%27'}"\&>...

3. Shell Programming and Scripting

grep -f file1 file2

Hi I started to learn bash a week ago. I need filter the strings from the last column of a "file2" that match with a column from an other "file1" file1: chr10100036394-100038350AK077761 chr10100041065-100046547AK032226 chr10100041065-100046547AK016270 chr10100041065-100046547AK078231 ......

4. Shell Programming and Scripting

AWK: Pattern match between 2 files, then compare a field in file1 as > or < field in file2

First, thanks for the help in previous posts... couldn't have gotten where I am now without it! So here is what I have, I use AWK to match $1 and $2 as 1 string in file1 to $1 and $2 as 1 string in file2. Now I'm wondering if I can extend this AWK command to incorporate the following: If $1...

5. Shell Programming and Scripting

Compare a common field in two files and append a column from File 1 in File2

Hi Friends, I am new to Shell Scripting and need your help in the below situation. - I have two files (File 1 and File 2) and the contents of the files are mentioned below. - "Application handle" is the common field in both the files. (NOTE :- PLEASE REFER TO THE ATTACHMENT "Compare files...

6. UNIX for Dummies Questions & Answers

if matching strings in file1 and file2, add column from file1 to file2

I have very limited coding skills but I'm wondering if someone could help me with this. There are many threads about matching strings in two files, but I have no idea how to add a column from one file to another based on a matching string. I'm looking to match column1 in file1 to the number...

7. Shell Programming and Scripting

If file1 and file2 exist then

HI, I would like a little help on writing a if statement. What i have so far is: #!/bin/bash FILE1=path/to/file1 FILE2=path/to/file2 echo ${FILE1} ${FILE2} if ] then echo file1 and file2 not found else echo FILE ok fi

8. UNIX for Dummies Questions & Answers

Copy(append ) the contents of file1 and file2 to file3

Platform : Oracle linux 6.5 I have two log files with the following contents # ls -l total 8 -rw-r--r--. 1 root root 75 Dec 10 20:55 myLogfile1.log -rw-r--r--. 1 root root 51 Dec 10 20:57 myLogfile2.log # # cat myLogfile1.log hello world jaded zombies acted quaintly but kept driving...

9. UNIX for Dummies Questions & Answers

Compare file1 and file2, print matching lines in same order as file1

I want to print only the lines in file2 that match file1, in the same order as they appear in file 1 file1 file2 desired output: I'm getting the lines to match awk 'FNR==NR {a++}; FNR!=NR && a' file1 file2 but they are in sorted order, which is not what I want: Can anyone...

10. Shell Programming and Scripting

awk to search field2 in file2 using range of fields file1 and using match to another field in file1

I am trying to use awk to find all the $2 values in file2 which is ~30MB and tab-delimited, that are between $2 and $3 in file1 which is ~2GB and tab-delimited. I have just found out that I need to use $1 and $2 and $3 from file1 and $1 and $2of file2 must match $1 of file1 and be in the range...

LEARN ABOUT CENTOS

iodbctestw

iodbctest(1)						       iODBC Driver Manager						      iodbctest(1)

NAME

       iodbctest, iodbctestw - iODBC Demonstration programs

SYNOPSIS

       iodbctest ["DSN=xxxx[;UID=xxxx][;PWD=xxxx][;OPT=value]"]
       iodbctestw ["DSN=xxxx[;UID=xxxx][;PWD=xxxx][;OPT=value]"]

DESCRIPTION

       The  iodbctest  program and iodbtestw programs are simple ODBC sample programs, showing the strength of the ODBC API to connect to any ODBC
       enabled database, issue SQL commands and retrieve the query results.

       The iodbctest program uses the standard ODBC API calls to connect using any DSN, but retrieves all results in ASCII mode.

       The iodbctestw program uses the ODBC Unicode API calls to connect using any DSN, and retrieves all results in Unicode mode.

OPTIONS

       The iodbctest program uses the SQLDriverConnect function to make a connection using any available ODBC compliant driver.  This  allows  the
       user to override any ODBC connect attribute in the DSN string.

       Connect	strings  should  start with either a DSN=xxx or a DRIVER=xxxx attribute optionally followed by other DSN attributes separated by a
       semicolon e.g:

	    DSN=ora9;UID=scott;PWD=tiger;DATABASE=ora9u

       Any attributes required for a proper connection that are not entered in the DSN connect string, must be present in the odbc.ini file.

       If the connect string is passed as an argument to the iodbctest program, the string should be quoted as most shells use	the  semicolon	as
       their command separator. If the connect string is entered on the interactive prompt, no quotes should be used.

       After a successful connection has been established, the user is prompted for a SQL command to be send to the database. A SQL command cannot
       span multiple lines.

       If the SQL command returns one or more result sets, each result set is fetched using character buffers and displayed in a table.

       Additionally, the iodbctest program understands a few special commands:

       qualifiers
	       Show a list of qualifiers using the SQLTables catalog call.

       owners
	       Show a list of owners using the SQLTables catalog call.

       tables
	       Show a list of tables using the SQLTables catalog call.

       types
	       Show a list of tables types using the SQLTables catalog call.

       datatypes
	       Show a list of data types using the SQLGetTypeInfo catalog call.

       reconnect
	       Perform a disconnect/reconnect with the information saved during the first SQLDriverConnect.

       quit (or exit)
	       Exit the program and return to the shell.

EXAMPLES

       Start the iodbctest program and get a list of DSNs before making a connection:

	   $ iodbctest
	   OpenLink ODBC Demonstration program
	   This program shows an interactive SQL processor

	   Enter ODBC connect string (? shows list): ?

	   DSN				    | Driver
	   -----------------------------------------------------------------
	   ora9 			    | OpenLink Generic ODBC Driver
	   mysql			    | OpenLink Generic ODBC Driver
	   mysqllite			    | OpenLink Lite for MySQL
	   myodbc			    | MyODBC Driver
	   pgsql			    | OpenLink Generic ODBC Driver
	   tds				    | OpenLink Generic ODBC Driver

	   Enter ODBC connect string (? shows list): DSN=ora9;PWD=tiger
	   Driver: 05.20.0316 OpenLink Generic ODBC Driver (oplodbc.so)

	   SQL>

       Connect to an Oracle 9 instance which has been previously setup in the odbc.ini file:

	   $ iodbctest "DSN=ora9;UID=scott;PWD=tiger"
	   iODBC Demonstration program
	   This program shows an interactive SQL processor
	   Driver: 05.20.0316 OpenLink Generic ODBC Driver (oplodbc.so)

	   SQL>select * from emp

	   ID		    |NAME
	   -----------------+-------------------------------------------
	   1		    |Record 1
	   2		    |Record 2
	   2		    |Record 3

	    result set 1 returned 3 rows.

	   SQL> quit

COPYRIGHT

       Copyright (C) 1996-2009 by OpenLink Software

AUTHOR

       iODBC Administrator <iodbc@openlinksw.com>

3.52.7								   3 August 2005						      iodbctest(1)