Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

convert date 1

Status
Not open for further replies.
kamsabeti

kamsabeti

IS-IT--Management
Feb 26, 2008
21
How can I convert this number to a date format:
Raw data: 200706 to June-2007

Thanks
Kamran

 
Sort by date Sort by votes
Hi

Code: 
echo '200706' | awk 'BEGIN{split("January February March April May June July August September October November December",m)}{print m[substr($0,5,2)+0]"-"substr($0,1,4)}'

Feherke.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mikrom
  • Locked
  • Question
Convert data structure 1
Replies
2
Views
246
mikrom
mikrom
syed aasik
  • Locked
  • Question
need to convert the postfix log file into csv - reg.,
Replies
0
Views
102
syed aasik
syed aasik
sushilps
  • Locked
  • Question
Add and update column based on date/time to csv file
Replies
11
Views
162
sushilps
sushilps
LeHibou
  • Locked
  • Question
Convert ip
Replies
4
Views
45
LeHibou
LeHibou
fxsme
  • Locked
  • Question
awk : matcing timestamps, date, and manipulations colums to create a new file
Replies
2
Views
57
fxsme
fxsme

Part and Inventory Search

Sponsor

Back
Top