I'm a new member of the forum, I had this new generate file since I use 'grep' and 'awk', what I want to do is get rid off the all 0s before the numbers, is there any one who could help me to figure it out? Thanks a lot!
yun
0000000029 000q7472 2002/03/01
0000000030 000q7472 2002/03/01
... (2 Replies)
Hi everybody,
I have a certine file with lots of number,
Which I want to add a " in the begging and at the and of each line.
Could anyone tell me how can I do it?
Cheers (7 Replies)
I am posting a script below which essentially excutes the following functions in the described order.
1) From a source directory pools together three files generated by system logs for each user session, tar's these files and archives them as a log set in a destination directory and these... (0 Replies)
I have a directory name stored in a variable. Does anyone have a piece of code which checks if this stored directory name ends up with the "/" and if it is missing adds it to the same variable. for example I might have
A=/bb/data or A=/bb/data/
which needs to be A=/bb/data/ for sure
thanks... (5 Replies)
Hi all
Can anyone suggest me a good solution ? My requirement is as follows
I have a plain text file similar to this...
sending data to 0003345234
here is the output...
,..........
...........
.......
sending data to 00033452ab
here is the output...
,..........
...........
.... (5 Replies)
if input1 has an expression nouse covert allcolumns in to hashes except 6th column.
ex: abc100 has no use in 3rd row and 4th row and became hashes.
BUT if input1 1st column keys-1st row has no words in 3rd column (ex: def200 (key) and 1st row has no words in 3rd column (no x/x or y/y or others)... (2 Replies)
Hi,
I'm guessing this is probably relatively straight forward to do in awk, but I just can't get my head round it! I have a log file of the following format:
3:03:35 (lmgrd) TIMESTAMP 10/14/2011
3:20:41 (MLM) IN: "MATLAB" user1@host1.private.dns.zone
3:21:05 (MLM) IN: "MATLAB"... (2 Replies)
hello,
I have problem with writing/adjusting a shell script.
I searched forum and unfortunately couldn't write scipt based on the information I found.
I never wtire such so it's hard for me and I do need to modify one script immediately.
case looks like:
1. 'file' that needs to be modified... (3 Replies)
I have a list
XPAR
XPAR
XPAR ,
XPAR , ,
XPAR ,1,
XPAR 196
XPAR 95
XPAR 95,77
This has space and tabs on the second row. I would like it to look like
XPAR 1, 196, 95, 77
But I always get the below because of the spaces above.
, , ,1, 196 95 95,77
I use... (9 Replies)
Hi
Please check my code,here awk -vLIT="$line" '$0 ~ LIT { print LIT,"Found in ",FILENAME; }' $f it is not checking for small alphabets.can u pls modify my code
#!/bin/ksh
for f in /tmp/satemp/*
do
cat /tmp/sa/tt.txt| while read line
do
awk -vLIT="$line" '$0 ~ LIT { print LIT,"Found in... (3 Replies)
Discussion started by: coolboy98699
3 Replies
LEARN ABOUT PHP
mssql_field_seek
MSSQL_FIELD_SEEK(3)MSSQL_FIELD_SEEK(3)mssql_field_seek - Seeks to the specified field offsetSYNOPSIS
bool mssql_field_seek (resource $result, int $field_offset)
DESCRIPTION
Seeks to the specified field offset. If the next call to mssql_fetch_field(3) won't include a field offset, this field would be returned.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
o $field_offset
- The field offset, starts at 0.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Using mssql_field_seek(3) on the example for mssql_fetch_field(3)
<?php
// Connect to MSSQL and select the database
mssql_connect('MANGOSQLEXPRESS', 'sa', 'phpfi');
mssql_select_db('php');
// Send a select query to MSSQL
$query = mssql_query('SELECT * FROM [php].[dbo].[persons]');
// Construct table
echo '<h3>Table structure for 'persons'</h3>';
echo '<table border="1">';
// Table header
echo '<thead>';
echo '<tr>';
echo '<td>Field name</td>';
echo '<td>Data type</td>';
echo '<td>Max length</td>';
echo '</tr>';
echo '</thead>';
// Dump all fields
echo '<tbody>';
for ($i = 0; $i < mssql_num_fields($query); ++$i) {
// Fetch the field information, notice the
// field_offset parameter is not set. See
// the mssql_field_seek call below
$field = mssql_fetch_field($query);
// Print the row
echo '<tr>';
echo '<td>' . $field->name . '</td>';
echo '<td>' . strtoupper($field->type) . '</td>';
echo '<td>' . $field->max_length . '</td>';
echo '</tr>';
// Move the internal seek pointer to the next
// row in the result set
mssql_field_seek($query, $i + 1);
}
echo '</tbody>';
echo '</table>';
// Free the query result
mssql_free_result($query);
?>
SEE ALSO mssql_fetch_field(3).
PHP Documentation Group MSSQL_FIELD_SEEK(3)