Shell Programming and Scripting

Hey all,

i´ve got the following problem:

i´m aquiring data with an instrument and i get data in a .txt file.
This is how the txt file looks like:


Report of AU program poptau

F1P=-49.986ppm F2P=-110.014ppm
Target directory for serfile: D:/data/Spect500/nmr/Thoma/882

Linear optimization of d2 in 11 steps,
PROCNO=998
starting at 0.500000000 endval= 1.500000000
OPTIMUM= ZERO
VARMOD= LIN
Experiment d2 Maximum point Minimum point Integral
1 0.500000000000 162704741 -257018127 -346061.627907
2 0.600000000000 125168225 -216869342 -394303.829457
3 0.700000000000 129871534 -188930768 -195603.542636
4 0.800000000000 121170691 -148043694 -6968.015504
5 0.900000000000 73921947 -143270760 -316422.573643
6 1.000000000000 85655594 -93738968 89281.410853
7 1.100000000000 58172578 -84404085 -51339.131783
8 1.200000000000 42346639 -45157174 62366.790698
9 1.300000000000 33837843 -21086189 29932.883721
10 1.400000000000 20652605 -15664220 48913.046512
11 1.500000000000 20652605 -15664220 48913.046512
poptau for d2 finished.

For my further work i just need the 2nd and last coloumn of the data set.
Which commands i have to use for this in my terminal?

thx for your answers :-)

bye

Code:

awk '/^[0-9]/ { print $2,$NF } ' filename

hey,

thx for your quick answer!

i have typed the command into my terminal but nothing happens....

could you explain shortly what the command is doing?

thx

Can you tell us what OS and shell are you using by running below commands:

Code:

uname
echo $SHELL

Below awk program is looking for lines starting with numbers /^[0-9]/ and printing 2nd and last column print $2,$NF

Code:

awk '/^[0-9]/ { print $2,$NF } ' filename

by typing uname i get Darwin any by typing echo $SHELL i get /bin/bash.

Ah ok.... it´s kind of logical :-D

How about a bash script then?

Code:

#!/bin/bash

while read line
do
        if [[ "$line" =~ "^[0-9]" ]]
        then
                echo $line | cut -f 2,5 -d' '
        fi
done < filename

Note: Replace filename with your text file name.

The awk command ought to work in osx. Make sure you're typing it exactly the same. You might have missed a quote or some such.