Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

Extracting Lines in a file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Extracting Lines in a file
# 1  
Old 09-06-2010
Bug Extracting Lines in a file
Hi,

We have a file where we need to extract the lines of a file based on the first three characters of every line in that file.

Eg:
Code:
RAM hill station
SAM student
RAM rose
SAM apple
RAM india
SAM australia
RAM happy
RAM heaven
SAM smile
RAM glow

So, all the lines that start with RAM should go to one file and all lines that start with SAM should go to another file.

Is there any way to achieve this?

Thanks in advance..

SueSmilie

Moderator's Comments:
Mod Comment Having 23 posts you should be familiar using code tags, thanks.
Last edited by zaxxon; 09-06-2010 at 12:23 PM..
# 2  
Old 09-06-2010
Code:
$> awk '{ print > $1".out"}' infile
$> cat RAM.out
RAM hill station
RAM rose
RAM india
RAM happy
RAM heaven
RAM glow
$> cat SAM.out
SAM student
SAM apple
SAM australia
SAM smile

This User Gave Thanks to zaxxon For This Post:
johnbach
# 3  
Old 09-07-2010
Thank you.. We tried the following command and the output looks good..
Code:
grep ^RAM inputfile1.DAT > RAM.DAT
grep ^SAM inputfile1.DAT > SAM.DAT

Are there any implications using the above commands?

Thanks
Sue

Moderator's Comments:
Mod Comment Please do not ignore the warning for code tags and start using them, ty.
Last edited by zaxxon; 09-08-2010 at 08:52 AM..
# 4  
Old 09-08-2010
No, they are fine too.
This User Gave Thanks to zaxxon For This Post:
funksen
# 5  
Old 09-08-2010
Quote:
Originally Posted by zaxxon
Code:
$> awk '{ print > $1".out"}' infile
$> cat RAM.out
RAM hill station
RAM rose
RAM india
RAM happy
RAM heaven
RAM glow
$> cat SAM.out
SAM student
SAM apple
SAM australia
SAM smile

nice short solution!
# 6  
Old 09-08-2010
Yeah nice work there.
Good quick solution.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

extracting block of lines from a file

consider the input file which i am dealing with looks like this.. #cat 11.sql create table abc ( . . . ) engine=Innodb ; . . etc . . . create table UsM ( blah blah blah ) engine=Innodb ; (5 Replies)
Discussion started by: vivek d r
5 Replies

2. Shell Programming and Scripting

extracting lines from a file with similar first name

consider i have two files cat onlyviews1.sql CREATE VIEW V11 AS SELECT id, name, FROM etc etc WHERE etc etc; CREATE VIEW V22 AS SELECT id, name, FROM etc etc WHERE etc etc; CREATE VIEW V33 AS (10 Replies)
Discussion started by: vivek d r
10 Replies

3. Shell Programming and Scripting

Extracting specific lines of data from a file and related lines of data based on a grep value range?

Hi, I have one file, say file 1, that has data like below where 19900107 is the date, 19900107 12 144 129 0.7380047 19900108 12 168 129 0.3149017 19900109 12 192 129 3.2766666E-02 ... (3 Replies)
Discussion started by: Wynner
3 Replies

4. Shell Programming and Scripting

extracting specific lines from a file

hi all, i searched in unix.com and accquired the following commands for extracting specific lines from a file .. sed -n '16482,16482p' in.sql > out.sql awk 'NR>=10&&NR<=20' in.sql > out.sql.... these commands are working fine if i give the line numbers as such .. but if i pass a... (2 Replies)
Discussion started by: sais
2 Replies

5. Shell Programming and Scripting

Extracting lines in file based on time

Hi, anyone has any ideas on how do we extract lines from a file with format similiar to this: (based on current time) Jun 18 00:16:50 .......... ............. ............ Jun 18 00:17:59 .......... ............. ............ Jun 18 01:17:20 .......... ............. ............ Jun 18... (5 Replies)
Discussion started by: faelric
5 Replies

6. UNIX for Dummies Questions & Answers

extracting lines from a file

i want to extract lines 5 and 7 from a txt file which contains nearly 20 entries how to do it also i want to check whether the 42nd character is 'S' in that line suggestions welcome (4 Replies)
Discussion started by: trichyselva
4 Replies

7. Shell Programming and Scripting

extracting unique lines from text file

I have a file with 14million lines and I would like to extract all the unique lines from the file into another text file. For example: Contents of file1 happy sad smile happy funny sad I want to run a command against file one that only returns the unique lines (ie 1 line for happy... (3 Replies)
Discussion started by: soliberus
3 Replies

8. Shell Programming and Scripting

Extracting the lines between 2 strings of a file

Hi, I have a sql file and i need to extract the table names used in the sql file using a unix script. If i can extract the lines between the keywords 'FROM' and 'WHERE' in the file, my job is done. can somebody tell me how to do this using a shell script. If u can just let me know, how to... (2 Replies)
Discussion started by: babloo
2 Replies

9. Shell Programming and Scripting

extracting lines from a file

Hi all, I need to extract some lines from a file based on a condition. For ex: My file will contain 50 lines and i need to extract line which has "File" in it and then the line which has "date" in it. Which command will be the most efficient way to do it. I have tried two ways 1.... (1 Reply)
Discussion started by: pradeepthanraj
1 Replies

10. Shell Programming and Scripting

Help required regarding Extracting lines from a file

I have a file containing the following contents All of us, including Zippy, our dog All of us, including Zippy and Zippy All of us, including Zippy and Zippy and Zelda Testing All of us Zippy Now, i wanna grep and get the lines which has only one occurance of word Zippy and starting with... (1 Reply)
Discussion started by: google_ever
1 Replies
Login or Register to Ask a Question