Hi ,
I have a file (a.txt ) with data :
17
18
19
I wants to make file which will have data as :
17,18,19
Can anyone please suggest me the way or any code snippet.
Thanks in advance.
Regards,
VJ (8 Replies)
A very naive question... I have a file which has many rows and many columns and I would like to chop off the rows and create a new file per row named after the first column of every row + 1. The data files look like:
# Donades de la trajectoria de la particula 60001
# 1:T 2:Massa 3:Rx 4:Ry 5:Rz... (7 Replies)
Hi,
I am a beginner in bash&perl.
I have data in form of:-
A 1
B 2
C 3
D 4
E 5
I would like your help to find a simple way to change it to :-
A B C D E
1 2 3 4 5
Any help would be highly appreciated. (8 Replies)
Hello. very new to shell scripting and would like to know if anyone could help me.
I have data thats being pulled into a txt file and currently have to manually transpose the data which is taking a long time to do.
here is what the data looks like.
Server1 -- Date -- Other -- value... (7 Replies)
I can no longer find my commands, but I use to be able to transpose data with common fields from a single column to rows using a command line. My data is separated as follows:
NAME=BOB
ADDRESS=COLORADO
PET=CAT
NAME=SUSAN
ADDRESS=TEXAS
PET=BIRD
NAME=TOM
ADDRESS=UTAH
PET=DOG
I would... (7 Replies)
Hi I have below requirement, need help
One file contains the meta data information and other file would have the data, match the column from file1 and with file2 and extract corresponding column value and display in another file
File1:
CUSTTYPECD
COSTCENTER
FNAME
LNAME
SERVICELVL
... (1 Reply)
Hello Everyone,
I have a input file looks like
-0.005-0.004-0.003-0.002-0.00100.0010.0020.0030.0040.005My desired output should look like
-0.005
-0.004
-0.003
-0.002
-0.001
0
0.001
0.002
0.003
0.004
0.005I had some success in getting the desired output. But i face a problem when i... (15 Replies)
I have data such as below where the value in second field is the same as that in the row after.
123456,22222,John,0,xyz
234567,22222,John1,1,cde
43212,3333,Jean,3,pip
84324,3333,Abel,2,cat
I'd like to rearrange the output like below to put such records beside each other and separated with... (5 Replies)
Discussion started by: james2009
5 Replies
LEARN ABOUT PHP
sqlite_num_rows
SQLITE_NUM_ROWS(3)SQLITE_NUM_ROWS(3)sqlite_num_rows - Returns the number of rows in a buffered result setSYNOPSIS
int sqlite_num_rows (resource $result)
DESCRIPTION
Object oriented style (method):
int SQLiteResult::numRows (void )
Returns the number of rows in the buffered $result set.
PARAMETERS
o $result
- The SQLite result resource. This parameter is not required when using the object-oriented method.
Note
This function cannot be used with unbuffered result handles.
RETURN VALUES
Returns the number of rows, as an integer.
EXAMPLES
Example #1
Procedural example
<?php
$db = sqlite_open('mysqlitedb');
$result = sqlite_query($db, "SELECT * FROM mytable WHERE name='John Doe'");
$rows = sqlite_num_rows($result);
echo "Number of rows: $rows";
?>
Example #2
Object-oriented example
<?php
$db = new SQLiteDatabase('mysqlitedb');
$result = $db->query("SELECT * FROM mytable WHERE name='John Doe'");
$rows = $result->numRows();
echo "Number of rows: $rows";
?>
SEE ALSO sqlite_changes(3), sqlite_query(3), sqlite_num_fields(3).
PHP Documentation Group SQLITE_NUM_ROWS(3)