Sponsored Content
Top Forums Shell Programming and Scripting Using awk to rearrange data according to date Post 302546499 by dude2cool on Thursday 11th of August 2011 10:33:03 AM
Old 08-11-2011
Unless I am missing something, isn't the output you pasted already in order?

Looking at the first column:

2006.99960
2006.99968
2006.99975
2006.99983
2006.99990
2002.00317
2002.00340
2002.00416
2002.00462
2002.00469
2002.00507
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need help in AWK;Search String and rearrange columns

Hi AWK Experts, file1.txt contains: 29b11b820ddcc:-|OHad.perWrk|spn_id=AH111|spn_ordtyp=MY_REQ|msg_typ=ah.ntf.out|spn_ordid=928176|spn_nid=3|msg_strt=1175615334703|msg_que=oput|diff=371|17:48:55,074|17:48:55,084|10 file2.txt contains:... (2 Replies)
Discussion started by: spring_buck
2 Replies

2. Shell Programming and Scripting

Rearrange data from 2 files

Dear All, I have the below files A file contains 1473 1649 1670 1758 1767 1784 B file contains 1242 1246 1264 1268 1284 (3 Replies)
Discussion started by: yahyaaa
3 Replies

3. Shell Programming and Scripting

awk sed cut? to rearrange random number of fields into 3 fields

I'm working on formatting some attendance data to meet a vendors requirements to upload to their system. With some help on the forums here, I have the data close. But they've since changed what they want. The vendor wants me to submit three fields to them. Field 1 is the studentid field,... (4 Replies)
Discussion started by: axo959
4 Replies

4. UNIX for Dummies Questions & Answers

Rearrange columns and rows with awk

Hello, I have the following problem I have two columns with numbers arranged as follows: x1 y1 x2 y2 .... .... x250 y250 Now I need them arranged as follows: "string a" x1 y1 x1 y2 "string b" "string a" x1 y2 x2 y2 (3 Replies)
Discussion started by: Tom46
3 Replies

5. Shell Programming and Scripting

script to rearrange data.

Hello. I have data in the following format (the spaces at the beginning of lines are included): 1 2 2 0.39621 0.00000 1 2 2 0.00000+-0.0000 * 1 2 ... (5 Replies)
Discussion started by: andersgs
5 Replies

6. Shell Programming and Scripting

how to rearrange a matrix with awk

Hi, every one. I have two files ,one is in matrix like this, one is a list with the same data as the matrix. AB AE AC AD AA AF SA 3 4 5 6 4 6 SC 5 7 2 8 4 3 SD 4 6 5 3 8 3 SE 45 ... (5 Replies)
Discussion started by: xshang
5 Replies

7. Shell Programming and Scripting

Using awk to rearrange fields

Hi, I am required to arrange columns of a file i.e make the 15th column into the 1st column. I am doing awk 'begin {fs=ofs=","} {print $15,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14}' ad.data>ad.csv the problem is that column 15 gets to column 1 but it is not comma separated with the... (10 Replies)
Discussion started by: seddoubt
10 Replies

8. Shell Programming and Scripting

Rearrange Lines with awk

I need to rearrange the lines in the input file in the example below: Input: LG1 R500 A-170 F1:81 F1:22 F2:32 F1:71 LG1 R700 A-203 F2:17 E2:18 LG1 R700 B-224 E1:9 LG2 R500 C-235 E2:9 F2:17 Output: LG1 R500 A-170 F1:81 LG1 R500 A-170 F1:22 LG1 R500 A-170 F2:32 LG1 R500 A-170... (2 Replies)
Discussion started by: aydj
2 Replies

9. Shell Programming and Scripting

Use awk to count and rearrange entries

How can I use awk to count the occurrence of field 2 and rearrange the output like below: Input: OA1 FM AA OA0 FM CC ON0 FM CC FN1 FN BB OY1 FN BB OY2 FN CC OY3 FN CC YT0 FM AA KW1 FN CC KW3 FM BB YT4 FM AA FN2 FT BB OA3 FT AA ON7 FM BB (14 Replies)
Discussion started by: aydj
14 Replies

10. Shell Programming and Scripting

awk to calculate date and show data

data: hostcomment { host_name=myhost01 entry_type=1 comment_id=1 source=0 persistent=1 entry_time=1415723753 expires=0 expire_time=0 author=hpsm comment_data=IM0837437472 } program { modified_host_attributes=1 modified_service_attributes=1 enable_notifications=1... (20 Replies)
Discussion started by: SkySmart
20 Replies
LSMBOXRC(5)							File Formats Manual						       LSMBOXRC(5)

NAME
lsmboxrc - configuration file for lsmbox DESCRIPTION
A lsmbox configuration file consists of a list of configuration options and their setting. The hash mark ("#") is used as a "comment" character. Every line beginning with a comment character is ignored. Whitespace is also ignored. COMMANDS
set variable=value Set a configuration variable to the specified value. unset variable Unset a configuration variable. This implies that the built-in default will be used instead. mailboxes filename... Specifies what mailboxes to check. You can have one or several of these lines. Each line can contain the name of one or more mail- boxes, each separated by a space. A filename of ! denotes your inbox. A leading ("=") or ("+") in a filename will be expanded into the path to your mail-directory. CONFIGURATION VARIABLES
folder The path to your mail-directory; this is usually $HOME/Mail/. lsmbox_mail_command Specifies what command to execute when the user selects a mailbox in continuous mode. mark_old Specifies whether or not old unread messages and new messages should be accounted separately. If you explicitly unset this variable using the unset command, the number of new and old messages will be added together as unread messages, otherwise they will be accounted as new and old respectively. mh_seq_unseen Specifies the string used in the .mh_sequences file to list new/old unread messages. If this variable is not set, or explicitly unset, "unseen" will be used. spoolfile The path to where the system keeps your inbox; usually /var/mail/USERNAME or /var/spool/mail/USERNAME. lsmbox_padding The width of the mailbox column. To never add additional padding beyond what's needed to align all values, specify '0' here. COMMENTS
You cannot specify a path or mailbox that contains whitespace characters (space, newline, etc.) Do not bug me about this. Having such filenames/pathnames is stupid anyway. I've deliberately tried to use the same syntax as mutt uses for its configuration-file muttrc whenever possible, to facilitate sourcing of $HOME/.lsmboxrc from your $HOME/.muttrc. lsmbox_mail_command will, however, cause mutt to emit an error. SEE ALSO
lsmbox(1), muttrc(5) HISTORY
Apr 16 2006: Updated for v2.1.0 of lsmbox. Apr 16 2004: Updated for v2.0.0 of lsmbox. Mar 13 2004: Updated for v1.9.0 of lsmbox. Jan 16 2003: Minor fixes. Jan 06 2003: Minor fixes. Dec 09 2002: Minor fixes. Nov 15 2002: Updated for v1.6.0 of lsmbox. Nov 13 2002: Add note about '+' and '='. Nov 06 2002: Minor changes. Nov 04 2002: Minor change. Oct 29 2002: Fixed a typo. Oct 28 2002: Fixed a typo. Oct 26 2002: Updated for v1.1.0 of lsmbox. Oct 26 2002: Updated for v1.0.1 of lsmbox. Oct 21 2002: Initial release. AUTHOR
lsmbox and its manual-pages are written by David Weinehall <tao@acc.umu.se> REPORTING BUGS
Report bugs to <tao@acc.umu.se>. COPYRIGHT
Copyright (C) 2002-2006 David Weinehall This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU- LAR PURPOSE. David Weinehall Apr 16, 2006 LSMBOXRC(5)
All times are GMT -4. The time now is 08:50 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy