05-02-2008
Formatting output
Hi
I checked with printf
and it is formatting but did;t not completely..
var1="CTCT 0001000Y"
I have the blank between CTCT and 0001000Y
It is giving the output like the below
CTCT 0001000Y $
The space is extended between CTCT and 0001000Y.
Is there any option that i need to choose for this
Regards
Dhana
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
Have the following code(1) producing the results(2 & 3).
Would like to know if there is a way to format the two reports created in a similar fashion.
IE - The first is formatted nicely as a result of the echo "$xmpbdate $xavgs" >> $xmpbrpt
However when I attempt to do the same on... (7 Replies)
Discussion started by: Cameron
7 Replies
2. Shell Programming and Scripting
Hi need some advice..
#grep -i hostname test.csv
(gives the below output)
HOSTNAME,name,host_test,,,,,,,,
Now I need to format the above output as below.
HOSTNAME:
name=host_test
Any easy way of doing this using awk or sed or printf? (4 Replies)
Discussion started by: balaji_prk
4 Replies
3. Shell Programming and Scripting
Ok, for a fun project, my goal is to replicate the style of "catalog" on an old apple ]
*A 002 SOMEAPPLESOFTFILE
B 004 SOMEFILE
T 006 SOMETEXT
I 002 SOMEINTEGERFILE
The first character is either " " or "*" depending on if the file is locked or not.
Next is the filetype, so in... (1 Reply)
Discussion started by: patrick99e99
1 Replies
4. Shell Programming and Scripting
I am using find and ls to search for "warez" files on my server.
find /home/ -regex ".*\.\(avi\|mp3\|mpeg\|mpg\|iso\)" -print0 | xargs -0 ls -oh
This command produces this:
-rw-r--r-- 1 1000 3.2M Feb 18 2009 /home/user/public_html/lupus.mp3
I want to only get this
3.2M... (4 Replies)
Discussion started by: bonrad
4 Replies
5. Shell Programming and Scripting
Sorry for being a n00b, but I'm having a lot more trouble than I should with formatting the output to the program I finally completed. I'm basically looking for the linux equivalent to setw( ) from c++ so that I can print things in columns like this (but without the underlines lol):
MISSPELLED: ... (4 Replies)
Discussion started by: aikaterinimak
4 Replies
6. Shell Programming and Scripting
Hi Experts,
I have to create a report for certain audit and my output looks as follows
I m trying to format my output to look like
Any inputs would be highly appreciated
Thanks
Syed (5 Replies)
Discussion started by: maverick_here
5 Replies
7. Shell Programming and Scripting
Hi Guys
I need help removing some lines from output i am receiving from a shell script.
Here is the output:
http://i52.tinypic.com/10z0fut.png
I am trying to remove the output that i have circled.
. ${EDW}/extracts/bin/extracts_setup2.sh
. ${EDW}/extracts/extracts.conf
... (7 Replies)
Discussion started by: mooey1232003
7 Replies
8. Shell Programming and Scripting
Hi,
I have a file which contents entries in this form.
Only in /data4/temp abc.000001
Only in /data4/temp abc.000003
Only in /data4/temp abc.000012
Only in /data4/temp abc.000120
Only in /data4/temp abc.000133
Only in /data4/temp abc.001444
i want to read line by line and format... (2 Replies)
Discussion started by: arijitsaha
2 Replies
9. AIX
I am using FORTRAN 90 on AIX 5.3 and need to output my data to a tab-delimited file. It must have actual tabs, and I cannot figure out a way to make it work. The resulting file will be imported into another application (quickbooks) as an .iif file....for some reason, it needs the tabs; spaces do... (2 Replies)
Discussion started by: KathyB148
2 Replies
10. Shell Programming and Scripting
Hi,
I am trying to use printf command and format certain output in a specific format as under:
While the left side (upto |) of the above format is part of a fixed header function, the right side is where i am expecting data to be printed. However, as seen, Row1 value is reflecting on last... (5 Replies)
Discussion started by: EmbedUX
5 Replies
LEARN ABOUT PHP
mysqli_stmt.bind_param
MYSQLI_STMT.BIND_PARAM(3) 1 MYSQLI_STMT.BIND_PARAM(3)
mysqli_stmt::bind_param - Binds variables to a prepared statement as parameters
Object oriented style
SYNOPSIS
bool mysqli_stmt::bind_param (string $types, mixed &$var1, [mixed &$...])
DESCRIPTION
Procedural style
bool mysqli_stmt_bind_param (mysqli_stmt $stmt, string $types, mixed &$var1, [mixed &$...])
Bind variables for the parameter markers in the SQL statement that was passed to mysqli_prepare(3).
Note
If data size of a variable exceeds max. allowed packet size (max_allowed_packet), you have to specify b in $types and use
mysqli_stmt_send_long_data(3) to send the data in packets.
Note
Care must be taken when using mysqli_stmt_bind_param(3) in conjunction with call_user_func_array(3). Note that
mysqli_stmt_bind_param(3) requires parameters to be passed by reference, whereas call_user_func_array(3) can accept as a parameter a
list of variables that can represent references or values.
PARAMETERS
o $
stmt -Procedural style only: A statement identifier returned by mysqli_stmt_init(3).
o $types
- A string that contains one or more characters which specify the types for the corresponding bind variables:
Type specification chars
+----------+---------------------------------------------------+
|Character | |
| | |
| | Description |
| | |
+----------+---------------------------------------------------+
| i | |
| | |
| | corresponding variable has type integer |
| | |
| d | |
| | |
| | corresponding variable has type double |
| | |
| s | |
| | |
| | corresponding variable has type string |
| | |
| b | |
| | |
| | corresponding variable is a blob and will be sent |
| | in packets |
| | |
+----------+---------------------------------------------------+
o $var1
- The number of variables and length of string $types must match the parameters in the statement.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Object oriented style
<?php
$mysqli = new mysqli('localhost', 'my_user', 'my_password', 'world');
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
$stmt = $mysqli->prepare("INSERT INTO CountryLanguage VALUES (?, ?, ?, ?)");
$stmt->bind_param('sssd', $code, $language, $official, $percent);
$code = 'DEU';
$language = 'Bavarian';
$official = "F";
$percent = 11.2;
/* execute prepared statement */
$stmt->execute();
printf("%d Row inserted.
", $stmt->affected_rows);
/* close statement and connection */
$stmt->close();
/* Clean up table CountryLanguage */
$mysqli->query("DELETE FROM CountryLanguage WHERE Language='Bavarian'");
printf("%d Row deleted.
", $mysqli->affected_rows);
/* close connection */
$mysqli->close();
?>
Example #2
Procedural style
<?php
$link = mysqli_connect('localhost', 'my_user', 'my_password', 'world');
/* check connection */
if (!$link) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
$stmt = mysqli_prepare($link, "INSERT INTO CountryLanguage VALUES (?, ?, ?, ?)");
mysqli_stmt_bind_param($stmt, 'sssd', $code, $language, $official, $percent);
$code = 'DEU';
$language = 'Bavarian';
$official = "F";
$percent = 11.2;
/* execute prepared statement */
mysqli_stmt_execute($stmt);
printf("%d Row inserted.
", mysqli_stmt_affected_rows($stmt));
/* close statement and connection */
mysqli_stmt_close($stmt);
/* Clean up table CountryLanguage */
mysqli_query($link, "DELETE FROM CountryLanguage WHERE Language='Bavarian'");
printf("%d Row deleted.
", mysqli_affected_rows($link));
/* close connection */
mysqli_close($link);
?>
The above examples will output:
1 Row inserted.
1 Row deleted.
SEE ALSO
mysqli_stmt_bind_result(3), mysqli_stmt_execute(3), mysqli_stmt_fetch(3), mysqli_prepare(3), mysqli_stmt_send_long_data(3),
mysqli_stmt_errno(3), mysqli_stmt_error(3).
PHP Documentation Group MYSQLI_STMT.BIND_PARAM(3)