Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

parsing a list with awk

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting parsing a list with awk
# 1  
Old 05-16-2011
parsing a list with awk
Hi folks,

I have a list of XML files with entries like this one:
Code:
<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 to have is this:
Code:
Stark F, Pfannstiel J, Klaiber I & Raabe T

I'm sure this can be done with somw sort of for or while loop and awk but my attempts do not give the required result, especially when it comes to treating the last entry differently

many thanks in advance for all your help!
# 2  
Old 05-16-2011
Code:
sed 's/<[^>]*>//g' infile.xml | paste -sd, -

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

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: >gi|24976465|gb|AL935113.1|AL935113 AL935113 Homo sapiens... (4 Replies)
Discussion started by: narachaid
4 Replies

4. Shell Programming and Scripting

Parsing help ( awk)

Input File ( this is a sample record ) Storage Group Name: DRT_ny-iadsql1-c_ny-iadsql2-c Storage Group UID: 00:21:E9:C7:2D:E0:E1:11:82:CC:00:60:16:10:04:0A HBA/SP Pairs: HBA UID SP Name SPPort ------- ... (2 Replies)
Discussion started by: greycells
2 Replies

5. 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

6. 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

7. 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

8. 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

9. 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

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