Hi, I have two files.
File1:
File1 contains two fixed width columns ID of 15 characters length and Name is of 100 characters length.
ID Name
1-43<<11 spaces>>Swapna<<94 spaces>>
1-234<<10 spaces>>Mani<<96 spaces>>
1-3456<<9 spaces>>Kapil<<95 spaces>>
File2:
... (4 Replies)
Hi, all.
I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file:
10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783
19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657
And this is the expected... (2 Replies)
Hi, Iam new to unix. I have one input file .
Input file :
ID1~Name1~Place1
ID2~Name2~Place2
ID3~Name3~Place3
I need output such that only first column should change to fixed width column of 15 characters of length.
Output File:
ID1<<12 spaces>>Name1~Place1
ID2<<12... (5 Replies)
Hi,
How to output the duplicate record to another file. We say the record is duplicate based on a column whose position is from 2 and its length is 11 characters.
The file is a fixed width file.
ex of Record:
DTYU12333567opert tjhi kkklTRG9012
The data in bold is the key on which... (1 Reply)
Hi,
I have a fixed width text file without any header row. One of the columns contains a date in YYYYMMDD format.
If the original file contains 3 dates, I want my shell script to split the file into 3 small files with data for each date.
I am a newbie and need help doing this. (14 Replies)
Hi Guys
I am checking the treads to get the answer but i am not able to get the answer for my question.
I have two files. First file is a pattern file and the second file is the file i want to search in it. Output will be the lines from file2.
File1:
P2797f12af 44751228... (10 Replies)
I have a fixed width file of length 53. when is try to get the lengh of the record of that file i get 2 different answers.
awk '{print length;exit}' <File_name>
The above code gives me length 50.
wc -L <File_name>
The above code gives me length 53.
Please clarify on... (2 Replies)
I have a fixed with file with header & trailer length having the same length of the detail record file.
The details record length of this file is 24, for Header and Trailer the records will be padded with spaces to match the record length of the file
Currently I am adding 3 spaces in header... (14 Replies)
hi,
i have a fixed width file with multiple columns and need to print data using awk command.
i use: awk -F "|" '($5 == BH) {print $1,$2,$3}' <non_AIM target>.txt for a delimiter file.
but now i have a fixed width file like below:
7518 8269511BH 20141224951050N8262
11148 8269511BH... (5 Replies)
Discussion started by: kcdg859
5 Replies
LEARN ABOUT PHP
mysqli_fetch_field_direct
MYSQLI_FETCH_FIELD_DIRECT(3) 1 MYSQLI_FETCH_FIELD_DIRECT(3)mysqli_result::fetch_field_direct - Fetch meta-data for a single field
Object oriented style
SYNOPSIS
object mysqli_result::fetch_field_direct (int $fieldnr)
DESCRIPTION
Procedural style
object mysqli_fetch_field_direct (mysqli_result $result, int $fieldnr)
Returns an object which contains field definition information from the specified 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).
o $fieldnr
- The field number. This value must be in the range from 0 to number of fields - 1.
RETURN VALUES
Returns an object which contains field definition information or FALSE if no field information for specified fieldnr is available.
Object attributes
+-----------+---------------------------------------------------+
|Attribute | |
| | |
| | Description |
| | |
+-----------+---------------------------------------------------+
| name | |
| | |
| | The name of the column |
| | |
| orgname | |
| | |
| | Original column name if an alias was specified |
| | |
| table | |
| | |
| | The name of the table this field belongs to (if |
| | not calculated) |
| | |
| orgtable | |
| | |
| | Original table name if an alias was specified |
| | |
| def | |
| | |
| | The default value for this field, represented as |
| | a string |
| | |
|max_length | |
| | |
| | The maximum width of the field for the result |
| | set. |
| | |
| length | |
| | |
| | The width of the field, as specified in the table |
| | definition. |
| | |
|charsetnr | |
| | |
| | The character set number for the field. |
| | |
| flags | |
| | |
| | An integer representing the bit-flags for the |
| | field. |
| | |
| type | |
| | |
| | The data type used for this field |
| | |
| decimals | |
| | |
| | The number of decimals used (for numeric fields) |
| | |
+-----------+---------------------------------------------------+
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 Name, SurfaceArea from Country ORDER BY Name LIMIT 5";
if ($result = $mysqli->query($query)) {
/* Get field information for column 'SurfaceArea' */
$finfo = $result->fetch_field_direct(1);
printf("Name: %s
", $finfo->name);
printf("Table: %s
", $finfo->table);
printf("max. Len: %d
", $finfo->max_length);
printf("Flags: %d
", $finfo->flags);
printf("Type: %d
", $finfo->type);
$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 Name, SurfaceArea from Country ORDER BY Name LIMIT 5";
if ($result = mysqli_query($link, $query)) {
/* Get field information for column 'SurfaceArea' */
$finfo = mysqli_fetch_field_direct($result, 1);
printf("Name: %s
", $finfo->name);
printf("Table: %s
", $finfo->table);
printf("max. Len: %d
", $finfo->max_length);
printf("Flags: %d
", $finfo->flags);
printf("Type: %d
", $finfo->type);
mysqli_free_result($result);
}
/* close connection */
mysqli_close($link);
?>
The above examples will output:
Name: SurfaceArea
Table: Country
max. Len: 10
Flags: 32769
Type: 4
SEE ALSO mysqli_num_fields(3), mysqli_fetch_field(3), mysqli_fetch_fields(3).
PHP Documentation Group MYSQLI_FETCH_FIELD_DIRECT(3)