02-28-2006
$ more tmp1
2|LAX|06/02/24 13:12:35|sf49ers|30|M
3|OAK|06/02/25 11:12:36|goraiders|27|F
1|SFO|06/02/24 12:12:34|hawkeye|35|M
4|PIT|06/02/25 12:12:37|steeler|35|M
$ nawk 'BEGIN {FS="[ |/]"}
{
printf("%s|%s|%s/%s/%s %s",$1,$2,$4,$5,$3,$6);
for(i=7;i<=NF;i++)
{
printf("|%s",$i);
}
printf "\n";
}' tmp1
2|LAX|02/24/06 13:12:35|sf49ers|30|M
3|OAK|02/25/06 11:12:36|goraiders|27|F
1|SFO|02/24/06 12:12:34|hawkeye|35|M
4|PIT|02/25/06 12:12:37|steeler|35|M
You can clearly see the date format changing to MM/DD/YY...
Is it not what you are looking for ?? what do you mean by same as b4 ?
I think the format of your flat file is different than what you have posted if it is not working....
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Is there any way we could change the date format listed below...
date I get is 03302007 (MMDDYYYY)
I need to change it to 20070330 (YYYYMMDD)
Thanks. (3 Replies)
Discussion started by: mgirinath
3 Replies
2. Shell Programming and Scripting
:cool:
Hi all,
I have a pecular issue in sorting these files in Solaris environment.
All the below files are modified on November 4th, but I want to sort these files as per date column (eg: 01May07_1623 = ddmmmyy_hhmm)
Nov 4 18:27 SONYELEC00.GI22973.01May07_1623.gpg
Nov 4 18:27... (4 Replies)
Discussion started by: shivaastrogun
4 Replies
3. Shell Programming and Scripting
Hi Guys,
I'm having a bit of a problem with a script, i need to get the day, month and day of month into a string, so i'm using:
CURRENT_DATE=`date +"%a %b %e"`
It is getting the correct date out, however it is not keeping the padding on the day of month. The %e is supposed to pad the day... (5 Replies)
Discussion started by: seanbyrne
5 Replies
4. Shell Programming and Scripting
I have a data file. Seperated by "|". The 19 th filed is a date field that occurs like this
11/02/2001
i need to convert into the below format
2001-11-02
for e.g..
i/p
o/p should be
can somebody throw some light (5 Replies)
Discussion started by: dsravan
5 Replies
5. UNIX for Advanced & Expert Users
from this input
WEBELSOLAR,29122009,1:1
WIPRO,15062010,2:3
ZANDUREALT,18012007,1:3
i want output as
WEBELSOLAR,20091229,1:1
WIPRO,20100615,2:3
ZANDUREALT,20070118,1:3
basically input is in ddmmyyyy format and i was to convert it to yyyymmdd format (1 Reply)
Discussion started by: manishma71
1 Replies
6. Shell Programming and Scripting
SOLVED : (17 Replies)
Discussion started by: Glitch100
17 Replies
7. Shell Programming and Scripting
Hi,
In a field, I should receive the date with time stamp in a particular field. But sometimes the vendor sends just the date or the timestamp or correctl the date×tamp. I have to figure out the the data is a date or time stamp or date×tamp.
If it is date then append "<space>00:00:00"... (1 Reply)
Discussion started by: machomaddy
1 Replies
8. Linux
I have a .CSV file (file.csv) whose data are all enclosed in double quotes. Sample format of the file is as below:
column1,column2,column3,column4,column5,column6, column7, Column8, Column9, Column10
"12","B000QRIGJ4","4432","string with quotes, and with a comma, and colon: in... (3 Replies)
Discussion started by: dhruuv369
3 Replies
9. Shell Programming and Scripting
Hii
I am trying to remove the date field from the following string. ODS_EPP_COVRG_STN_DETL_FILE_10032014.TXT. My output should be ODS_EPP_COVRG_STN_DETL_FILE.TXT
I tried couple of things:
echo ODS_EPP_COVRG_STN_DETL_FILE_10032014.TXT|sed 's/_*\.*//g'
I am getting:... (9 Replies)
Discussion started by: skatpally
9 Replies
10. OS X (Apple)
Hi,
Am performing a find based on filename and result can contain multiple files being found
Let's say my find command is
find /Archive -f -name 12345.pdf
and result of find command is
/Archive/Folder A/12345.pdf
/Archive/Folder B/12345.pdf
please note white space in folder names
I... (2 Replies)
Discussion started by: gigagigosu
2 Replies
sortm(1) General Commands Manual sortm(1)
NAME
sortm - sort messages (only available within the message handling system, mh)
SYNOPSIS
sortm [msgs] [+folder] [options]
OPTIONS
Specifies the name of the header field to use when making the date comparison. If you have a special field in each message, such as Deliv-
ery-Date:, then the -datefield switch can be used to tell sortm which field to examine. If you do not give this option, the default is to
use the Date: header field. Prints a list of all the valid options to this command. Displays the general actions that it is taking to
place the folder in sorted order. The -noverbose option performs these actions silently. The default is -noverbose.
The default settings for this command are:
+folder defaults to the current folder msgs defaults to all -datefield date -noverbose
DESCRIPTION
The command sortm sorts all the messages in the current folder into chronological order according to the contents of the Date: fields of
the messages.
By default, sortm sorts all the messages in the current folder. You can select particular messages in the folder by giving a range of mes-
sages. You can also sort messages in another folder by specifying the folder name.
If sortm encounters a message without a Date: field, or if the message has a Date: field that sortm cannot parse, it attempts to keep the
message in the same relative position. However, this does not always work; for instance, if the first message encountered lacks a date
which can be parsed, then it will usually be placed at the end of the messages being sorted.
When sortm complains about a message which it cannot order, it complains about the message number prior to sorting.
PROFILE COMPONENTS
Path: To determine your MH directory
EXAMPLES
The following example sorts all the messages in the folder +meetings: % sortm +meetings The next example sorts messages 10-30 in the folder
called +test: % sortm +test 10-30
FILES
The user profile.
SEE ALSO
folder(1)
sortm(1)