05-29-2008
Help with arranging data file
Dears,
I have the below data,
sss-aaaaaa
111211 222222 33333 22222 1163111
sss-vvvvvv
111311 224522 335633 24322 111511
sss-cccccc
111221 224522 333333 24322 111511
sss-dddddd
111211 222222 33333 22345222 113111
I want to make them like
sss-aaaaaa 111211 222222 33333 22222 1163111
sss-vvvvvv 111311 224522 335633 24322 111511
sss-cccccc 111221 224522 333333 24322 111511
sss-dddddd 111211 222222 33333 22345222 113111
Best Regards
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi Gurus,
I have a text file that I want to process with the following structure;
4528788 Blah - Something
9341423 Text - Somethinghere
98792223,5546761 Some - More - Text
5119503,5159504,1234567 Text - More - Text
13459695 Stuff - Text Again
13526583 Junk - More Text Here
13595177... (1 Reply)
Discussion started by: th3g0bl1n
1 Replies
2. Shell Programming and Scripting
Hi all,
This is program to identify and arrange programs(scripts) based on their she-bang values to a folder with the same name.
The parts of mkdir and copy and creating problems.I also doubt the use of hash...maybe some problems in it.
Please help out debugging this.
Code pasted at:
Paste... (2 Replies)
Discussion started by: Vivek788
2 Replies
3. Shell Programming and Scripting
hi,
my input file is containg uid, eriMaster ,eriResign, ericontry, dept.
some of the uid are not having all info.
out put should include all info irrespctive of datas of input file
if any one data is missing, then it has to print Null or zero..then continue with the existing one.
here... (0 Replies)
Discussion started by: hegdeshashi
0 Replies
4. Shell Programming and Scripting
Hello Guys,
I have around 100 hosts setup as alias in my profile for easy sshing.
alias ada='ssh -Y username@da.domain.com'
alias ast='ssh -Y username@terix.domain.com'
alias bb1='ssh -X username@ggserver.ns.domain.com'
.
.
.
.
I now would like to use sshmenu software in which... (4 Replies)
Discussion started by: upengan78
4 Replies
5. UNIX for Dummies Questions & Answers
I have thousand lines of data...:
A 1
B 2
C 3
D 4
E 5
A 21
B 22
C 23
D 24
E 25
A 31
B 32
C 33
D 34
E 35
...........
ON AND AND ON (3 Replies)
Discussion started by: bobo
3 Replies
6. Shell Programming and Scripting
Hello All,
Please find attached input and output files. I want to write a shell script to achieve this. I tried using awk but not getting how to do this as I am new to shell programming.
Thanks (4 Replies)
Discussion started by: Sudeep Bhattad
4 Replies
7. UNIX for Dummies Questions & Answers
Hi,
Please give a solution...
Current File
200101701 A 5 B 283 D 222
200085506 A 5 B 6 C 304
200081406 A 5
200101784 D 1111Desired Output
200101701 A 0005 B 0283 * * D 222 ... (4 Replies)
Discussion started by: satyar
4 Replies
8. Shell Programming and Scripting
I have a file with user activity and need to display only the start and end timestamp of the activity. I don't know how can we write an logic for this please help me in a bettr way to work on it
User Activity_log
-----------------------------------
... (5 Replies)
Discussion started by: lazydev
5 Replies
9. UNIX for Beginners Questions & Answers
By using this code how can we get the stars in inverted positions?
str="*"
for i in 1 2 3 4 5
do
echo "$str"
str="$str *"
done
The output should be like this
* * * * *
* * * *
* * *
* *
*
Please use CODE tags as required by forum rules!... (5 Replies)
Discussion started by: Meeran Rizvi
5 Replies
10. Shell Programming and Scripting
Hi,
I have file which contains data based on tags. Output of the file should be in order of tags.
Below are the files :
Tags.txt
f12
f13
f23
f45
f56
Original data is like this :
Data.txt
2017/01/04|09:07:00:021|R|XYZ|38|9|1234|f12=CAT|f23=APPLE|f45=PENCIL|f13=CAR... (5 Replies)
Discussion started by: Prathmesh
5 Replies
LEARN ABOUT PHP
maxdb_stmt_execute
MAXDB_STMT_EXECUTE(3) 1 MAXDB_STMT_EXECUTE(3)
maxdb_stmt_execute - Executes a prepared Query
Procedural style
SYNOPSIS
bool maxdb_stmt_execute (resource $stmt)
DESCRIPTION
Object oriented style
bool maxdb_stmt::execute (void )
The maxdb_stmt_execute(3) function executes a query that has been previously prepared using the maxdb_prepare(3) function represented by
the $stmt resource. When executed any parameter markers which exist will automatically be replaced with the appropiate data.
If the statement is UPDATE, DELETE, or INSERT, the total number of affected rows can be determined by using the
maxdb_stmt_affected_rows(3) function. Likewise, if the query yields a result set the maxdb_fetch(3) function is used.
Note
When using maxdb_stmt_execute(3), the maxdb_fetch(3) function must be used to fetch the data prior to preforming any additional
queries.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Object oriented style
<?php
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
$maxdb->query("CREATE TABLE temp.mycity LIKE hotel.city");
/* Prepare an insert statement */
$query = "INSERT INTO temp.mycity (zip, name, state) VALUES (?,?,?)";
$stmt = $maxdb->prepare($query);
$stmt->bind_param("sss", $val1, $val2, $val3);
$val1 = '11111';
$val2 = 'Georgetown';
$val3 = 'NY';
/* Execute the statement */
$stmt->execute();
$val1 = '22222';
$val2 = 'Hubbatown';
$val3 = 'CA';
/* Execute the statement */
$stmt->execute();
/* close statement */
$stmt->close();
/* retrieve all rows from myCity */
$query = "SELECT zip, name, state FROM temp.mycity";
if ($result = $maxdb->query($query)) {
while ($row = $result->fetch_row()) {
printf("%s (%s,%s)
", $row[0], $row[1], $row[2]);
}
/* free result set */
$result->close();
}
/* remove table */
$maxdb->query("DROP TABLE temp.mycity");
/* close connection */
$maxdb->close();
?>
Example #2
Procedural style
<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
maxdb_query($link, "CREATE TABLE temp.mycity LIKE hotel.city");
/* Prepare an insert statement */
$query = "INSERT INTO temp.mycity (zip, name, state) VALUES (?,?,?)";
$stmt = maxdb_prepare($link, $query);
maxdb_stmt_bind_param($stmt, "sss", $val1, $val2, $val3);
$val1 = '11111';
$val2 = 'Georgetown';
$val3 = 'NY';
/* Execute the statement */
maxdb_stmt_execute($stmt);
$val1 = '22222';
$val2 = 'Hubbatown';
$val3 = 'CA';
/* Execute the statement */
maxdb_stmt_execute($stmt);
/* close statement */
maxdb_stmt_close($stmt);
/* retrieve all rows from myCity */
$query = "SELECT zip, name, state FROM temp.mycity";
if ($result = maxdb_query($link, $query)) {
while ($row = maxdb_fetch_row($result)) {
printf("%s (%s,%s)
", $row[0], $row[1], $row[2]);
}
/* free result set */
maxdb_free_result($result);
}
/* remove table */
maxdb_query($link, "DROP TABLE temp.mycity");
/* close connection */
maxdb_close($link);
?>
The above example will output something similar to:
11111 (Georgetown,NY)
22222 (Hubbatown,CA)
SEE ALSO
maxdb_prepare(3), maxdb_stmt_bind_param(3).
PHP Documentation Group MAXDB_STMT_EXECUTE(3)