Hi
I want to convert multiple rows ro single row ,I have tried with below one but I am not getting what I am expecting.Please any idea
a.txt
conn1=stg
conn2=dev
path=\xxx\a1.txt
fre=a
conn1=stg
conn2=dev
path=\xxx\a2.txt
freq=a
awk '/a/{ORS=" "}{print}END{print "\n"}'... (5 Replies)
Hi all I have a file as below :
Development
System
User
Production
i want to convert the file to below format:
"Development","System","User","Production"
Is it possible with UNIX ? if so can you please give me some direction on it ?
Thanks,
Satya
Use code tags please, ty. (10 Replies)
Hello all
I have data like
1
2
3
4
5
I wish my output would be like
1,2,3,4,5
For this i have executed
'BEGIN {FS="\n"; ORS=","} {print $0}' test
and got the output as
1,2,3,4,5,
I do not want to have , at the end of 5. output should be like (5 Replies)
i am having 2 text files
111|rama
222|krishna
333|jaya
and
111|22|43
222|66|42
i want to combine these two text files,the output should be as follows
111|rama|22|43
222|krishna|66|42
333|jaya||
pls help
Please use code tags when posting data and code samples! (4 Replies)
Hi Friends,
I have a single column data like below.
1
2
3
4
5
I need the output like below.
0
1
2
3
4
where each row (including first row) subtracting from first row and the result should print below like the way shown in output file.
Thanks
Sid (11 Replies)
Comparing two files on row by row
File1
ecount~100
dcount~200
ccount~300
zxcscount~5000
and so on.
File2
ecount~100
dcount~203
ccount~300
zxcscount~5000
and so on.
If i use diff command (1 Reply)
Hi All,
I have a file in windows when I transfer it using sftp it is getting as single line. I tried to do both ascii and binary
File:
is transfered as
Can you please let me know how can do the transfer as same as XML file
Thanks,
Arun (1 Reply)
Hello ,
Can anyone please help me to solve the below -
Input.txt
source table abc
col1 char
col2 number
source table bcd
col1 date
col2 char
output should be 2 files based on the row separator "source table"
abc.txt
col1 char (6 Replies)
Hi ALL,
We have requirement in a file, i have multiple rows.
Example below:
Input file rows
01,1,102319,0,0,70,26,U,1,331,000000113200000011920000001212
01,1,102319,0,1,80,20,U,1,241,00000059420000006021
I need my output file should be as mentioned below. Last field should split for... (4 Replies)
Hi,
How could Find files with 1 single row in unix
I need delete files with 1 single row (8 Replies)
Discussion started by: Marlboro
8 Replies
LEARN ABOUT PHP
fbsql_data_seek
FBSQL_DATA_SEEK(3) 1 FBSQL_DATA_SEEK(3)fbsql_data_seek - Move internal result pointerSYNOPSIS
bool fbsql_data_seek (resource $result, int $row_number)
DESCRIPTION
Moves the internal row pointer of the FrontBase result associated with the specified result identifier to point to the specified row num-
ber.
The next call to fbsql_fetch_row(3) would return that row.
PARAMETERS
o $
result -A result identifier returned by fbsql_query(3) or fbsql_db_query(3).
o $row_number
- The row number. Starts at 0.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
fbsql_data_seek(3) example
<?php
$link = fbsql_pconnect("localhost", "_SYSTEM", "secret")
or die("Could not connect");
fbsql_select_db("samp_db")
or die("Could not select database");
$query = "SELECT last_name, first_name FROM friends;";
$result = fbsql_query($query)
or die("Query failed");
// fetch rows in reverse order
for ($i = fbsql_num_rows($result) - 1; $i >=0; $i--) {
if (!fbsql_data_seek($result, $i)) {
printf("Cannot seek to row %d
", $i);
continue;
}
if (!($row = fbsql_fetch_object($result)))
continue;
echo $row->last_name . $row->first_name . "<br />
";
}
fbsql_free_result($result);
?>
PHP Documentation Group FBSQL_DATA_SEEK(3)