wanted program to reduce data from HPLC

Bernard P. Murray, PhD bpmurray*STUFFER* at socrates.ucsf.edu
Wed Sep 2 15:53:40 EST 1998

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 P. Murray, PhD
Dept. Cell. Mol. Pharmacol., UCSF, San Francisco, USA

More information about the Bio-soft mailing list

Send comments to us at biosci-help [At] net.bio.net