In article <6sjfc3$517$1 at fu-berlin.de>, "Oliver Politz"
<politz at medizin.fu-berlin.de> wrote:
> Hello,
> I am looking for a little program or Excel makro to reduce data from HPLC
> runs.
> The file I got is pure ASC with one value per line and has only the y-axis
> in it.
> I would like to tell the program "take every second... hundred or so line
> into a new file (or table).
> Has anybody a solution for this ?
> Thanks Oliver
> email : politz at medizin.fu-berlin.de
Since you mention Excel I am assuming you are using a PC or Mac
platform. One very flexible solution would be to install an
AWK interpreter and use a simple AWK script to select the
lines you require. For the PC I use GNU's GAWK and for the
Mac, MacGAWK.
AWK is a very simple and flexible file processing language
and is ideally suited to this task. If you choose to go this
route I can send you an AWK script for the purpose - or if you
want it done properly post the question to comp.lang.awk
where you will, I am sure, receive many informative replies.
Other possibilities are to use Perl (in a similar manner
to AWK) or to bring the file into your favourite word processor
where you can write a macro/script/whatever for copying every
n'th line to another document.
I hope that this helps,
Bernard
--
Bernard P. Murray, PhD
Dept. Cell. Mol. Pharmacol., UCSF, San Francisco, USA
