Can someone help me with the following 2 objectives?
1) The following command is just an example. It gets a list of all print jobs. From there I am trying to extract the printer name. It works with the following command:
lpstat -W "completed" -o | awk -F- '{ print $1}'
Problem is, I want... (6 Replies)
I need to add the content of file1 to file2 - all lines but not those existing in file2 already, so the "cat file1 >> file2" doesn't work.
For example,
file1:
100 xxxxxx str1
102 xxxxxx str2
File2:
50 xxxxxxx xxx
30 xxxxxxxxxxx
102 xxxxxx str2 xxxx
......
the result:
50 xxxxxxx... (9 Replies)
Hello,
I have file to work with. It has 5 columns. The first three, altogether, constitutes the position. The 4th column contains some values for downstream analysis and the fifth column contains some values that I want to add to 4th column (only if they happen to be in the same position).
My... (5 Replies)
I know uniq exists, but am not sure how to remove repeating lines when they are groups of two different lines repeating themselves, without using sort. I need them to be sorted in the original order, just to remove repeats.
cd /media/AUDIO/WAVE/9780743518673/mp3
~/Desktop/mp3-to-m4b... (1 Reply)
Hello all,
I need to print all the lines before a specific string and print a custom message 2 lines after that.
So far I have managed to print everything up the string, inclusively, but I can't figure out how to print the 2 lines after that and the custom message.
My code thus far is:... (4 Replies)
Hey Guys!
I have written a code which combines lots of files into one big file(.csv).
However, each of the original files had headers on the first line, and now that I've combined the files the headers are interspersed throughout the new combined data frame. For example, throughout the data... (21 Replies)
Hi !
I need some help with a script I am writing.
I am trying to compare two files, the first file being in this format :
Header1
Text1-1
Text1-2
Text1-3
Header2
Text2-1
etc...
For each header, I want to check if it appears in the second file, and if it is the case print the header... (4 Replies)
Hi,
I'm having trouble in achieving the following scenario. There is a txt file with thousands of lines and few lines are repeated, which needs to be removed using a script.
File.txt
20140522121432,0,12,ram
Loc=India
From=ram@xxx.com, To=ravi@yyy.com,,
1
2
3
4
.
.
30... (18 Replies)
The bash below executes and seems to work fine on those files in which . However on those files where there is no additional CNV detected that line repeats multiple times
instead of only once. I tried adding an END as all lines are printed but that doesn't help. I can not seem to solve this... (5 Replies)
Discussion started by: cmccabe
5 Replies
LEARN ABOUT DEBIAN
bsqlodbc
bsqlodbc(1) FreeTDS Utilities bsqlodbc(1)NAME
bsqlodbc - batch SQL script processor using ODBC
SYNOPSIS
bsqlodbc [-U username] [-P password] [-S server] [-D database]
[-i input_file] [-o output_file] [-e error_file]
[-t field_term] [-qv]
DESCRIPTION
bsqlodbc is a utility program distributed with FreeTDS.
bsqlodbc is a non-interactive equivalent of the "isql" utility programs distributed by Sybase and Microsoft. Like them, bsqlodbc uses the
command "go" on a line by itself as a separator between batches. The last batch need not be followed by "go".
bsqlodbc makes use of the ODBC API provided by FreeTDS. This API is of course also available to application developers.
OPTIONS -U username
Database server login name.
-P password
Database server password.
-S server
Database server to which to connect.
-D database
Database to use.
-i input_file
Name of script file, containing SQL.
-o output_file
Name of output file, holding result data.
-e error_file
Name of file for errors.
-t field_term
Specifies the field terminator. Default is two spaces (' '). Recognized escape sequences are tab (' '), carriage return ('
'),
newline ('
'), and backslash ('\').
-h Print column headers with the data to the same file.
-q Do not print column metadata, return status, or rowcount. Overrides -h.
-v Verbose mode, for more information about the ODBC interaction. This also reports the result set metadata, including and return
code. All verbose data are written to standard error (or -e), so as not to interfere with the data stream.
NOTES
bsqlodbc is a filter; it reads from standard input, writes to standard output, and writes errors to standard error. The -i, -o, and -e
options override these, of course.
EXIT STATUS
bsqlodbc exits 0 on success, and >0 if the server cannot process the query.
HISTORY
bsqlodbc first appeared in FreeTDS 0.65.
AUTHORS
The bsqlodbc utility was written by James K. Lowden <jklowden@freetds.org>
doc 13 November 2011 bsqlodbc(1)