10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
I am joining two CSV files based on 'Server_Name' column, 1st column of first file and 2nd column of second file.
If matches, output 1st and 2nd column from first file, 3rd,4th,5th,6th columns from second file.
I am expecting output CSV file as below.
Could you please send me help me with... (6 Replies)
Discussion started by: Anadmbt
6 Replies
2. Shell Programming and Scripting
I have a workaround to the problem i m posting, however if someone wants to look at my query and respond ... i will appreciate.
This is in reference to this thread -> https://www.unix.com/shell-programming-and-scripting/267630-extract-between-two-exact-matched-strings.html
I have data.txt as... (11 Replies)
Discussion started by: mohtashims
11 Replies
3. UNIX for Beginners Questions & Answers
Hi,
Below is list of files in my directory.
-rw-rw-r--. 1 Roots Roots 0 Dec 26 06:58 12345_kms_report.csv
-rw-rw-r--. 1 Roots Roots 0 Dec 26 06:59 12346_kms_report.csv
-rw-rw-r--. 1 Roots Roots 0 Dec 26 06:59 12347_kms_report.csv
-rw-rw-r--. 1 Roots Roots 0 Dec 26 06:59... (2 Replies)
Discussion started by: Balraj
2 Replies
4. Shell Programming and Scripting
cat clinvar_00-latest.vcf | perl -aF/\\t/ -lne '/CLNSRCID=(\d+)/ and print join("\t",@F,$1)' > OMIM.txt
The above code finds the text CLNSRCID=, but only outputs those records in which there is a numerical value only.
For example, the first match is CLNSRCID=103320.0001 in line 4 of the... (1 Reply)
Discussion started by: cmccabe
1 Replies
5. UNIX Desktop Questions & Answers
Hello,
I would like to ask you, how to match directory names. I need to find only directories, which are created only from numbers and doesn't include any letters.
I used command
find $AC_WORKDIR/work_archive/test/$dirs_years -maxdepth 1 -name \\* -print
If I have dirs like
12... (3 Replies)
Discussion started by: satin1321
3 Replies
6. Shell Programming and Scripting
hi I juts want to know if there is a command that checks if an ethernet port corresponds to a network card.
ex. I have 3 network cards, one is two ports, and the other two 8 ports.
How do I know that eth0 corresponds to the the two-port network card and eth9 corresponds to the first 8-port... (2 Replies)
Discussion started by: h0ujun
2 Replies
7. Shell Programming and Scripting
I am debugging a script and have stuck up at one code line
awk -F , '{if (match($3,001)) { print $2 } }' Master20120307090511.tmp
The Master20120307090511.tmp is
001,ARE , 001
002,ARE , 002
003,ARE , 003
006,ARE , 006
011,ARE , 011
012,ARE , 012
What happens is when i fire this ... (5 Replies)
Discussion started by: vee_789
5 Replies
8. Shell Programming and Scripting
i am matching two files.
the files are in the format
file_1.txt
1|_|X|_|
2|_|W|_|
3|_|Y|_|
4|_|Z|_|
5|_|U|_|
file_2.txt
W|_|A|_|
Z|_|C|_|
V|_|B|_|
X|_|D|_|sdff|_|
Y|_|
file_3.txt should be in the format (4 Replies)
Discussion started by: centurion_13
4 Replies
9. Shell Programming and Scripting
Hello,
I would like to write a sed comman dwith pattern matching .to match those record which have some character(userd id) present in it.
Example :
Logfile contents --
127.0.0.1 - - "POST /cgi-bin/cgi-module-example.pl HTTP/1.1" 200 1866
127.0.0.1 - - "POST... (4 Replies)
Discussion started by: jambesh
4 Replies
10. Shell Programming and Scripting
hi,
how can i make use of a command in the replacement segment..
cat a | sed '/^*]\{3\}$/{
s/\(.*\)/REPLACEMENT/g
}'
suppose if I want to use a awk command in the replacement section , how to achieve that ?
Thanks (1 Reply)
Discussion started by: AbhishekG
1 Replies
SPI_CURSOR_OPEN_WITH_PARAMLIST(3) PostgreSQL 9.2.7 Documentation SPI_CURSOR_OPEN_WITH_PARAMLIST(3)
NAME
SPI_cursor_open_with_paramlist - set up a cursor using parameters
SYNOPSIS
Portal SPI_cursor_open_with_paramlist(const char *name,
SPIPlanPtr plan,
ParamListInfo params,
bool read_only)
DESCRIPTION
SPI_cursor_open_with_paramlist sets up a cursor (internally, a portal) that will execute a statement prepared by SPI_prepare. This function
is equivalent to SPI_cursor_open except that information about the parameter values to be passed to the query is presented differently. The
ParamListInfo representation can be convenient for passing down values that are already available in that format. It also supports use of
dynamic parameter sets via hook functions specified in ParamListInfo.
The passed-in parameter data will be copied into the cursor's portal, so it can be freed while the cursor still exists.
ARGUMENTS
const char * name
name for portal, or NULL to let the system select a name
SPIPlanPtr plan
prepared statement (returned by SPI_prepare)
ParamListInfo params
data structure containing parameter types and values; NULL if none
bool read_only
true for read-only execution
RETURN VALUE
Pointer to portal containing the cursor. Note there is no error return convention; any error will be reported via elog.
PostgreSQL 9.2.7 2014-02-17 SPI_CURSOR_OPEN_WITH_PARAMLIST(3)