01-18-2013
Data extraction from .txt file
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
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi
I have a file diskspace.txt
the data in that file is asFilesystem kbytes used avail %used Mounted on
/dev/vg06/lvol1 18870272 12099836 6673336 64% /dist
know i am writing a script to get the above bold data and that data need to be used as a input.
any idea... (4 Replies)
Discussion started by: gkrishnag
4 Replies
2. Shell Programming and Scripting
Hi,
I am looking for the unix script which can takes the 2 month old data from a TXT file (there is one txt file in whiche messages are appended on daily basis) and compress them into new file.Please halp me out. (2 Replies)
Discussion started by: vpandey
2 Replies
3. UNIX for Advanced & Expert Users
hi everybody,
i have a file, in it I need to extract some data that follows a particular pattern..
For example: my file contains like
now running Speak225
sep 22 mon 16:34:05 2008
--------------------------------
... (4 Replies)
Discussion started by: mohkris
4 Replies
4. Shell Programming and Scripting
Hi All,
I have a requirement where I have to search the file with some text say "Exception". This exception word can be repeated for more then 10 times.
Suppose the "Exception" word is repeated at line numbers say x=10, 50, 60, 120. Now I want to extract all the lines starting from x-5 to... (3 Replies)
Discussion started by: rrangaraju
3 Replies
5. Shell Programming and Scripting
I have an of xml file as shown below
<?xml version='1.0' encoding='ASCII' standalone='yes' ?>
<Station Index="10264" >
<Number Value="237895890" />
<Position Lat="-29.5" Lon="3.5" />
<MaxDepth Value="-4939" />
<VeloLines Count="24">
<VeloLine Index="0" >
<Depth... (3 Replies)
Discussion started by: shashi792
3 Replies
6. Shell Programming and Scripting
Hi Freinds,
I have a file1.txt in the following format
File1.txt
I want to get 2 files from the above file filextra.txt should have the lines which are ending with "<" and remaining lines in the filecompare.txt file.
Please help. (3 Replies)
Discussion started by: i150371485
3 Replies
7. Shell Programming and Scripting
Hi Guys,
I have file A.txt
File A Data
AK1521
AK2536
AK3164
I want create text file of all data above and write some data on each file.
want Output on below folder
/home/kka/out
AK1521.txt
Hi
Welocme (3 Replies)
Discussion started by: asavaliya
3 Replies
8. Shell Programming and Scripting
Hi
I am writing a shell script to parse a CSV file , in which i am facing a problem to separate the columns . Could some one help me with it.
IN301330/00001 pvavan kumar limited xyz@ttccpp.com
IN302148/00002 PRECIOUS SECURITIES (P) LTD viash@yahoo.co.in
IN300239/00000 CENTRE india... (8 Replies)
Discussion started by: nanduri
8 Replies
9. Shell Programming and Scripting
Hello,
I'm attempting to extract 13 digit numbers beginning with 978 from a data file with the following command:
awk '{ for(i=1;i<=NF;i++) if($i ~ /^978/) print $i; }' datafile > outfile
This typically works. However, the new data file is an .xml file, and this command is no longer working... (6 Replies)
Discussion started by: palex
6 Replies
10. UNIX for Beginners Questions & Answers
Hi All,
I have a data file and need to extract and convert it into csv format:
1) Read and extract the line containing string ending with "----" (file sample_linebyline.txt file) and to make a .csv file from this.
2) To read the flat file flatfile_sample.txt which consists of similar data (... (9 Replies)
Discussion started by: abhi_123
9 Replies