10-29-2009
This worked perfectly. Thanks alot for your time.
One other quick question if I could. If I have to trim white space from a column, is there a way to do that with printf? I was able to do it by assigning the column to a variable and use gsub. Just wondering if there's a quicker way.
Thanks again.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I'm writing a script that at one point needs to check the contents of another script's log file to determine how to proceed. An example record from the log file is:
"mcref04152006","060417","ANTH0415","282","272","476,983.37","465,268.44","loaded"
I want my script to return this record if:
... (3 Replies)
Discussion started by: Glenn Arndt
3 Replies
2. Shell Programming and Scripting
I've got a multitude of text data files that carry exactly the same kind of data. Unfortunately some of them have a different filename format
some are: 'category'_'month'-'year'_act.txt
an example being: daf_Apr-1961_act.txt
and some are: 'category'_ 'year'-'month'_act.txt
an... (16 Replies)
Discussion started by: vrms
16 Replies
3. UNIX for Dummies Questions & Answers
I need to put together a RAID1 file server for use by Windoze systems. I've built zillions of windows systems from components. I was a HPUX SE for a long time at HP, but have been out of the game for years.
I've got an old workhorse mobo FIC PA-2013 with a 450 MHz K6 III+ I could use, but I'd... (2 Replies)
Discussion started by: pcmacd
2 Replies
4. Shell Programming and Scripting
Hi all, I have to transform a XML file like this:
<?xml version="1.0"?>
<vocabulary>
<voc_id>102</voc_id>
<name>Vocabulary Name</name>
<description>Voc description</description>
<relations>3</relations>
<hierarchy>5</hierarchy>
<word>
<word_id>1</word_id>
... (1 Reply)
Discussion started by: aLittleBeat
1 Replies
5. UNIX for Dummies Questions & Answers
I am having a file, around 500 lines. which contains one letter words, two letters words,...and so on(up to 15 letter words and words are not seprated by line). I need to compare all 1 letter words with 3,4,5 and 6 letters word, all 2 letters words with 2,3,4 and 5 letters words and all 3 letters... (3 Replies)
Discussion started by: akhay_ms
3 Replies
6. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
Write a template main.c file via shell script to make it easier for yourself later.
The issue here isn't writing... (2 Replies)
Discussion started by: george3isme
2 Replies
7. UNIX for Dummies Questions & Answers
Hi Gurus!
I need to make some file transformations. Please help.
This is my input file. It has four columns with fixed width.
1 aaa bbbb cccc
2 eee dddd jjjj
3 fff gggg jjjj
4 hhh iiii cccc
5 kkk llll cccc
6 mmm nnnn oooo
7 ppp qqqq xxxx
8 rrr ... (1 Reply)
Discussion started by: kokoro
1 Replies
8. Shell Programming and Scripting
Hi,
I am trying to populate an array with data from a text file. I have a working method using awk but it is too slow and inefficent. See below.
The text file has 70,000 lines. As awk is a line editor it reads each line of the file until it gets to the required line and then processes it.... (3 Replies)
Discussion started by: carlr
3 Replies
9. Shell Programming and Scripting
Hi,
I was hoping someone could suggest an alternative to code I currently have as mine takes up far too much processor time and it to slow.
The situation:
I have a programme that runs on some files just before they are zipped up and archived, the program appends a one line summary of the... (4 Replies)
Discussion started by: RECrerar
4 Replies
10. Shell Programming and Scripting
I have a list of files defined in a single file , one on each line.(No.of files may wary each time)
eg. content of ETL_LOOKUP.dat
/data/project/randomname
/data/project/ramname
/data/project/raname
/data/project/radomname
/data/project/raame
/data/project/andomname
size of these... (5 Replies)
Discussion started by: h0x0r21
5 Replies
LEARN ABOUT PHP
fbsql_result
FBSQL_RESULT(3) 1 FBSQL_RESULT(3)
fbsql_result - Get result data
SYNOPSIS
mixed fbsql_result (resource $result, [int $row], [mixed $field])
DESCRIPTION
Returns the contents of one cell from a FrontBase $result set.
When working on large result sets, you should consider using one of the functions that fetch an entire row (specified below). As these
functions return the contents of multiple cells in one function call, they're MUCH quicker than fbsql_result(3).
Calls to fbsql_result(3) should not be mixed with calls to other functions that deal with the result set.
PARAMETERS
o $
result -A result identifier returned by fbsql_query(3) or fbsql_db_query(3).
o $row
-
o $field
- Can be the field's offset, or the field's name, or the field's table dot field's name (tablename.fieldname). If the column name
has been aliased ('select foo as bar from...'), use the alias instead of the column name.
Note
Specifying a numeric offset for the field argument is much quicker than specifying a fieldname or tablename.fieldname argu-
ment.
RETURN VALUES
SEE ALSO
Recommended high-performance alternatives: fbsql_fetch_row(3), fbsql_fetch_array(3), fbsql_fetch_assoc(3), fbsql_fetch_object(3).
PHP Documentation Group FBSQL_RESULT(3)