What happens is that it prints the header on to the terminal and the rest is piped out to the file output.
Also found out that -gk9 works for scientific notation. -nrk9 did not work as expected.
Hi!!!
i have two files "tushar20090429200000.txt" and "tushar_err20090429200000.txt"
The numeric part here is date and time.
So this part of file keeps changing after every hour.
I want to extract the numeric part from the both file names and compare them whether they are equal or not.
... (4 Replies)
If I use ls to print all the files of a folder, is there a way to sort using roman numerals?
I am thinking about a result like:
benjamin_I.wmv
benjamin_II.wmv
benjamin_II.wmv
benjamin_III.wmv
benjamin_IV.wmv
benjamin_V.wmv
benjamin_VI.wmv
benjamin_VII.wmv
benjamin_VIII.wmv... (6 Replies)
Dea all,
I have a question. I have a column of numbers with scientific notion and decimal combined data. I want to print it only if the number <0.05 using awk. however the very small numbers with scientific notion is not selected. Do any one know how to solve it? Thanks! example as below: ... (4 Replies)
Hello,
I have a file such as this:
chr1
chr2
chr1
chr2
chr3
chr10
chr4
chr5
chrz
chr1AI want to sort it, I use this command:
sort -k1 -th -n testfilebut I get this output, how can I fix this?
chr1
chr1
chr10
chr1A
chr2
chr2 (3 Replies)
Hi all,
I am new to AWK and I am trying to solve a problem that is probably easy for an expert. Suppose I have the following data file input.txt:
20 35 43
20 23 54
20 62 21
20.5 43 12
20.5 33 11
20.5 89 87
21 33 20
21 22 21
21 56 87
I want to select from all lines having the... (4 Replies)
Greetings
I have a file formatted like this:
rhino grey weight=1003;height=231;class=heaviest;histology=9,0,0,8
bird white weight=23;height=88;class=light;histology=7,5,1,0,0
turtle green weight=40;height=9;class=light;histology=6,0,2,0... (2 Replies)
hello folks,
I have few values in a log which are in scientific notation.
I am trying to convert into actual decimal format or integer but couldn't able to convert.
Values in scientific notation:
1.1662986666666665E-4
2.0946799999999998E-4
3.0741333333333333E-6
5.599999999999999E-7... (2 Replies)
Dear all,
I have a txt file with only one column which contains p values. My data looks like this:
5.04726976606584e-190
2.94065711152402e-189
2.94065711152402e-189
9.19932135717279e-176
1.09472516659859e-170
1.24974648916809e-170
0.1223974648916
0.9874974648916
...
what I want... (2 Replies)
Input file:
data1 0.05
data2 1e-14
data1 1e-330
data2 1e-14
data5 2e-60
data5 2e-150
data1 4e-9
Desired output:
data2 1e-14
data1 1e-330
data2 1e-14
data5 2e-60
data5 2e-150
I would like to filter out those result that column 2 is less than 1e-10.
Command try: (1 Reply)
Hey everybody,
I'm trying to sort scientific numbers in a descending order using the command
sort -gr <file>.
It works fine on a Linux-Server, but doesn't on my macbook pro with OS X 10.10.3 (Yosemite).
I tried to sort the following:
6.38e-10
6.38e-10
1.80e-11
1.00e-10
1.48e-12
And... (9 Replies)
Discussion started by: plebs
9 Replies
LEARN ABOUT SUSE
alter_server
ALTER SERVER(7) SQL Commands ALTER SERVER(7)NAME
ALTER SERVER - change the definition of a foreign server
SYNOPSIS
ALTER SERVER servername [ VERSION 'newversion' ]
[ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ]
ALTER SERVER servername OWNER TO new_owner
DESCRIPTION
ALTER SERVER changes the definition of a foreign server. The first form changes the server version string or the generic options of the
server (at least one clause is required). The second form changes the owner of the server.
To alter the server you must be the owner of the server. Additionally to alter the owner, you must own the server and also be a direct or
indirect member of the new owning role, and you must have USAGE privilege on the server's foreign-data wrapper. (Note that superusers sat-
isfy all these criteria automatically.)
PARAMETERS
servername
The name of an existing server.
serverversion
New server version.
OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )
Change options for the server. ADD, SET, and DROP specify the action to be performed. ADD is assumed if no operation is explicitly
specified. Option names must be unique; names and values are also validated using the server's foreign-data wrapper library.
EXAMPLES
Alter server foo, add connection options:
ALTER SERVER foo OPTIONS (host 'foo', dbname 'foodb');
Alter server foo, change version, change host option:
ALTER SERVER foo VERSION '8.4' OPTIONS (SET host 'baz');
COMPATIBILITY
ALTER SERVER conforms to ISO/IEC 9075-9 (SQL/MED).
SEE ALSO
CREATE SERVER [create_server(7)], DROP SERVER [drop_server(7)]
SQL - Language Statements 2010-05-14 ALTER SERVER(7)