|
|
Sponsored Content
Top Forums
UNIX for Advanced & Expert Users
change field 2 date format
Post 302438867 by dr.house on Wednesday 21st of July 2010 04:10:15 AM
07-21-2010
|
|
10 More Discussions You Might Find Interesting
1. Solaris
dear members,
ls -l
drwxr-xr-x 40 root sys 1024 Jul 11 22:19 usr
drwxr-xr-x 43 root sys 1024 Feb 1 2009 var
i am using solaris 10
is that possibe to do
drwxr-xr-x 40 root sys 1024 25-08-2009 22:19 usr
drwxr-xr-x 43 root sys ... (4 Replies)
Discussion started by: hosney00ux
4 Replies
2. Shell Programming and Scripting
Hi Everyone,
# cat 1.txt
1321631,77770132976455,19,20091001011859,20091001011907
1321631,77770132976455,19,20091001011859,20091001011907
1321631,77770132976455,19,20091001011859,20091001011907
# cat 1.txt | awk -F, '{OFS=",";print $1,$3,$4,$5}'
1321631,19,20091001011859,20091001011907... (7 Replies)
Discussion started by: jimmy_y
7 Replies
3. Shell Programming and Scripting
Hi I have a date format in a variable as Mon Jan 11 03:35:59 2010. how do i change it to YYYYMMDD format (3 Replies)
Discussion started by: keerthan
3 Replies
4. Shell Programming and Scripting
Hi guys,
I have a text file with lots of lines like this:
MCOGT23R27815 27/07/07 27/05/09
SO733AM0235 30/11/07 30/11/10
NL123403N 04/03/08 04/03/11
0747AM7474 04/04/08 04/04/11
I want to change each line so the date format looks like this:
MCOGT23R27815 07/07/27 09/05/27 ... (7 Replies)
Discussion started by: Tornado
7 Replies
5. Shell Programming and Scripting
Hi Guys,
I had a scenario like this..
It seems very silly...dont think it as a home work question.....:)
i tried it many ways but i didn't achieve this...
start_date=May122011
here i want to change the start_date in to 20110512
start_date=20110512
tell me how can we achive... (5 Replies)
Discussion started by: apple2685
5 Replies
6. Shell Programming and Scripting
Dear Friends,
Need your help once again,
I have a variable ( e.g. ${i}) whoch has date in MM/DD/YYYY (E.g. 12/31/2011) format.
I want to change it to DD/MM/YYYY (e.g. 31/12/2011) format.
Request you to guide me as we are unable to do the same.
Thanks in advance
Anu. (1 Reply)
Discussion started by: anushree.a
1 Replies
7. Shell Programming and Scripting
Hi,
I was looking for a script to change the date from one format to other. A search in the forum gave me the below script as a result.
#! /bin/ksh
format=YYYYMMDD
YEAR=${format%????}
DAY=${format#??????}
MON=${format#$YEAR}
MON=${MON%$DAY}
echo $MON/$DAY/$YEAR
I got it... (2 Replies)
Discussion started by: prithvirao17
2 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
need some more help please
i have a large file and
i want to change just the date format
with awk or sed
from this
yyyy-mm-dd
2016-04-15 8.30
2016-04-15 7.30
2016-04-13 7.30
2016-04-11 8.30
2016-04-11 7.30
2016-04-08 8.30
2016-04-08 7.30
2016-04-06... (5 Replies)
Discussion started by: bob123
5 Replies
10. UNIX for Advanced & Expert Users
Hi,
I have two (2) things that I want to do.
First is to change the date format that is in the nth field from MM/DD/YY to YY/MM/DD. Preferably, I wish I know how to make it a 4-digit year but I don't. Problem is I can only assume it is a 20 century
Second is somehow know how to figure out... (1 Reply)
Discussion started by: newbie_01
1 Replies
LEARN ABOUT SUNOS
wtmpfix
fwtmp(1M) System Administration Commands fwtmp(1M) NAME
fwtmp, wtmpfix - manipulate connect accounting records SYNOPSIS
/usr/lib/acct/fwtmp [-ic] /usr/lib/acct/wtmpfix [file...] DESCRIPTION
fwtmp reads from the standard input and writes to the standard output, converting binary records of the type found in /var/adm/wtmpx to formatted ASCII records. The ASCII version is useful when it is necessary to edit bad records. wtmpfix examines the standard input or named files in utmpx format, corrects the time/date stamps to make the entries consistent, and writes to the standard output. A hyphen (-) can be used in place of file to indicate the standard input. If time/date corrections are not performed, acctcon(1M) will fault when it encounters certain date-change records. Each time the date is set, a pair of date change records are written to /var/adm/wtmpx. The first record is the old date denoted by the string "old time" placed in the line field and the flag OLD_TIME placed in the type field of the utmpx structure. The second record speci- fies the new date and is denoted by the string new time placed in the line field and the flag NEW_TIME placed in the type field. wtmpfix uses these records to synchronize all time stamps in the file. In addition to correcting time/date stamps, wtmpfix will check the validity of the name field to ensure that it consists solely of alphanu- meric characters or spaces. If it encounters a name that is considered invalid, it will change the login name to INVALID and write a diag- nostic to the standard error. In this way, wtmpfix reduces the chance that acctcon will fail when processing connect accounting records. OPTIONS
-ic Denotes that input is in ASCII form, and output is to be written in binary form. FILES
/var/adm/wtmpx history of user access and administration information ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWaccu | +-----------------------------+-----------------------------+ SEE ALSO
acctcom(1), ed(1), acct(1M), acctcms(1M), acctcon(1M), acctmerg(1M), acctprc(1M), acctsh(1M), runacct(1M), acct(2), acct.h(3HEAD), utmpx(4), attributes(5) System Administration Guide: Basic Administration SunOS 5.10 22 Feb 1999 fwtmp(1M)