08-24-2009
Numbering the rows
If I a list of components, is there anyway to number (like automatically have: 1,2,3,...) the rows of my data?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
:confused: How does UNIX handle the numbering of processes? (2 Replies)
Discussion started by: tweety111
2 Replies
2. UNIX for Dummies Questions & Answers
Just a shot question...
how to make 1,2,3,...999
into the form of
001,002,003....999
(3 digits)
Thanks.... (9 Replies)
Discussion started by: biglemon
9 Replies
3. Shell Programming and Scripting
I'm trying to do a script that will look for a log file if it is already there change the name to another name.
I.E
if log.0 is there
rename to log.1
rename log.1 to log.2
rename log.2 to log.3 and so on.
Only thing is I got no idea where or what is the best command to use for this? ... (3 Replies)
Discussion started by: merlin
3 Replies
4. UNIX for Advanced & Expert Users
hello i'm trying to figure out how to number a blank line. For instance this :
sed '/./=' file | sed '/./N; s/\n/ /'
gives me
1 aaaa
2 bbbbbb
4 cccccc
5 ffkkkfff
6 ffsdfdfs
I would like something like this:
1 aaaaa
2
3 bbbbbb
4
5 cccccc
And so... (6 Replies)
Discussion started by: wisher115
6 Replies
5. Shell Programming and Scripting
Hello everyone,
I want get numbered lines from a file. and i can do it with: sed = file.txt | sed "/./N; s/\n/ /" | sed -n "5,7p"
but the output that i get is something similar to:
5 line5
6 line6
7 line7
and i want something like this (with 2points after the number):
5:... (6 Replies)
Discussion started by: vibra
6 Replies
6. Shell Programming and Scripting
Hi,
I have this large file and sometimes there are duplicates and I want to basically find them and figure how many there are.
So I have a file with multiple columns and the last column (9) has the duplicates.
eg.
yan
tar
tar
man
ban
tan
tub
tub
tub
Basically what I want to... (6 Replies)
Discussion started by: kylle345
6 Replies
7. Shell Programming and Scripting
Hi,
All I need to do is number a file.
The file looks like this
>
JJJJJJJJJJJJJJJJJJJJJ
>
JKJKJKKKKKKJJJ
>
MMMMYKKKJKKK
what I want to do is number it so that theres a numerical value beside the >.
>1
JJJJJJJJJJJJJJJJJJJJJ
>2
JKJKJKKKKKKJJJ (2 Replies)
Discussion started by: kylle345
2 Replies
8. UNIX for Dummies Questions & Answers
if we execute :set nu in vi mode, it displays the line numbers. so how to make this permanently in a file.
Whenever i execute cat , the line numbers should be there. please help me.
thanks (4 Replies)
Discussion started by: pandeesh
4 Replies
9. Shell Programming and Scripting
Would it be possible for a script to duplicate a file and incrementally number it?
File in: XXX_007_0580_xxxx_v0016.aep
File out: XXX_007_0580_xxxx_v0017.aep
If someone knows of a way I'd love to see it.
Thanks! (7 Replies)
Discussion started by: scribling
7 Replies
10. Shell Programming and Scripting
I'm not really sure how to explain this but I will try. In the attached file if $4=$4 and $5="-" then the last record is 1 and the one above that is 2, etc...
However, $4=$4 and $5="-" then the first record is 1 and the one below that is 2, etc...
"-" example:
chr10 90694830 90695123... (7 Replies)
Discussion started by: cmccabe
7 Replies
LEARN ABOUT PHP
ifx_affected_rows
IFX_AFFECTED_ROWS(3) 1 IFX_AFFECTED_ROWS(3)
ifx_affected_rows - Get number of rows affected by a query
SYNOPSIS
int ifx_affected_rows (resource $result_id)
DESCRIPTION
Returns the number of rows affected by a query associated with $result_id.
For inserts, updates and deletes the number is the real number (sqlerrd[2]) of affected rows. For selects it is an estimate (sqlerrd[0]).
Don't rely on it. The database server can never return the actual number of rows that will be returned by a SELECT because it has not even
begun fetching them at this stage (just after the "PREPARE" when the optimizer has determined the query plan).
Useful after ifx_prepare(3) to limit queries to reasonable result sets.
PARAMETERS
o $result_id
- A valid result id returned by ifx_query(3) or ifx_prepare(3).
RETURN VALUES
Returns the number of rows as an integer.
EXAMPLES
Example #1
Informix affected rows
<?php
$rid = ifx_prepare("select * from emp
where name like " . $name, $connid);
if (! $rid) {
/* ... error ... */
}
$rowcount = ifx_affected_rows($rid);
if ($rowcount > 1000) {
printf ("Too many rows in result set (%d)
<br />", $rowcount);
die ("Please restrict your query<br />
");
}
?>
SEE ALSO
ifx_num_rows(3).
PHP Documentation Group IFX_AFFECTED_ROWS(3)