Thanks for reply. It works well for give example but not for my files probably because there are multiple mappings involved.
plz refer to file attached.
For example, for file test1 for first 3 rows (1st field "1"), it should be pick entry from test2 as "4" (because 1st entry of test1 i.e. 1 matches with 1st entry of test2 for all three cases.)
similarly for file test1 for 4th, 5th & 6th rows, the value picked up from file test2 should be "2".
Hi ,
I have wrote a telnet clinet application to interact with remote system . This program takes the screen shots for every interaction and send back to us. After connecting to remote machine , i want to call tip utility to interact with a device which is connected to one remote system. Now my... (0 Replies)
Dear All,
i want to implement vookup function which is there in excel into Unix. Suppose i have 2 files. The files are given below.
File1:
MSC Cell SDCA
Patna-1 12 Bihar
Patna-2 45 Ranchi
Bhopal-1 85 Raigarh
Bhopal-2 ... (8 Replies)
Hi guys,
can someone please help me with a vlookup utility in shell script that does the work similar to Excel.
Ex:
If File1.txt is
1
2
11
4
12
and File2.txt is
1 tab1
2 tab2
3 tab3
4 tab4
5 tab5
then the utility should create File3.txt with the below mentioned output: (24 Replies)
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)
Hi,
I work on a Middleware application which is installed on Windows, but its file System is on HP UNIX. I am supposed to change the SMTP host address for my application. But I am not able to find the file where the old SMTP host would have been configured/hardcoded. Can anyone assist me on this... (2 Replies)
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)
I'm slowly hacking away at a zsh script that shows some promise as a command line tool. I want to learn more about the conventions regarding command line tool development in Unix (and/or macOS), but don't really know where to look for this information.
What is the correct way, or convention, to... (2 Replies)
Hi,
I want to compare same column in two files, if values match then display the column or display "NA".
Ex :
File 1 :
123
abc
xyz
pqr
File 2:
122
aab
fdf
pqr
fff
qqq
rrr (1 Reply)
Discussion started by: hkoshekay
1 Replies
LEARN ABOUT DEBIAN
osql
osql(1) FreeTDS Utilities osql(1)NAME
osql - utility to test FreeTDS connections and queries
SYNOPSIS
osql -S dsn -U username -P password [-I ini_dir]
DESCRIPTION
osql is a diagnostic tool provided as part of FreeTDS. It is a Bourne shell script that checks and reports on your configuration files. If
everything checks out OK, it invokes isql.
osql works only with the isql that comes with unixODBC.
OPTIONS -S dsn the Data Source Name to which to connect, as known to odbc.ini.
-U username
database login name.
-P password
database password.
-I ini_dir
override odbc.ini file location.
EXAMPLE
If you have an odbc.ini with a section like this:
[myDSN]
servername = myserver
TDS_Version = 5.0
You would invoke osql as:
osql -S myDSN [...]
NOTES
If you can connect with "osql -S servername -U user -P passwd", your FreeTDS ODBC installation is working.
osql guesses where unixODBC might look for its odbc.ini by examining the binary. This is not always an effective approach. If it doesn't
work, you'll receive a report of candidate strings. Kindly pass along the output to help improve the guessing.
If osql cannot intuit your odbc.ini directory, you can force the issue with the -I option. However, you're instructing osql what to test,
not where unixODBC will eventually look. Your override is therefore only as good as you are. Look carefully at the error output before
overriding.
If you have suggestions for ways to make osql more useful as a diagnostic tool, please post them to the FreeTDS mailing list.
HISTORY
osql first appeared in FreeTDS 0.65.
AUTHORS
The osql utility was written by James K. Lowden
doc 13 November 2011 osql(1)