Solved

Change the date format

Posted on 2006-11-29
3
238 Views
Last Modified: 2010-04-20
How can I read a date written in date.data file in the following format:
year/month/day

date.data
-----------
1815/11/02      Boole, George
1864/06/22      Minkowski, Hermann
1854/04/29      Poincare, Jules Henri
1877/09/11      Jeans, James Hopwood
1826/09/17      Riemann, Georg Friedrich Bernhard

and change it to the following format:
George BOOLE (November 2, 1815)

can anyone provide me with the solution.
0
Comment
Question by:saharey
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 1

Accepted Solution

by:
TraskAdam earned 50 total points
ID: 18035837
A bit of perl ought to do the trick...

[user@localhost /tmp/ee]$ cat data
1815/11/02      Boole, George
1864/06/22      Minkowski, Hermann
1854/04/29      Poincare, Jules Henri
1877/09/11      Jeans, James Hopwood
1826/09/17      Riemann, Georg Friedrich Bernhard
[user@localhost /tmp/ee]$ cat conv.pl
#!/usr/bin/perl -n

@mon = ("",
        "January",
        "March",
        "March",
        "April",
        "May",
        "June",
        "July",
        "August",
        "September",
        "October",
        "November",
        "December"
);
next unless (\/^(\d+)\/(\d+)\/(\d+)\s+([^,]+),\s*(.*)$/);

$year = $1; $mon = $2; $day = $3;
$last = $4; $first = $5;

printf "%s %s (%s %d, %d)\n",
        $first, uc($last), $mon[$mon], $day, $year;

[user@localhost /tmp/ee]$ cat data | ./conv.pl
George BOOLE (November 2, 1815)
Hermann MINKOWSKI (June 22, 1864)
Jules Henri POINCARE (April 29, 1854)
James Hopwood JEANS (September 11, 1877)
Georg Friedrich Bernhard RIEMANN (September 17, 1826)
[user@localhost /tmp/ee]$

... prolly a programatic way to find the name of the month using strftime() instead of a predefined array but it doens't seem worth the effort here.  Should probably also report bogus lines istead of just ignoring them so...

next unless (\/^(\d+)\/(\d+)\/(\d+)\s+([^,]+),\s*(.*)$/);

... should be more like...

unless (\/^(\d+)\/(\d+)\/(\d+)\s+([^,]+),\s*(.*)$/) {
       print STDERR "unrecongised line: $_";
       next;
}
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Little introduction about CP: CP is a command on linux that use to copy files and folder from one location to another location. Example usage of CP as follow: cp /myfoder /pathto/destination/folder/ cp abc.tar.gz /pathto/destination/folder/ab…
Fine Tune your automatic Updates for Ubuntu / Debian
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question