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 DEBIAN
ticker
NAME(1) General Commands Manual NAME(1)NAME
ticker - scroll messages across the screen
SYNOPSIS
ticker [options] [message]
DESCRIPTION
ticker is a program that continually scrolls a given message across the screen. There is also an interface to allow other programs to
change the message.
KEYS
+, [up arrow]
Increase scroll speed.
-, [down arrw]
Decrease scroll speed.
[space]
Pause. Press any key to unpause.
OPTIONS -h, --help
Show summary of options.
-u, --upper
Scroll text on the top line of the screen. (Default)
-l, --lower
Scroll text on the bottom line of the screen.
-fcolor, --foreground=color
Use the specified color as the forground color of the text that is scrolled. The colors that may be used are:
black gray
red brightred
green brightgreen
brown yellow
blue brightblue
magenta brightmagenta
cyan brightcyan
lightgray white
-bcolor, --background=color
Use the specified color as the background color of the text that is scrolled. On most terminals, the background color can only be
one of the colors listed in the first column above.
-dsecs, --delay=secs
Number of seconds delay between updates of the display. This controls how fast the text scrolls. You may use decimals to specify
faster scroll speeds. The default delay is 1 second; I find 0.1 more pleasing.
-snum, --sysv=num
Read messages to display from the sysv shared memory segment with an id of num. This is only for use by other programs that need to
be able to change the text ticker displays.
-Snum, --size=num
Size of the shared memory segment to read, when using shared memory communication with another program. Default is 80 characters.
-csecs, --check=secs
Minimum time between checks of the shared memory segment for a new message. Default is every second. It may in fact check consider-
ably less often, as it only checks for a new message once per time that the current message scrolls around the screen.
message
The message to scroll. Required unless -s is used, in which case it is optional.
NOTES
To use the other 23 or so lines of your screen for something useful while the ticker is running, you might want to use splitvt(1)AUTHOR
Joey Hess <joey@kitenet.net>
NAME(1)