I have a function
awkvarrep() {
awk -F'|' '$1~/$1/{printf "%-10s %-30s %-15s %-30s %-15s\n", $2,$3,$4,$5,$6}' testfile
}
I'm calling it by this
VARREP=XYZ
awkvarrep $VARREP
since i'm passing $VARREP to the awkvarrep() function I want to use this with $1 but it dosen't seem to be... (5 Replies)
I have an xml file with following tags
<NewTag>value123</xyz>
<NewTag>value321</abcd>
I have to replace the values in between the tags with some value ( VAL1/VAL2)
but the thing the ending tag can be any thing, for this i need a awk command
currently i am using this but it... (5 Replies)
Hey all, Im trying to write a script on windows, which Im not too familiar with. Im generally a bash scripting guy but am using perl for this case.
My question is...
I have this exact output:
2 Dir(s) 6,380,429,312 bytes free
and I just need to get the number out... (4 Replies)
Hi I'm a newbie in unix and I'm having trouble in creating a script. I want to search for a pattern '_good' and insert new lines that contains '_bad', '_med', '_fail' while also ensure that the line contains _good is removed
here some of the data
UPDATE SCHOOL SET GRADE =... (1 Reply)
Hi all,
I need help in replacing awk with sed for the below.
1 ) cat list | awk -F" |," '/MATH/ {sub(/]*/,"",$3); print $3}'
Eg: file : list
Sno Subno Name
1 SUB1 ENG
2 SUB2 MATH
2)
Eg:result
Total No of Students: 2
Sno ID Sub
------------------
1 ... (3 Replies)
Hello everyone,
I have a problem with awk replacement... I need to replace "|\n" for "\n"
I tried thisawk '{ sub(/\|\\n/, "\\n"); print }'
but it seems like it doesn't work properly. Can anyone help with that? (4 Replies)
I been trying to figure out how to use element of array as a replacement pattern. This works as I expected:
$ echo "one two three" | awk '{
gsub(/wo/,"_BEG_&_END_",$2);
print }'
one t_BEG_wo_END_ three
$ echo "one two three" | awk '{
tmp="foo";
gsub(/wo/,"_BEG_" tmp "_END_",$2);... (5 Replies)
Hi!
(I'm just a newbie in awk & bash scripts) I have a script which replaces one column from an input file with a specified one from the same file. The input and the desired output files are shown below.
~ cat input.file
random text
Fe 1.33 23.23 3.33
C 21.03 23.23 3.33
Cu 0.00 ... (2 Replies)
Hi guys,
I worked for almost a half-day for the replacement of some text automatically with script. But no success.
The problem is I have hundred of files, which need to be replaced with some new text. It's a painful work to work manually and it's so easy to do it wrong.
For example,
I... (2 Replies)
Hi,
I have a big text file with similar data as below and need the text as in output
using awk or sed. any help is greatly appreciated.
Input:
City=Chicago Elden street
>>> reservedBy = business 1
>>> reservedBy = business 2
>>> reservedBy = business 3
City=Dallas Elm street
>>>... (5 Replies)
Discussion started by: tech_frk
5 Replies
LEARN ABOUT PHP
maxdb_stmt_errno
MAXDB_STMT_ERRNO(3) 1 MAXDB_STMT_ERRNO(3)maxdb_stmt_errno - Returns the error code for the most recent statement call
Procedural style
SYNOPSIS
int maxdb_stmt_errno (resource $stmt)
DESCRIPTION
Object oriented style
int$maxdb_stmt->errno ()
For the statement specified by stmt, maxdb_stmt_errno(3) returns the error code for the most recently invoked statement function that can
succeed or fail.
Note
For possible error codes see documentation of SQLDBC: http://maxdb.sap.com/documentation/.
RETURN VALUES
An error code value. Zero means no error occurred.
EXAMPLES
Example #1
Object oriented style
<?php
/* Open a connection */
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
$maxdb->query("CREATE TABLE temp.mycity LIKE hotel.city");
$maxdb->query("INSERT INTO temp.mycity SELECT * FROM hotel.city");
$query = "SELECT name, zip FROM temp.mycity ORDER BY name";
if ($stmt = $maxdb->prepare($query)) {
/* drop table */
$maxdb->query("DROP TABLE temp.mycity");
/* execute query */
$stmt->execute();
printf("Error: %d.
", $stmt->errno);
/* close statement */
$stmt->close();
}
/* close connection */
$maxdb->close();
?>
Example #2
Procedural style
<?php
/* Open a connection */
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
maxdb_query($link, "CREATE TABLE temp.mycity LIKE hotel.city");
maxdb_query($link, "INSERT INTO temp.mycity SELECT * FROM hotel.city");
$query = "SELECT name, zip FROM temp.mycity ORDER BY name";
if ($stmt = maxdb_prepare($link, $query)) {
/* drop table */
maxdb_query($link, "DROP TABLE temp.mycity");
/* execute query */
maxdb_stmt_execute($stmt);
printf("Error: %d.
", maxdb_stmt_errno($stmt));
/* close statement */
maxdb_stmt_close($stmt);
}
/* close connection */
maxdb_close($link);
?>
The above example will output something similar to:
Warning: maxdb_stmt_execute(): -4004POS(23) Unknown table name:MYCITY [42000] <...>
Error: -4004.
SEE ALSO maxdb_stmt_error(3), maxdb_stmt_sqlstate(3).
PHP Documentation Group MAXDB_STMT_ERRNO(3)