Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Data extraction from .txt file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Data extraction from .txt file
# 15  
Old 01-18-2013
The program doesn't care what it "looks like". It cares what it actually is.

Any luck attaching the file? There is a button for 'manage attachments' when you make a reply.

Do not use the 'quick reply' box, click the 'post reply' button Image from the thread.
# 16  
Old 01-18-2013
ok, thx.... here it is....
popt.protocol.txt (1.3 KB) 
This User Gave Thanks to expikx For This Post:
Corona688
# 17  
Old 01-18-2013
Your data clearly shows blank spaces in front of the numbers! See highlighted below:
Code:
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
blank1       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.
ZERO at experiment 5.779935: d2 = 0.977993

Here is the modified awk program:
Code:
awk '/^[ 0-9]/ { print $2,$NF } ' filename

This User Gave Thanks to Yoda For This Post:
expikx
# 18  
Old 01-18-2013
hell yeah, itīs working!
thx :-)
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Data extraction and converting into .csv file.

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

2. Shell Programming and Scripting

Data extraction from .xml file

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

3. Shell Programming and Scripting

CSV file data extraction

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

4. Shell Programming and Scripting

create txt file form data file and add some line on it

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

5. Shell Programming and Scripting

data extraction from a file

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

6. Shell Programming and Scripting

data extraction from xml file

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

7. Shell Programming and Scripting

Data Extraction From a File

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

8. UNIX for Advanced & Expert Users

extraction of data from a text file which follows certain pattern

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

9. Shell Programming and Scripting

unix script to takes the old data from a TXT file and compress them into new file

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

10. UNIX for Advanced & Expert Users

get data from .txt file

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
Login or Register to Ask a Question