Re: reformat the output

From: joe (pearl_77_at_hotmail.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 12:21:12 -0500

Sorry My bad,
I made a little mistake,

Original output:

 year
 ------
 2004
 2005
 2003
 2008
 2006
 2007

I really want to convert to following format:

Desired Output:

year
--------
2003/2004
2005/2006
2007/2008

Note: if there is no 2008 year,
then output will be

year
--------
2003/2004
2005/2006
2007

"joe" <pearl_77@hotmail.com> wrote in message
news:uDEJAEsBEHA.3184@TK2MSFTNGP09.phx.gbl...
> Orginal output
>
> year
> ------
> 2004
> 2005
> 2003
> 2008
> 2006
> 2007
>
>
> how do I convert to such an output :
>
> c1 c2 c3 c4
> ---------- --------- -------------- ------------
> 2003/2004 2004/2005 2006/2007 2007/2008
>
>
> Note: let's say we don't have 2008 year,
>
> then c4 will be 2007 , not 2007/2008
>
>
>

Relevant Pages

  • Re: Fourier Analysis
    ... Excel can work with a text number like 3 ('3 entered as text, ... or "j" term has a zero Imaginary component. ... Make sure all complex numbers follow this format... ... I don't know whether I am making a format mistake, or what, but it appears ...
    (microsoft.public.excel.misc)
  • Re: Blu Confessions [was: DVD Empire reports SURGE in HD-DVD sales, etc.]
    ... buying into both while I waited to see which format won ... make financial sense for me to buy both players or LG's combo at this ... Of course, based on the above, the only reason to ... If I make my second format-war mistake in my life (I'd won a Sega ...
    (alt.video.dvd)
  • Re: File replaced by another file while saving. Anyway to get back the first file?
    ... I made a mistake. ... I created my first document ... My second file uses the same format so I just edit on ...
    (microsoft.public.word.newusers)
  • Re: Date Format - Conversion
    ... is very easy to hit by mistake. ... | User has a spreadsheet with dates - It used to be formated as Month-day ... The format of the column is date. ...
    (microsoft.public.excel.misc)
  • Re: OT: a problem about text manipulation
    ... I am looking for an automatic way of transforming my text file into ... another one with the format ... Something seems funky there. ... The desired output doesn't match the ...
    (Fedora)