Hi Guys !
I am new to unix and want to find out how we can make sql statement data to shell script variable?
Any help/suggestion is greatly appreciated
-Chandra (1 Reply)
Dear Friends
I have text file as like below,
AAAAA|BHBHBH|VERYSMART
AAAAA| KKKKKK|GOOD
BBBBBB|JJJJJJJ|VERYGOOD
CCCCC|HJHJHJ|BETTER
CCCCC|UUUUU|GOOD
i need to split into seperate files based on column 1 like as below
AAAAA.TXT contains
--------------------
BHBHBH.VERYSMART... (4 Replies)
:confused: Hi UNIX gurus,
I am facing a typical problem while assigining while assigining output of awk to a variable.
I have a fixed length file say myinputfile.txt
When I allow the value/output of an awk to be redirected to a file, it works fine. i.e.
awk "/^.{232}$acctNum/ {... (8 Replies)
Hi Friends...
Please assist me to assign the result of a SQL query that results two column, to two variables.
Pls find the below code that I write for assigning one column to one variable. and please correct if anything wrong..
#! /bin/sh
no='
sqlplus -s uname/password@DBname... (4 Replies)
How can I assign a variable to an variable. IE $car=honda
One way I can do it is export $car=honda
or
let $car=2323
Is there any other ways to preform this task (3 Replies)
I have a log file that has certain fields that I want to evaluate, and depending on the value in those fields, I want to put the value of a different field in that line in a particular variable that I'll use later on down the log file. Sort of like setting a switch to change what I do with a bunch... (5 Replies)
I launch 'netstat -a', if string 'ESTABLISHED' found, then VAR=1
#!/bin/bash
VAR=0;
netstat -a | awk '$6 ~ /ESTABLISHED/ {VAR=1}'
I cannot find the right syntax.
thanx guys! (3 Replies)
I have the following script, and I want to assign the output ($10 and $5) from awk to N and L:
grdinfo data.grd | awk '{print $10,$5}'| read N L
output from gridinfo data.grd is: data.grd 50 100 41 82 -2796 6944 0.016 0.016 3001 2461. where N and L is suppose to be 3001 and 100. I use... (8 Replies)
Hi Gurus,
I have a script which assign awk output to shell variable. current it uses two awk command to assign value to two variables. I want to use one command to assign two values to two variables. I tried the code, but it does't work. kindly provide your suggestion.
current code... (2 Replies)
Discussion started by: green_k
2 Replies
LEARN ABOUT DEBIAN
cartconvert
CARTCONVERT(1) GeographicLib Utilities CARTCONVERT(1)NAME
CartConvert -- convert geodetic coordinates to geocentric or local cartesian
SYNOPSIS
CartConvert [ -r ] [ -l lat0 lon0 h0 ] [ -e a f ] [ --comment-delimiter commentdelim ] [ --version | -h | --help ] [ --input-file infile |
--input-string instring ] [ --line-separator linesep ] [ --output-file outfile ]
DESCRIPTION
Convert geodetic coordinates to either geocentric or local cartesian coordinates. Geocentric coordinates have the origin at the center of
the earth, with the z axis going thru the north pole, and the x axis thru latitude = 0, longitude = 0. By default, the conversion is to
geocentric coordinates. Specifying -l lat0 lon0 h0 causes a local coordinate system to be used with the origin at latitude = lat0,
longitude = lon0, height = h0, z normal to the ellipsoid and y due north.
Geodetic coordinates are provided on standard input as a set of lines containing (blank separated) latitude, longitude (decimal degrees or
degrees, minutes and seconds), and height above the ellipsoid (meters). For each set of geodetic coordinates, the corresponding cartesian
coordinates x, y, z (meters) are printed on standard output.
OPTIONS -r perform the reverse projection. x, y, z are given on standard input and each line of standard output gives latitude, longitude,
height.
-e specify the ellipsoid via a f; the equatorial radius is a and the flattening is f. Setting f = 0 results in a sphere. Specify f < 0
for a prolate ellipsoid. A simple fraction, e.g., 1/297, is allowed for f. (Also, if f > 1, the flattening is set to 1/f.) By
default, the WGS84 ellipsoid is used, a = 6378137 m, f = 1/298.257223563.
--comment-delimiter
set the comment delimiter to commentdelim (e.g., "#" or "//"). If set, the input lines will be scanned for this delimiter and, if
found, the delimiter and the rest of the line will be removed prior to processing and subsequently appended to the output line
(separated by a space).
--version
print version and exit.
-h print usage and exit.
--help
print full documentation and exit.
--input-file
read input from the file infile instead of from standard input; a file name of "-" stands for standard input.
--input-string
read input from the string instring instead of from standard input. All occurrences of the line separator character (default is a
semicolon) in instring are converted to newlines before the reading begins.
--line-separator
set the line separator character to linesep. By default this is a semicolon.
--output-file
write output to the file outfile instead of to standard output; a file name of "-" stands for standard output.
EXAMPLES
echo 33.3 44.4 6000 | CartConvert
=> 3816209.60 3737108.55 3485109.57
echo 33.3 44.4 6000 | CartConvert -l 33 44 20
=> 37288.97 33374.29 5783.64
echo 30000 30000 0 | CartConvert -r
=> 6.483 45 -6335709.73
ERRORS
An illegal line of input will print an error message to standard output beginning with "ERROR:" and causes CartConvert to return an exit
code of 1. However, an error does not cause CartConvert to terminate; following lines will be converted.
SEE ALSO
The algorithm for converting geocentric to geodetic coordinates is given in Appendix B of C. F. F. Karney, Geodesics on an ellipsoid of
revolution, Feb. 2011; preprint <http://arxiv.org/abs/1102.1215>.
AUTHOR
CartConvert was written by Charles Karney.
HISTORY
CartConvert was added to GeographicLib, <http://geographiclib.sf.net>, in 2009-02. Prior to 2009-03 it was called ECEFConvert.
GeographicLib 1.21 2012-04-24 CARTCONVERT(1)