Solved

Change the date format

Posted on 2006-11-29
3
236 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
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Error Message during CentOS 7 Minimal Install 3 58
VMware Workstation 12 Player 16 118
awk variable in printf 1 33
Linux Real Time Memory on Distinct 24 Cycle 7 29
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
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.

792 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