hi all,
could anyone help me?
I need to query output by compare dates from 2 table and i'm using a UNION query..and wanted to sort the output by date..
My query like this:
SELECT
TO_CHAR(DATE) DATE1,
INVOICE
FROM ACCOUNT1
WHERE DATE < (to_date('122003','MMYYYY'))
UNION ... (2 Replies)
Hi, I need somebody's help with sorting data with awk.
I've got a file:
10 aaa 4584
12 bbb 6138
20 ccc 4417
21 ddd 7796
10 eee 7484
12 fff ... (5 Replies)
hI
I have file A
NSU30504 5 6 G 6
NSU3050B T 7 9 J
NSU30506 T I 8 9
NSU3050C H J K L Output:
NSU3050B T 7 9 J
NSU3050C H J K L
NSU30504 5 6 G 6
NSU30506 T I 8 9Video tutorial on how to use code tags in The UNIX and Linux Forums. (13 Replies)
Hi. I am not sure the title gives an optimal description of what I want to do. Also, I tried to post this in the "UNIX for Dummies Questions & Answers", but it seems no-one was able to help out.
I have several text files that contain data in many columns. All the files are organized the same... (14 Replies)
Hi ,
I have below data inside a file named ref.psv . I want to create a shell script which will do the below 2 points :
(1) sort the file content first based on the latest date which is the last column in the file (actual file its the 175th column)
(2)after sorting the file based on latest date... (3 Replies)
Hello people,
I am having problem to sort, sed and zero padding of column in csv file.
7th column only.
Input of csv file:
1,2,3,4,5,6,4/1/2010 12:00 AM,8
1,2,3,4,5,6,3/11/2010 9:39 AM,8
1,2,3,4,5,6,5/12/2011 3:43 PM,8
1,2,3,4,5,6,12/20/2009 7:23 PM,8
Output:... (5 Replies)
Hi,
i "tried" to sort data by date. So far, i used sed to take the data from the last and the actual month. Now, after changing the year it is not working properly.
i use:
GNU bash, version 4.2.45(1)-release (x86_64-suse-linux-gnu)
sed -n '/\//p' $Home/../scripte/pd_0.txt
y is a... (6 Replies)
Can i use 'column' command to get the required 3rd column output?
Input example:
1 2 345678 90
2 2 356 42
3 3 8265 55
Output required:
1 2 345678 90
2 2 356 42
3 3 8265 55
Basically i want the 3rd column to be justified to the right, instead of left.... (3 Replies)
Discussion started by: nurul_nadzirah
3 Replies
LEARN ABOUT HPUX
ccosf
ccos(3M)ccos(3M)NAME
ccos(), ccosf(), ccosl(), ccosw(), ccosq() - complex cosine functions
SYNOPSIS DESCRIPTION
These functions are available only for Integrity servers.
returns the complex cosine of z.
is a version of it takes a argument and returns a result.
is a version of it takes a argument and returns a result.
is an version of it takes an argument and returns an result.
is equivalent to on HP-UX systems.
USAGE
To use these functions, compile with the default option. To use compile with the option. Make sure your program includes Link in the math
library by specifying on the compiler or linker command line.
RETURN VALUE
= and is even.
returns 1-i0.
(where the sign of the imaginary part of the result is unspecified) and raises the invalid floating-point exception.
(where the sign of the imaginary part of the result is unspecified).
returns NaN+iNaN and raises the invalid floating-point exception, for finite nonzero x.
returns NaN+iNaN and optionally raises the invalid floating-point exception, for finite nonzero x.
returns +Inf-i0.
returns +Inf(cos(y)-isin(y)), for finite nonzero y.
(where the sign of the real part of the result is unspecified) and raises the invalid floating-point exception.
returns +Inf+iNaN.
(where the sign of the imaginary part of the result is unspecified).
returns NaN+iNaN and optionally raises the invalid floating-point exception, for all nonzero numbers y.
returns NaN+iNaN.
ERRORS
No errors are defined.
SEE ALSO cos(3M), cacos(3M), complex(5).
STANDARDS CONFORMANCE
: ISO/IEC C99 (including Annex G, ``IEC 60559-compatible complex arithmetic'')
HP Integrity Server Only ccos(3M)