06-26-2008
Thanks Danmero and vgresh99 for the reply. But still I have some another problem. If I have my file as
File1:
Col1 Col2 ID
2008-06-02|12.36.06|1-432
2008-06-01|23.36.35|1-345
In the above file I have ID column values as 1<<Hypen>>432,1<<hypen>>345.
What's happening is when I give the command
$ cat File1
$ nawk -F'([|]|[-])' '{gsub("[.]", ":", $4); print $3$2$1 "|" $4 "|" $5
It is giving output as :
Col1 Col2 ID
2008-06-02|12.36.06|1|432
2008-06-01|23.36.35|1|345
It is replacing 1<<Hypen>>432 as 1|432. Please let me know how to get out of it. Thanks in advance.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I know there is a Q/A section and lots of posts regarding date command here. I am sorry to start a new thread. I am very new to shell scripting (actually i am working on my first program), so please forgive my ignorance. I could not find an answer to my problem else where so i posted it... (10 Replies)
Discussion started by: Dream86
10 Replies
2. Shell Programming and Scripting
Hi,
Is there any way to change one date format to another ?? I mean I have a file having dates in the format (Thu Sep 29 2005) ... and i wud like to change these to YYYYMMDD format .. is there any command which does so ?? Or anything like enum which we have in C ??
Thanks in advance,
... (5 Replies)
Discussion started by: Sabari Nath S
5 Replies
3. UNIX for Dummies Questions & Answers
Hi,
There are lots of threads about how to manipulate the date using date +%m %.......
But how can I change the default format of the commad date?
$ date
Mon Apr 10 10:57:15 BST 2006
This would be on fedora and SunOs.
Cheers,
Neil (4 Replies)
Discussion started by: nhatch
4 Replies
4. Post Here to Contact Site Administrators and Moderators
In my shell script i have a variable which stores date in the format of YYYYMMDD. Is there any way to format this value to MM/DD/YYYY.
Thanks. (1 Reply)
Discussion started by: nasirgondal
1 Replies
5. Shell Programming and Scripting
How to change a date stored in a variable to YYYYMMDD.
Variable output is in DD-MON-YY,required format is 'YYYYMMDD'
Thanks,
Sud (1 Reply)
Discussion started by: sud
1 Replies
6. UNIX for Dummies Questions & Answers
I have a list of dates in the following format: mm/dd/yyyy and want to change these to the MySQL standard format: yyyy-mm-dd.
The dates in the original file may or may not be zero padded, so April is sometimes "04" and other times simply "4".
This is what I use to change the format:
sed -i '' -e... (2 Replies)
Discussion started by: figaro
2 Replies
7. UNIX for Advanced & Expert Users
Hi All,
I am new to this forum, could any one help me out in resolving the below issue.
Input of the flat file contains several lines of text for example find below:
5022090,2,4,7154,88,,,,,4/1/2011 0:00,Z,L,2
5022090,3,1,6648,88,,,,,4/1/2011 0:00,Z,,1
5022090,4,1,6648,88,,,,,4/1/2011... (0 Replies)
Discussion started by: av_sagar
0 Replies
8. Shell Programming and Scripting
Hi all,
I have a file with below data
af23b|11-FEB-12|acc7
ad23b|12-JAN-12|acc4
as23b|15-DEC-11|acc5
z123b|18-FEB-12|acc1
I need the output as below:-(date in yyyymmdd format)
af23b|20120211|acc7
ad23b|20120112|acc4
as23b|20111215|acc5
z123b|20120218|acc1
Please help me on this.... (7 Replies)
Discussion started by: gani_85
7 Replies
9. Shell Programming and Scripting
How can i make the date command output yesterday's date, current date and the date 4 days ago, in the following format:
2012-10-03
code:
date +% ???? (3 Replies)
Discussion started by: SkySmart
3 Replies
10. Shell Programming and Scripting
how do i change the following to show me what the date was 7 days ago?
date +%Y-%m-%d (1 Reply)
Discussion started by: SkySmart
1 Replies