05-23-2013
This code is working only with first row. The second row remains the same. I want to replace the () and | in the 10th column in all the rows. i.e.
the data in the second row also should look like,
Quote:
chr1 602567 rs21953190 A G 5481.77 . 152 59.09 SYNONYMOUS_CODING LOW SILENT gaT/gaC D1034 ADNP2 protein_coding CODING ENSCAFT00000000008 5 GT:ADP:GQ:PL 1/1:0,151:151:99:5510,430,0
Last edited by mehar; 05-23-2013 at 09:56 AM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a file, a.asc which is generated from a shell script:
-----BEGIN PGP MESSAGE-----
Version: PGP 6.5.8
qANQR1DBwE4DR5PN6zVjZTcQA/9z5Eg94cwYdTnC7v+JUegQuJwHripqnyjFrEs/ejzKYCNmngbHHmf8V4K3uFkYyp74aFf+CdymA030RKs6ewOwkmqRW19oIXCgVe8Qmfg+/2KTq8XN
=0QSP
-----END PGP MESSAGE-----
I want... (12 Replies)
Discussion started by: nattynatty
12 Replies
2. Shell Programming and Scripting
Hi all,
I want to write a shell which would allow me to edit a text file or a xml file.
Basically i want to add a new node in a existing xml file. The values for this new node are based on user input.
Thanks in advance
Zing (9 Replies)
Discussion started by: zing
9 Replies
3. Shell Programming and Scripting
Given a text file, how do you add a line of text after a specific line number? I believe I would want to use "sed" but I am unsure of the syntax. Thank you.
Mike (5 Replies)
Discussion started by: msb65
5 Replies
4. Shell Programming and Scripting
Dear Friends,
I am beginner in Perl and trying to find the problem in a script. Kindly help me to modify the script. My script is not giving the output for the last field and followed text (LA: Language English). Input file & script as follows:
Input file:
Thu Mar 19 2:34:14 EDT 2009
STC... (3 Replies)
Discussion started by: srsahu75
3 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I would like to remove any lines from a text file that begin with #, or that are blank. How can I do that with BASH?
Mike (3 Replies)
Discussion started by: msb65
3 Replies
6. Shell Programming and Scripting
Hi,
I have a text file which is following format -
COL VAL
ABC 1
ABC 2
ABC 3
ABC 4
ABC 5
My requirement is to search for a particular value (provided by user) in the file and comment the previous entries including that as well.
E.g. If I search for number 3, then the output... (6 Replies)
Discussion started by: bhupinder08
6 Replies
7. Shell Programming and Scripting
Hi All the Helpers!
I have a text file which looks like input.txt.I would request to please suggest me how can I make this file look like output.txt
input.txt
VOP 111 0 1 2
DEM 111 0 222 333 444 555
879 888 987 888 989
VOP 118 0... (2 Replies)
Discussion started by: Indra2011
2 Replies
8. Shell Programming and Scripting
Hi everyone,
I want to know, if there is a way to modify one line in a text file with unix script, with out re-writing all the file.
For example, i have this file:
CONFIGURATION_1=XXXX
CONFIGURATION_2=YYYY
CONFIGURATION_3=ZZZZ
supose i have a command or function "modify" that... (7 Replies)
Discussion started by: Xedrox
7 Replies
9. Shell Programming and Scripting
Hello all,
I have some text files I need to do the following on:
Delete banner page (lines 1-56) --I am doing this using sed
Remove ^M --I am doing this using vi
Remove trailer page --this can vary based on the contents of the file, it usually starts with ***************************
I am... (5 Replies)
Discussion started by: jeffs42885
5 Replies
10. UNIX for Beginners Questions & Answers
Looking for help,
i have input file like below and want to modify to expected output, if can without create additional file, hope can direct modify it.
have 2 thing need do.
1st
is adding a word (testplan generation off) after ! ! IPG: Tue Aug 07 14:31:17 2018
2nd
is adding... (16 Replies)
Discussion started by: kttan
16 Replies
LEARN ABOUT PHP
mssql_fetch_row
MSSQL_FETCH_ROW(3) MSSQL_FETCH_ROW(3)
mssql_fetch_row - Get row as enumerated array
SYNOPSIS
array mssql_fetch_row (resource $result)
DESCRIPTION
mssql_fetch_row(3) fetches one row of data from the result associated with the specified result identifier. The row is returned as an
array. Each result column is stored in an array offset, starting at offset 0.
Subsequent call to mssql_fetch_row(3) would return the next row in the result set, or FALSE if there are no more rows.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
RETURN VALUES
Returns an array that corresponds to the fetched row, or FALSE if there are no more rows.
EXAMPLES
Example #1
mssql_fetch_row(3) example
<?php
// Connect to MSSQL and select the database
$link = mssql_connect('MANGOSQLEXPRESS', 'sa', 'phpfi');
mssql_select_db('php', $link);
// Query to execute
$query = mssql_query('SELECT [id], [quote] FROM [quotes] WHERE [id] = '42'', $link);
// Did the query fail?
if (!$query) {
die('MSSQL error: ' . mssql_get_last_message());
}
// Fetch the row
$row = mssql_fetch_row($query);
// Print the 'quote'
echo 'Quote #' . $row[0] . ': "' . $row[1] . '"';
?>
The above example will output something similar to:
Quote #42: "The answer to everything..."
NOTES
Note
This function sets NULL fields to the PHP NULL value.
SEE ALSO
mssql_fetch_array(3), mssql_fetch_object(3), mssql_data_seek(3), mssql_result(3).
PHP Documentation Group MSSQL_FETCH_ROW(3)