05-19-2009
after that many posts you have, you should know how to search the forum. this question is asked many times. at the search box, type ^M and you can see similar threads like this.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, I have a flat text file which contains blank line between each text line. Is there any command to get rid of it?
Thanks for your help (11 Replies)
Discussion started by: xfang
11 Replies
2. UNIX for Advanced & Expert Users
I have a file with one of the following lines, when opened with vi
33560010686GPT£120600GBPGBP10082007DS
In the above line, I want to get rid of the junk character before the £ (pound sysmbol).
When I tried copying £ from windows and copy in unix vi, it prints as £ and I tried pattern replace... (2 Replies)
Discussion started by: nskworld
2 Replies
3. Shell Programming and Scripting
A sed command works most of the time however it fails sometimes.
I put each line (record) I read of a file through the following command
data=$(cat file | sed 's///g' | sed 's|.*ex:Msg\(.*\)ex:Msg.*|\1|' )
When I run the script I get a message that states that there is an invalid format... (6 Replies)
Discussion started by: gugs
6 Replies
4. UNIX for Dummies Questions & Answers
Hi All,
Im selecting a large record from a table and putting it in a file in the unix box. The file has a hidden character "^[[D " present in it. Can any one help me in getting rid of the character
Thanks in advance, (4 Replies)
Discussion started by: madhan@29
4 Replies
5. Shell Programming and Scripting
Hi Unix Gurus,
I have a file with 100,000 lines with lines in the format:
1,35518,35518,1,2,1,72,1253889535,1253889775,240,30,152.163.141.8,US,0,00,-g 1253888723-g 1253889445
1,78973,78973,1,2,2,91,1253889535,1253889775,240,30,152.163.141.8,US,0,00,-g 1253888723-g 1253889445... (3 Replies)
Discussion started by: toms
3 Replies
6. Shell Programming and Scripting
Hi Guys,
I am creating a couple of temp. files in a script. After completing the script, I am using the rm command to delete these files. The files are getting deleted but I am getting "filename - cannot find file;no such file or directory" error in my bash shell terminal window.
I am using... (3 Replies)
Discussion started by: npatwardhan
3 Replies
7. Shell Programming and Scripting
I have a file that I ran the dos2unix utility on, it cleans up pretty well, but I noticed an occasional ^M leftover, (actual characters) these may or may not be strays from my original dos file. Either way, I want to get rid of the ^ and any character that may follow. ^M ^C or whatever.
How do I... (6 Replies)
Discussion started by: ajp7701
6 Replies
8. UNIX for Dummies Questions & Answers
When I use vi to see what's in the file I get this:
int add1(int x) {^M return x + 1;^M}
^Mint subtract1(int x) {^M return x - 1;^M}
^Mint double_it(int x) {^M return x * 2;^M}
^Mint halve_it(int x) {^Mreturn x / 2;^M}
^Mint main() {^M int myint;^M int result;^M ... (2 Replies)
Discussion started by: Nonito84
2 Replies
9. Red Hat
admin.campaign.sql
admin.cardnumber_filter.sql
understand that rename is using mv command but how do I rename such that it become the following:
campaign.sql
cardnumber_filter.sql
thanks (2 Replies)
Discussion started by: jediwannabe
2 Replies
10. Solaris
Hello,
CDE workspace.
How to get rid of annoying popping up file manager window which appears every time after logging in.
For example.any suggestions, I would be appreciate. (3 Replies)
Discussion started by: wolfgang
3 Replies
LEARN ABOUT PHP
ifx_fetch_row
IFX_FETCH_ROW(3) 1 IFX_FETCH_ROW(3)
ifx_fetch_row - Get row as an associative array
SYNOPSIS
array ifx_fetch_row (resource $result_id, [mixed $position])
DESCRIPTION
Fetches one row of data from the result associated with the specified result identifier.
Subsequent calls to ifx_fetch_row(3) would return the next row in the result set, or FALSE if there are no more rows.
PARAMETERS
o $result_id
-$result_id is a valid resultid returned by ifx_query(3) or ifx_prepare(3) (select type queries only!).
o $position
- An optional parameter for a "fetch" operation on "scroll" cursors: NEXT, PREVIOUS, CURRENT, FIRST, LAST or a number. If you
specify a number, an "absolute" row fetch is executed. This parameter is optional, and only valid for SCROLL cursors.
RETURN VALUES
Returns an associative array that corresponds to the fetched row, or FALSE if there are no more rows.
Blob columns are returned as integer blob id values for use in ifx_get_blob(3) unless you have used ifx_textasvarchar(1) or ifx_byteasvar-
char(1), in which case blobs are returned as string values.
EXAMPLES
Example #1
Informix fetch rows
<?php
$rid = ifx_prepare ("select * from emp where name like " . $name,
$connid, IFX_SCROLL);
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 />
");
}
if (! ifx_do ($rid)) {
/* ... error ... */
}
$row = ifx_fetch_row ($rid, "NEXT");
while (is_array($row)) {
for (reset($row); $fieldname=key($row); next($row)) {
$fieldvalue = $row[$fieldname];
printf ("%s = %s,", $fieldname, $fieldvalue);
}
printf("
<br />");
$row = ifx_fetch_row($rid, "NEXT");
}
ifx_free_result ($rid);
?>
PHP Documentation Group IFX_FETCH_ROW(3)