Data extraction from .txt file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Data extraction from .txt file
# 8  
Old 01-18-2013
A script is very nice, this was actually the next step for me :-)
I have written the script but i think nothing happens.... where does the script save the new file? is actually a new file created? sry for this stupid questions but iīm not very familiar with UNIX or LINUX....

---------- Post updated at 08:08 PM ---------- Previous update was at 08:00 PM ----------

Ok, i also tried the awk command again, but nothing happens. I believe that iīm misunderstanding something..... after applying the command, is the file changed or is na new file created at a different place with this changes?
# 9  
Old 01-18-2013
The awk program and the bash script will not modify your original file. Both of them reads from your file and prints 2nd & last column on standard output. If you want the output in a file, then you have to redirect it to a new file name.

BTW are you able to see the desired output on your screen while running the awk program or bash script?
# 10  
Old 01-18-2013
unfortunalety i donīt see any ouput. i tried do modify the awk command in the way that new outout file is generated but this file is empty. do you think it would be easier by using a linux os instead of mac os?
# 11  
Old 01-18-2013
I just borrowed a friend's mac. The awk program works there.

I bet your data is subtly different than what you showed.

Are there spaces at the beginning of the lines? That'd do it.
# 12  
Old 01-18-2013
i guess you are right...
i would upload the file but i donīt find a possibility to do it here.....
# 13  
Old 01-18-2013
It's there, look for 'manage attachments'.

You could also look at the file yourself and see.
# 14  
Old 01-18-2013
the text structure of the file is like this:

text
text (space) text....
number (space) number (space).....
text

you know what i mean?
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