Parsing a list


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Parsing a list
# 1  
Old 10-09-2013
Parsing a list

Hello,

I have a very long list of file (see input below). I only need the first "chunk" of the line before the space and omit the rest. Also, the > sign needs to be excluded. Can anyone help me please?

Thank you so much!

INPUT:
Code:
>gi|24976465|gb|AL935113.1|AL935113 AL935113 Homo sapiens library
>gi|24978364|gb|AL93981336.1|AL93981336 AL93981336 Homo sapiens library
>gi|24973415|gb|AL931542.1|AL931542 AL931542 Homo sapiens library
>gi|24939375|gb|AL93376241.1|AL93376241 AL93376241 Homo sapiens library
>gi|24937965|gb|AL9343716.1|AL9343716 AL9343716 Homo sapiens library

OUTPUT:
Code:
gi|24976465|gb|AL935113.1|AL935113
gi|24978364|gb|AL93981336.1|AL93981336
gi|24973415|gb|AL931542.1|AL931542
gi|24939375|gb|AL93376241.1|AL93376241
gi|24937965|gb|AL9343716.1|AL9343716


Last edited by Scott; 10-09-2013 at 06:51 PM.. Reason: Added Code Tags [6th time]
# 2  
Old 10-09-2013
If you used > and a space as field separators you could easily get what's in between:
Code:
$ awk -F"[> ]" '{print $2}' file
gi|24976465|gb|AL935113.1|AL935113
gi|24978364|gb|AL93981336.1|AL93981336
gi|24973415|gb|AL931542.1|AL931542
gi|24939375|gb|AL93376241.1|AL93376241
gi|24937965|gb|AL9343716.1|AL9343716

# 3  
Old 10-09-2013
if the input is in file y.y, then....
Code:
cat y.y | sed -e s'/^>//' | awk '{print $1}'

# 4  
Old 10-09-2013
Code:
sed 's#^>##;s# .*##' file

# 5  
Old 10-09-2013
Hi,
Another sed solution:
Code:
sed 's/^>\| .*//g' file

Or version maybe faster:
Code:
sed '/^>\| .*/s///g' file

Regards.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Parsing through a list of items

Hi there, Here is my checklist of items, 4.1.1 Alerter 4.1.2 Client Services for Netware 4.1.3 Clipbook 4.1.4 Fax Service 4.1.5 File Replication 4.1.6 File Services for Macintosh 4.1.7 FTP Publishing Service 4.1.8 Help and Support 4.1.9 HTTP SSL 4.1.10 IIS Admin Service ... (1 Reply)
Discussion started by: alvinoo
1 Replies

2. Shell Programming and Scripting

Parsing through list of files

I have a requirement where I need parse through files in a directory which have a specific pattern and then check whether the file has been processed or not. The exit condition is any file that has been processed will have an entry in database. If it is processed i.e., if an entry is present for... (4 Replies)
Discussion started by: abhilashnair
4 Replies

3. Shell Programming and Scripting

Process List Parsing?

Most of the code I've seen is been listing processes or capturing process ids, etc. But here's what I need to do. Preferably in Korn shell. 1. do a ps -ef |grep tns |grep -v grep in order to get a list or Oracle listeners that are running. 2. parse the line into components which... (7 Replies)
Discussion started by: MRMonteith
7 Replies

4. UNIX for Dummies Questions & Answers

Parsing a list of data

Hi I have a vcf file with 20000 lines, it looks like this- 23 122691 . C 1345.09 PASS 33 122961 . C 833.45 PASS 43 122970 . A 689.75 PASS 53 123009 . T 118.99 PASS 63 123033 . T 46.85 PASS 73 123042 . A 127.51 PASS 83 123060 . T 299.64 PASS 93 123081 . T 299.64 PASS... (3 Replies)
Discussion started by: baika
3 Replies

5. Shell Programming and Scripting

Parsing fields from class list files to use output with newusers command

Hello I am trying to develop a shell script that takes a text file such as this... E-mail@ Soc.Sec.No. *--------Name-----------* Class *School.Curriculum.Major.* Campus.Phone JCC2380 XXX-XX-XXXX CAREY, JULIE C JR-II BISS CPSC BS INFO TECH 412/779-9445 JAC1936 XXX-XX-XXXX... (7 Replies)
Discussion started by: crimputt
7 Replies

6. Shell Programming and Scripting

parsing a list with awk

Hi folks, I have a list of XML files with entries like this one: <Item Name="Author" Type="String">Stark F</Item> <Item Name="Author" Type="String">Pfannstiel J</Item> <Item Name="Author" Type="String">Klaiber I</Item> <Item Name="Author" Type="String">Raabe T</Item> and what I would like... (1 Reply)
Discussion started by: euval
1 Replies

7. Shell Programming and Scripting

Help with parsing mailbox folder list (identify similar folders)

List sample: user/xxx/Archives/2010 user/xxx/BLARG user/xxx/BlArG user/xxx/Burton user/xxx/DAY user/yyy/Trainees/Nutrition interns user/yyy/Trainees/Primary Care user/yyy/Trainees/Psychiatric NP interns user/yyy/Trainees/Psychiatric residents user/yyy/Trainees/Psychology... (4 Replies)
Discussion started by: spacegoose
4 Replies

8. Shell Programming and Scripting

Parsing the list in korn shell

Hi I wanted to print/store just a specific element of the list . I have got the list as an output of grep command. here is code snap below : end_no=`egrep -ni '!return code: 0|return code other than 0' temp.log | cut -d':' -f1` this will return the line numbers in end_no. I just... (2 Replies)
Discussion started by: Shell@korn
2 Replies

9. Shell Programming and Scripting

Parsing file list in variable

Hello, somewhere in a shell script, i am storing the output of "ls" into a variable. My question is how can i parse this variable to get each filepath. I don't want to create a temporary file to write down all the filenames and then parse it.. is there a easy way out.. here is what... (3 Replies)
Discussion started by: prasbala
3 Replies

10. Shell Programming and Scripting

Parsing of file for Report Generation (String parsing and splitting)

Hey guys, I have this file generated by me... i want to create some HTML output from it. The problem is that i am really confused about how do I go about reading the file. The file is in the following format: TID1 Name1 ATime=xx AResult=yyy AExpected=yyy BTime=xx BResult=yyy... (8 Replies)
Discussion started by: umar.shaikh
8 Replies
Login or Register to Ask a Question