Re: Changing output

From: Euro Millions (shotoku.taishi_at_virgin.net)
Date: 03/08/04 

Date: Mon, 8 Mar 2004 20:34:25 -0000

Thank you all for your replies. My sincere apologies for not getting back to
you earlier but I was away over the weekend. I will put your suggestions
into practice and will let you know hw I get on. :-)

Okay, what I really want to do?

I thought that I might be able to put together a little Perl program to help
me automate writing my weekly report. Maybe you can think of a better way
than what I had in mind?

The language thing was just an example for me to get started, but this is
what I had in mind:

First I wanted to put all the info into a reader friendly excel file e.g.
date, tasks completed, tasks planned for next week . This file would be
saved into a csv file. Subsequently I have to change the format which I can
import into a word template using the mail merge facility. Too complicated?

The problem about using mail merge is that in order to get it to work I need
all the info to be stored into two lines - one title line and the other line
to contain all the data. So I wanted this particular perl script to
translate my reader friendly excel file (saved into a csv text file) into a
format which can be understood by the mail merge program. It might be a
little tedious to put together but in the end I am sure it would be a time
saving exercise.

Kind Regards

Mike

"Brad Baxter" <bmb@ginger.libs.uga.edu> wrote in message
news:Pine.A41.4.58.0403052114580.17250@ginger.libs.uga.edu...
> On Fri, 5 Mar 2004, Euro Millions wrote:
> > What I would like to do is simple (that is if you know it)
> >
> > I have a CSV text file (comma separated file) which contains the
following
> > info:
> >
> > Language, Greeting,
> > English, Hello,
> > German, Hallo,
> > Spanish, Hola,
> > Japanese, Konnichiwa,
> >
> > I would like Perl to create an output file which looks as follows:
> >
> > Language,Language2, Language3, Langauge4, Greeting,Greeting2, Greeting3,
> > Greeting4
> > English, German, Spanish, Japanese, Hello, Hallo, Hola, Konnichiwa
>
> Okay, now tell us what you REALLY want to do. :-)
>
> Obviously, you don't really have that file, because writing a program for
> that purpose just doesn't make sense. So, do you really have a file that
> contains dozens of languages? Is "Greeting" always "Hello", not "Good
> morning", "G'day", "'Sup"? I assume your list contains other things, like
> "Thank you", "Please", etc.
>
> The question as it stands is so trivial that I'm compelled to think you're
> leaving out the parts that matter.
>
> Regards,
>
> Brad
>

Relevant Pages