08-09-2012
in x i am storing the name of file for particular row and y is nothing only used to make $1 value null.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
The below is the content of the file.
008.03.50.21|ID4|0015a3f01cf3
008.04.20.16|ID3|0015a3f02337
008.04.20.17|ID4_1xVoice|00131180d80e
008.04.20.03|ID3_1xVoice|0015a3694125
008.04.30.05|ID3_1xVoice|0015a3f038af
008.06.30.17|ID3_1xVoice|00159660d454... (2 Replies)
Discussion started by: ravi_rn
2 Replies
2. UNIX for Advanced & Expert Users
Hello all -
I am to this forum and fairly new in learning unix and finding some difficulty in preparing a small shell script. I am trying to make script to sort all the files given by user as input (either the exact full name of the file or say the files matching the criteria like all files... (3 Replies)
Discussion started by: pankaj80
3 Replies
3. Shell Programming and Scripting
cat file1.txt
field1 "user1":
field2:"data-cde"
field3:"data-pqr"
field4:"data-mno"
field1 "user1":
field2:"data-dcb"
field3:"data-mxz"
field4:"data-zul"
field1 "user2":
field2:"data-cqz"
field3:"data-xoq"
field4:"data-pos"
Now i need to have the date like below.
i have just... (7 Replies)
Discussion started by: ckaramsetty
7 Replies
4. Shell Programming and Scripting
hI
I have file A
NSU30504 5 6 G 6
NSU3050B T 7 9 J
NSU30506 T I 8 9
NSU3050C H J K L Output:
NSU3050B T 7 9 J
NSU3050C H J K L
NSU30504 5 6 G 6
NSU30506 T I 8 9Video tutorial on how to use code tags in The UNIX and Linux Forums. (13 Replies)
Discussion started by: pareshkp
13 Replies
5. Shell Programming and Scripting
Hi Guys,
B07 U51C A1 44 B1 44 Yes
B07 L64U A2 44 B1 44 Yes
B07 L62U A2 44 B1 44 Yes
B07 L11C A4 32 B1 44 NO
B05 L12Z A1 12 B1 44 NO
B01 651Z A2 44 B1 44 NO
B04 A51Z A2 12 B1 44 NO
L07 B08D A4 12 B1 44 NO
B07 RU8D A4 44 B1 44 Yes
B07 L58D A4 15 B1 44 No
B07 LA8D A4 44 B1 44 Yes
B07... (6 Replies)
Discussion started by: asavaliya
6 Replies
6. Shell Programming and Scripting
I have a text file that has the following column data:
0.007
0.005
0.004
0.007
How do i output the total sum of the data above? (6 Replies)
Discussion started by: alegnagrp
6 Replies
7. Shell Programming and Scripting
Hi,
I have a data like
Input:
12||34|56|78
Output:
XYZ|12||34|56|78
I tried like this , but it puts it on another line
awk -F "|" ' BEGIN {"XYZ"} {print $0} 'file
Any quick suggessitons in sed/awk ? am using HP-UX (3 Replies)
Discussion started by: selvankj
3 Replies
8. Shell Programming and Scripting
Hi guys,
I need to append new data at the end of each line of the files. This new data is based on substring (3rd fields) of last column.
Input file xxx.csv:
U1234|1-5X|orange|1-5X|Act|1-5X|0.1 /sac/orange 12345 0
U5678|1-7X|grape|1-7X|Act|1-7X|0.1 /sac/grape 5678 0... (5 Replies)
Discussion started by: null7
5 Replies
9. Shell Programming and Scripting
Input File
Contig_1_294435nt 242231 242751
Contig_1_294435nt 242390 242782
Contig_1_294435nt 242390 242782
Contig_1_294435nt 291578 291668
Contig_2_242278nt 75910 76271
Contig_2_242278nt 76036 76316
Contig_2_242278nt 76036 76316... (2 Replies)
Discussion started by: perl_beginner
2 Replies
10. Shell Programming and Scripting
Hi guys,
I have problem to append new data at the end of each line of the files where it takes whole value of the nth column. My expected result i just want to take a specific value only. This new data is based on substring of 11th, 12th 13th column that has comma seperated value.
My code:
awk... (4 Replies)
Discussion started by: null7
4 Replies
LEARN ABOUT PHP
msql_fetch_array
MSQL_FETCH_ARRAY(3) MSQL_FETCH_ARRAY(3)
msql_fetch_array - Fetch row as array
SYNOPSIS
array msql_fetch_array (resource $result, [int $result_type])
DESCRIPTION
msql_fetch_array(3) is an extended version of msql_fetch_row(3). In addition to storing the data in the numeric indices of the result
array, it also stores the data in associative indices, using the field names as keys.
An important thing to note is that using msql_fetch_array(3) is NOT significantly slower than using msql_fetch_row(3), while it provides a
significant added value.
PARAMETERS
o $
result -The result resource that is being evaluated. This result comes from a call to msql_query(3).
o $result_type
- A constant that can take the following values: MSQL_ASSOC, MSQL_NUM, and MSQL_BOTH with MSQL_BOTH being the default.
RETURN VALUES
Returns an array that corresponds to the fetched row, or FALSE if there are no more rows.
EXAMPLES
Example #1
msql_fetch_array(3) example
<?php
$con = msql_connect();
if (!$con) {
die('Server connection problem: ' . msql_error());
}
if (!msql_select_db('test', $con)) {
die('Database connection problem: ' . msql_error());
}
$result = msql_query('SELECT id, name FROM people', $con);
if (!$result) {
die('Query execution problem: ' . msql_error());
}
while ($row = msql_fetch_array($result, MSQL_ASSOC)) {
echo $row['id'] . ': ' . $row['name'] . "
";
}
msql_free_result($result);
?>
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.0.4 | |
| | |
| | A bug was fixed when retrieving data from col- |
| | umns containing NULL values. Such columns were |
| | not placed into the resulting array. |
| | |
+--------+---------------------------------------------------+
SEE ALSO
msql_fetch_row(3), msql_fetch_object(3), msql_data_seek(3), msql_result(3).
PHP Documentation Group MSQL_FETCH_ARRAY(3)