11-18-2008
number query
I have a small query
How can i convert the these number
input
001 90 109
output
1 90 109
expoected one line command
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
Do you have any pointers how to validate numbers (not to contain alphabets and special characters) and date(MM/DD/YYYY) format.
I used following regular expression to validate integer, which is not working in the default shell:
nodigits="$(echo $testvalue | sed 's/]//g')"
... (4 Replies)
Discussion started by: alok_jax
4 Replies
2. Shell Programming and Scripting
I would like to use the result of a query in another query. How do I redirect/add the output to another variable?
$result = odbc_exec($connect, $query);
while ($row = odbc_fetch_array($result)) {
echo $row,"\n";
}
odbc_close($connect);
?>
This will output hostnames:
host1... (0 Replies)
Discussion started by: hazno
0 Replies
3. Shell Programming and Scripting
Hi there,
I am currently writing a csh script in which I want to be able to interrogate the hardware by some means in order to determine whether or not dual monitors are connected. This can't unfortunately be done by looking at xorg.conf because although some of the machines in question have... (2 Replies)
Discussion started by: mpcengineering
2 Replies
4. Shell Programming and Scripting
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies
5. UNIX for Advanced & Expert Users
Hi all
Thanks in advance...........
Please help me for this issue............
I have a file it has 11 records . I used the command like ....
>$ wc -l file
11 file
I'm getting output like 11 file (no.of records along with filename)
here my requirement is, I want to display only... (3 Replies)
Discussion started by: ksrivani
3 Replies
6. Shell Programming and Scripting
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Discussion started by: DevendraG
2 Replies
7. Shell Programming and Scripting
Hi Power User,
I'm trying to compute this kind of text file format:
file1:
jakarta 100 150
jakarta 170 210
beijing 220 250
beijing 260 280
beijing 290 320
new_york 330 350
new_york 370 420
tokyo 430 470
tokyo 480 ... (2 Replies)
Discussion started by: anjas
2 Replies
8. Shell Programming and Scripting
Input file:
ID_34 2E-69 2324
ID_1 0E0 3254
ID_1 0E0 5434
ID_5 0E0 436
ID_1 1E-14 2524
ID_1 5E-52 46437
ID_3 65E-20 45467
ID_1 0E0 6578
...
Desired output file:
ID_1 0E0 6578
ID_1 0E0 5434
ID_1 0E0 3254
ID_1 5E-52 46437
ID_1 1E-14 2524
ID_3 65E-20 45467 (5 Replies)
Discussion started by: cpp_beginner
5 Replies
9. Shell Programming and Scripting
Hello All,
I have a requirement in which i will be given a sql query as input in a file with dynamic number of columns. For example some times i will get 5 columns, some times 8 columns etc up to 20 columns.
So my requirement is to generate a output query which will have 20 columns all the... (7 Replies)
Discussion started by: vikas_trl
7 Replies
10. Shell Programming and Scripting
Hi
I want to use awk to match where field 3 contains a number within string - then print the line and just the number as a new field.
The source file is pipe delimited and looks something like
1|net|ABC Letr1|1530|||
1|net|EXP_1040 ABC|1121|||
1|net|EXP_TG1224|1122|||
1|net|R_North|1123|||... (5 Replies)
Discussion started by: Mudshark
5 Replies
LEARN ABOUT SUNOS
wsreg_query_get_instance
wsreg_query_set_instance(3WSREG) Product Install Registry Library Functions wsreg_query_set_instance(3WSREG)
NAME
wsreg_query_set_instance, wsreg_query_get_instance - set or get the instance of a query
SYNOPSIS
cc [flag ...] file ...-lwsreg [library ...]
#include <wsreg.h>
int wsreg_query_set_instance(Wsreg_query *query, int instance);
int wsreg_query_get_instance(Wsreg_query *comp);
DESCRIPTION
The wsreg_query_set_instance() function sets the instance number specified by instance in the query specified by query.
The wsreg_query_get_instance() function retrieves the instance from the query specified by query.
RETURN VALUES
The wsreg_query_set_instance() function returns a non-zero value if the instance was set correctly; otherwise 0 is returned.
The wsreg_query_get_instance() function returns the instance number from the specified query. It returns 0 if the instance number has not
been set.
USAGE
The query identifies fields used to search for a specific component in the product install registry. By specifying the instance, the com-
ponent search is narrowed to all components in the product install registry that have the specified instance.
Other fields can be specified in the same query to further narrow down the search.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|MT-Level |Unsafe |
+-----------------------------+-----------------------------+
SEE ALSO
wsreg_get(3WSREG), wsreg_initialize(3WSREG), wsreg_query_create(3WSREG), attributes(5)
SunOS 5.10 22 Sep 2000 wsreg_query_set_instance(3WSREG)