12-08-2012
Sorry, there were some mistakes,
Scrutinizer scripts is absolutely fine..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am trying to cut the first 10 characters from a file only if the file has 'xyz' in field 185-188.
I tried this
cat filename | cut -c1-10
but this gives me all the records regardless of what is in field 185-188.
Is this doable ?
Thanks in advance for responses. (2 Replies)
Discussion started by: jxh461
2 Replies
2. UNIX for Dummies Questions & Answers
Hi gurus,
I have set of files in a directory
ex : test_file1.csv
test_file2.csv
test_file3.csv
my requirement is to copy these files into another directory but with date appended to the name :
like after copying the files should look like : test_file1_07072008.csv
... (7 Replies)
Discussion started by: sish78
7 Replies
3. Shell Programming and Scripting
Hi,
The file contains 1000 of rows can you please let me know
How to copy 1-10 and 30-40 rows from one file to another.
thanks
:) (3 Replies)
Discussion started by: ravi214u
3 Replies
4. Shell Programming and Scripting
Hi Guys,
I need help in modifying a large text file containing more than 1-2 lakh rows of data using unix commands. I am quite new to the unix language
the text file contains data in a pipe delimited format
sdfsdfs
sdfsdfsd
START_ROW
sdfsd|sdfsdfsd|sdfsdfasdf|sdfsadf|sdfasdf... (9 Replies)
Discussion started by: manish2009
9 Replies
5. Shell Programming and Scripting
hye there...
i have a problem to copy file in specific folder
that will change the name according to
host,time(%m%s) and date(%Y%M%D)
example folder name:
host_20100531.154101801
this folder name will always change...
but i just want to copy the AAA.txt and BBB.txt file..
really need... (17 Replies)
Discussion started by: annetote
17 Replies
6. UNIX for Dummies Questions & Answers
I know this is a complicated question but I will try to illustrate it with some data. I have a data file that looks like the following:
1341 NA06985 0 0 2 46.6432798439
1341 NA06991 NA06993 NA06985 2 48.8478948517
1341 NA06993 0 0 1 45.8022601455
1340 NA06994 0 0 1 48.780669145
1340... (1 Reply)
Discussion started by: evelibertine
1 Replies
7. UNIX for Dummies Questions & Answers
How do I go about deleting specific rows from a text file (given row number)? (5 Replies)
Discussion started by: evelibertine
5 Replies
8. Shell Programming and Scripting
Hi everyone,
I will appreciate a lot if anyone can help me about a simple issue.
I have a data file, and I need to remove some rows with a given condition.
So here is a part of my data file:
5,14,1,3,3,0,0,-0.29977188269E+01
5,16,1,4,4,0,0,0.30394279900E+02... (4 Replies)
Discussion started by: hayreter
4 Replies
9. Shell Programming and Scripting
Gents
Can you help please.
Input file
5490921425 1 7 1310342 54909214251
5490921425 2 1 1 54909214252
5491120937 1 1 3 54911209371
5491120937 3 1 1 54911209373
5491320785 1 ... (4 Replies)
Discussion started by: jiam912
4 Replies
10. UNIX for Beginners Questions & Answers
Hi ALL,
I have two file. I need to combine these two file based on a layout.
I used the below code and able to extract the record. But now able to insert that to a 3'rd file in between the extract
FILE 1
CAID NUMBER 1-20
TID NUMBER 21-22
LABEL CHAR 23-44
BASE 45-60... (5 Replies)
Discussion started by: arunkumar_mca
5 Replies
LEARN ABOUT PHP
sqlsrv_has_rows
SQLSRV_HAS_ROWS(3) SQLSRV_HAS_ROWS(3)
sqlsrv_has_rows - Indicates whether the specified statement has rows
SYNOPSIS
bool sqlsrv_has_rows (resource $stmt)
DESCRIPTION
Indicates whether the specified statement has rows.
PARAMETERS
o $stmt
- A statement resource returned by sqlsrv_query(3) or sqlsrv_execute(3).
RETURN VALUES
Returns TRUE if the specified statement has rows and FALSE if the statement does not have rows or if an error occurred.
EXAMPLES
Example #1
sqlsrv_has_rows(3) example
<?php
$server = "serverNamesqlexpress";
$connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password" )
$conn = sqlsrv_connect( $server, $connectionInfo );
$stmt = sqlsrv_query( $conn, "SELECT * FROM Table_1");
if ($stmt) {
$rows = sqlsrv_has_rows( $stmt );
if ($rows === true)
echo "There are rows. <br />";
else
echo "There are no rows. <br />";
}
?>
SEE ALSO
sqlsrv_num_rows(3), sqlsrv_query(3).
PHP Documentation Group SQLSRV_HAS_ROWS(3)