11-03-2008
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
guys,
I'm trying to 9k lines of the following:
aaa aaa 1 1 1
to
aaa aaa 1 01 1
Im pretty ignorant when it comes to subtituting fields using awk
any help ?
Tony (1 Reply)
Discussion started by: tony3101
1 Replies
2. Shell Programming and Scripting
i have a file with some records seperated by pipe. I am getting unwanted "|" in the 7th field and i want to remove any pipes in the
7th field only. Can somebody help out? Here is the sample record.
460625192|432559595|MANU... (3 Replies)
Discussion started by: dsravan
3 Replies
3. Shell Programming and Scripting
I have a file to load in the table, and am using SQLLDR
CONTROL FILE
-----------------------
LOAD DATA
INFILE 'sample.txt'
APPEND
INTO TABLE TEMP_LOAD
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(FIELD1,FIELD2,FIELD3)
Now i have about 10,000 lines in the file
FIELD1 in the table is... (1 Reply)
Discussion started by: prash184u
1 Replies
4. Linux
Because some program i have installed can not upload files bigger than some size as printing, the base got a packet bigger than 'max_allowed_packet' bytes what that i need to do as written in the documentation of the program increase the value of a fileld called LimitRequestBody told that is in... (5 Replies)
Discussion started by: tal
5 Replies
5. UNIX for Dummies Questions & Answers
Hi all,
I want to edit nth filed of a comma delimited line with some value. Can I use sed command to do this.
Pls suggest me the command here.
Thanks,
Poova. (2 Replies)
Discussion started by: poova
2 Replies
6. Shell Programming and Scripting
hi
i have record looks like below
1,US
I want to add empty field to the record as below
1, , , ,US
how i can do it using awk ?
i tried with awk its not working
awk '{ print $1", ,"$2 }' filename > file 1 (2 Replies)
Discussion started by: raghavendra.cse
2 Replies
7. Shell Programming and Scripting
Hi All,
i have a file having multiple lines but mainly constitues of following two types
1) Sat,Oct,1,01:04:51,2011,Local,ESSBASE0,Info(1051037),Logging,out,user,210073155,,,active,for,63,minutes,GETS_SAL,loaded
2)... (2 Replies)
Discussion started by: dev.devil.1983
2 Replies
8. Shell Programming and Scripting
I try to trim a FTP log using awk, but the escape sequences does not work the way I want it.
Input data Wed 3Oct10 21:48:00 - (002117) Sent file d:\ftp\home\tools\htmake.rar successfully (48.2 kB/sec - 40997 Bytes)
Wed 3Oct10 22:25:46 - (002118) Sent file d:\ftp\files\main\oct\camera1... (4 Replies)
Discussion started by: Jotne
4 Replies
9. UNIX for Beginners Questions & Answers
Dear Team,
I need support to use awk program to grep data based on matching pattern first 5 digits "96656" .
Data I have as below
466565996656,820012906026651 NA NOTMATCHED
4661740045165,820011902196656 NA NOTMATCHED
4661740085225,820011900196656 NA NOTMATCHED... (4 Replies)
Discussion started by: shanul karim
4 Replies
LEARN ABOUT PHP
mysqli_fetch_lengths
MYSQLI_FETCH_LENGTHS(3) 1 MYSQLI_FETCH_LENGTHS(3)
mysqli_result::$lengths - Returns the lengths of the columns of the current row in the result set
Object oriented style
SYNOPSIS
array$mysqli_result->lengths ()
DESCRIPTION
Procedural style
array mysqli_fetch_lengths (mysqli_result $result)
The mysqli_fetch_lengths(3) function returns an array containing the lengths of every column of the current row within the result set.
PARAMETERS
o $
result -Procedural style only: A result set identifier returned by mysqli_query(3), mysqli_store_result(3) or
mysqli_use_result(3).
RETURN VALUES
An array of integers representing the size of each column (not including any terminating null characters). FALSE if an error occurred.
mysqli_fetch_lengths(3) is valid only for the current row of the result set. It returns FALSE if you call it before calling
mysqli_fetch_row/array/object or after retrieving all rows in the result.
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();
}
$query = "SELECT * from Country ORDER BY Code LIMIT 1";
if ($result = $mysqli->query($query)) {
$row = $result->fetch_row();
/* display column lengths */
foreach ($result->lengths as $i => $val) {
printf("Field %2d has Length %2d
", $i+1, $val);
}
$result->close();
}
/* close connection */
$mysqli->close();
?>
Example #2
Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
$query = "SELECT * from Country ORDER BY Code LIMIT 1";
if ($result = mysqli_query($link, $query)) {
$row = mysqli_fetch_row($result);
/* display column lengths */
foreach (mysqli_fetch_lengths($result) as $i => $val) {
printf("Field %2d has Length %2d
", $i+1, $val);
}
mysqli_free_result($result);
}
/* close connection */
mysqli_close($link);
?>
The above examples will output:
Field 1 has Length 3
Field 2 has Length 5
Field 3 has Length 13
Field 4 has Length 9
Field 5 has Length 6
Field 6 has Length 1
Field 7 has Length 6
Field 8 has Length 4
Field 9 has Length 6
Field 10 has Length 6
Field 11 has Length 5
Field 12 has Length 44
Field 13 has Length 7
Field 14 has Length 3
Field 15 has Length 2
PHP Documentation Group MYSQLI_FETCH_LENGTHS(3)