01-08-2014
Thank you very much for the quick reply. I will give it a try and will get back to you.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hello everyone..
I was wondering is there a effective way to sort file that contains colomns and numeric one.
file
218900012192 8938929 8B8DF3664 1E7E2D59D5 0000 26538 1234 74024415
218900012979 8938929 8B8DF3664 1E7E2D59D5 0000 26538 1234 74024415
218900012992 8938929 8B8DF3664... (2 Replies)
Discussion started by: amon
2 Replies
2. UNIX for Dummies Questions & Answers
I don't really know much about UNIX commands, so if someone could help me understand how to do this, I'd really appreciate it.
I have a text file with data that looks like this (filename: numbers.txt):
1 1 1 1 1 1 1 1 1 2 1 1_2 2_1
1 1 1 1 1 1 1 1 2 1 2 1_2 2_1
1 1 1 1 1 1 1 1 2 1 2 1_2 2_1... (12 Replies)
Discussion started by: zac100
12 Replies
3. Shell Programming and Scripting
Hi Guys,
I have two files that I am using:
File1 is as follows:
wwe
khfgv
jfo
jhgfd
hoaha
hao
lkahe
This is like a master file which has entries in the order which I want. (4 Replies)
Discussion started by: npatwardhan
4 Replies
4. UNIX for Dummies Questions & Answers
Good morning. I have a piece of code that is currently taking multiple files and using the CAT.exe command to combine into one file that is then sorted in reverse order based on the 3rd field of the file, then displayed on screen. I am trying to change this so that the files are being combined into... (4 Replies)
Discussion started by: jaacmmason
4 Replies
5. Shell Programming and Scripting
Hello,
I need some sort of way to extract every date contained in a file, and count how many of those dates there are.
Here are the specifics:
The date format I'm looking for is mm/dd/yyyy
I only need to look after line 45 in the file (that's where the data begins)
The columns of... (2 Replies)
Discussion started by: ronan1219
2 Replies
6. Shell Programming and Scripting
Hi,
I have a matrix like this:
Algorithm predicted_gene start_point end_point
A x 65 85
B x 70 80
C x 75 85
D x 10 20
B y 125 130
C y 120 140
D y 200 210
Here there are four tab-separated columns. The first column is the used algorithm for prediction, and there are 4 of them A-D.... (8 Replies)
Discussion started by: flyfisherman
8 Replies
7. Linux
cat sample.csv
ID,Name,no
1,AAA,1
2,BBB,1
3,AAA,1
4,BBB,1
cut -d',' -f2 sample.csv | sort | uniq
this gives only the 2nd column values
Name
AAA
BBB
How to I get all the columns of CSV along with this? (1 Reply)
Discussion started by: sanvel
1 Replies
8. Shell Programming and Scripting
Hi ,
i have a belwo script which is used to get sectors per track value extarcted from Solaris machine:
for DISK in /dev/dsk/c*t*d*s*; do value=`prtvtoc "$DISK" | sed -n -e '/Dimensions/,/Flags/{/Dimensions/d; /Flags/d; p; }' | sed -n -e '/sectors\/track/p'`; if ; then echo... (4 Replies)
Discussion started by: omkar.jadhav
4 Replies
9. Shell Programming and Scripting
I am trying to sort, do uniq by 1st column and report this 4 columns tab delimiter table , eg
chr10:112174128 rs2255141 2E-10 Cholesterol, total
chr10:112174128 rs2255141 7E-16 LDL
chr10:17218291 rs10904908 3E-11 HDL Cholesterol
chr10:17218291 rs970548 8E-9 TG... (4 Replies)
Discussion started by: fat
4 Replies
10. UNIX for Beginners Questions & Answers
For some reason I am having difficulty performing what should be a fairly easy task. I would like to print lines of a file that have a unique value in the first field. For example, I have a large data-set with the following excerpt:
PS003,001 MZMWR/ L-DWD// *
PS003,001... (4 Replies)
Discussion started by: jvoot
4 Replies
LEARN ABOUT PHP
mysql_fetch_field
MYSQL_FETCH_FIELD(3) 1 MYSQL_FETCH_FIELD(3)
mysql_fetch_field - Get column information from a result and return as an object
SYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
omysqli_fetch_field(3)
o PDOStatement::getColumnMeta
object mysql_fetch_field (resource $result, [int $field_offset])
DESCRIPTION
Returns an object containing field information. This function can be used to obtain information about fields in the provided query result.
o $
result -The result resource that is being evaluated. This result comes from a call to mysql_query(3).
o $field_offset
- The numerical field offset. If the field offset is not specified, the next field that was not yet retrieved by this function is
retrieved. The $field_offset starts at 0.
Returns an object containing field information. The properties of the object are:
o name - column name
o table - name of the table the column belongs to, which is the alias name if one is defined
o max_length - maximum length of the column
o not_null - 1 if the column cannot be
NULL
o primary_key - 1 if the column is a primary key
o unique_key - 1 if the column is a unique key
o multiple_key - 1 if the column is a non-unique key
o numeric - 1 if the column is numeric
o blob - 1 if the column is a BLOB
o type - the type of the column
o unsigned - 1 if the column is unsigned
o zerofill - 1 if the column is zero-filled
Example #1
mysql_fetch_field(3) example
<?php
$conn = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$conn) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db('database');
$result = mysql_query('select * from table');
if (!$result) {
die('Query failed: ' . mysql_error());
}
/* get column metadata */
$i = 0;
while ($i < mysql_num_fields($result)) {
echo "Information for column $i:<br />
";
$meta = mysql_fetch_field($result, $i);
if (!$meta) {
echo "No information available<br />
";
}
echo "<pre>
blob: $meta->blob
max_length: $meta->max_length
multiple_key: $meta->multiple_key
name: $meta->name
not_null: $meta->not_null
numeric: $meta->numeric
primary_key: $meta->primary_key
table: $meta->table
type: $meta->type
unique_key: $meta->unique_key
unsigned: $meta->unsigned
zerofill: $meta->zerofill
</pre>";
$i++;
}
mysql_free_result($result);
?>
Note
Field names returned by this function are case-sensitive.
Note
If field or tablenames are aliased in the SQL query the aliased name will be returned. The original name can be retrieved for
instance by using mysqli_result::fetch_field.
mysql_field_seek(3).
PHP Documentation Group MYSQL_FETCH_FIELD(3)