Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

getting parts of a file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting getting parts of a file
# 1  
Old 10-07-2006
getting parts of a file
Hello, I'm trying to retreive certain bits of info from a file.

the file contains a list like this
info1:info2:info3:info4
info1:info2:info3:info4
info1:info2:info3:info4
info1:info2:info3:info4

how do i pick out only info2 or only info3 without the others?

Thanks
# 2  
Old 10-07-2006
Lots of ways:

Code:
awk -F":" '{print $1}' file

Code:
cut -d':' -f1 file

Just pick the field you'd like to print ( i.e. $1, $2, or -f1 -f2).
# 3  
Old 10-07-2006
hey thanks, one more question though. How do i tell it to keep doing this until the end of the file? Im going to make a while loop, but what would i put for the loop.

thanks
# 4  
Old 10-07-2006
You can do something like that :
Code:
cut -d':' -f1 file |
while read field
do
    echo "Input field: $field"
done

If can also do all the work with the shell (KSH) :
Code:
 while FS=: read field1 field2 other_fields
do
   echo "Field1: $field1"
   echo "Field2: $Field2"
done


Jean-Pierre.
# 5  
Old 10-07-2006
I just want to make sure i understand these correct. Does it take the first line and process it, then go back to the beginning and process line two and then go back and so on and so on? Or does it do it for all the lines at the same time?
# 6  
Old 10-07-2006
Well, either of the two commands I gave will will work on the entire file. I don't see any reason why you'd need a loop just to print your chosen field.
# 7  
Old 10-07-2006
Quote:
Originally Posted by bebop1111116
hey thanks, one more question though. How do i tell it to keep doing this until the end of the file? Im going to make a while loop, but what would i put for the loop.

thanks
Python alternative:
Code:
for lines in open("input.txt"):
 	lines = lines.strip().split(":")
 	print "Info 2 , second column: " , lines[1]
 	print "Info 3 , third column: " , lines[2]
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Split file into n parts.

Hi all: I have a 5-column tab-separated file. The only thing that I want to do with it is to split it. However, I want to split it with a 80/20 proportion -- randomized, if possible. I know that something like : awk '{print $0 ""> "file" NR}' RS='' input-file will work, but it only... (6 Replies)
Discussion started by: owwow14
6 Replies

2. Shell Programming and Scripting

Incrementing parts of ten digits number by parts

I have number in file which contains date and serial number: 2013101000. The last two digits are serial number (00). So maximum of serial number is 100. After reaching 100 it becomes 00 with incrementing 10 which is day with max 31. after reaching 31 it becomes 00 and increments 10... (31 Replies)
Discussion started by: Natalie
31 Replies

3. Shell Programming and Scripting

Combine two parts of a file

Hello All, I have a file like this APPLY ( 'INSERT INTO brdcst_media_cntnt ( cntnt_id ,brdcst_media_cntnt_cd ,cntnt_prvdr_cd ,data_src_type_cd ,cntnt_titl_nm ,cntnt_desc ,batch_dt ,batch_id ) VALUES ( :cntnt_id (3 Replies)
Discussion started by: nnani
3 Replies

4. Shell Programming and Scripting

Extract Parts of File

Hello All, I have a file like this Define schema flat_file_schema ( a varchar(20) ,b varchar(30) ,c varchar(40) ); (Insert into table ( a ,b ,c ) values ( 1 ,2 ,3 ); (4 Replies)
Discussion started by: nnani
4 Replies

5. UNIX for Dummies Questions & Answers

Help with deleting some parts from text file

Hi all, I have a fat file which contains something like this: ************************************************ blahblahblah blahblahblah Myobject1 HOME ( homecontents01 ( some junk; ) home contents02( some junk; ) ... (7 Replies)
Discussion started by: newboy
7 Replies

6. Shell Programming and Scripting

awk printing only parts of file

I am afraid I don't understand awk well enough to do the following. I have a file with a bunch of select statements where the a line starts off with this pattern: "Last parsed SQL statement :", then continues with the select statement. At the first blank space I'd like it to stop, print that... (5 Replies)
Discussion started by: fwellers
5 Replies

7. Shell Programming and Scripting

extract certain parts from a file

I have a logfile from which i need to extract certain pattern based on the time but the problem here is the time is not same for all days. Input file: Mon 12:34:56 abvjingjgg Mon 12:34:57 ofjhjgjhgh . . . Mon 22:30:00 kkfng . . . Mon 23:12:23 kjgsdafhkljf . . . Tue 01:04:54... (8 Replies)
Discussion started by: gpk_newbie
8 Replies

8. UNIX for Dummies Questions & Answers

How to swap parts of a file name?

I have a number of files that a structured like this: Eg. file_name.ext1 another file name with spaces.ext2 yatf with .ext3 also a file (plus).ext4 I would like to swap the part with the descriptive_file_name part, so that it looks like this: Eg. file_name .ext1 I know (or... (4 Replies)
Discussion started by: invenio
4 Replies

9. Shell Programming and Scripting

Extracting parts of a file.

Hello, I have a XML file as below and i would like to extract all the lines between <JOB & </JOB> for every such occurance. The number of lines between them is not fixed. Anyways to do this awk? ============ <JOB APR="1" AUG="1" DEC="1" FEB="1" JAN="1" JUL="1" JUN="1" MAR="1" MAY="1"... (3 Replies)
Discussion started by: srivat79
3 Replies

10. UNIX for Dummies Questions & Answers

cksum parts of a file

Every time we build an executable the date and time are put into the file, I need to run checksum on just the working lines.(IE, no header files) Is this even possible, if so how would I go about it? I am using a HP-UX server any help you can give me will be greatly appreciated. Thanks (6 Replies)
Discussion started by: crazykelso
6 Replies
Login or Register to Ask a Question