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
LEARN ABOUT ULTRIX
lb_unregister
lb_unregister(3ncs) lb_unregister(3ncs)
Name
lb_unregister - remove an entry from the Location Broker database
Syntax
#include <idl/c/lb.h>
void lb_$unregister(entry, status)
lb_$entry_t *entry;
status_$t *status;
Arguments
entry The entry being removed from the Location Broker database.
status The completion status. If the completion status returned in is equal to status_$ok , then the routine that supplied it was success-
ful.
Description
The routine removes from the Location Broker database the entry that matches entry. The value of entry should be identical to that
returned by the routine when the database entry was created. However, does not compare all of the fields in entry, the annotation field,
and the port number in the saddr field.
This routine removes the entry from the LLB database on the local host (the host that issues the routine). If the flags field of entry is
equal to 0, it removes the entry from the GLB database. If the flags field is equal to lb_$server_flag_local, it deletes only the LLB
entry.
Examples
The following statement unregisters the entry specified by which was obtained from a previous routine:
lb_$unregister (&BankEntry, &status);
Diagnostics
This section lists status codes for errors returned by this routine in
lb_$database_invalid
The format of the Location Broker database is out of date. The database may have been created by an old version of the
Location Broker; in this case, delete the out-of-date database and reregister any entries that it contained. The LLB
or GLB that was accessed may be running out-of-date software; in this case, update all Location Brokers to the current
software version.
lb_$database_busy The Location Broker database is currently in use in an incompatible manner.
lb_$not_registered The Location Broker does not have any entries that match the criteria specified in the unregister routine. The
requested object, type, interface, or combination thereof is not registered in the specified database.
lb_$update_failed The Location Broker was unable to register or unregister the entry.
lb_$cant_access The Location Broker cannot access the database. Among the possible reasons:
1. The database does not exist.
2. The database exists, but the Location Broker cannot access it.
lb_$server_unavailable
The Location Broker Client Agent cannot reach the requested GLB or LLB. A communications failure occurred or the bro-
ker was not running.
Files
See Also
intro(3ncs), lb_register(3ncs)
lb_unregister(3ncs)