Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Problem parsing

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Problem parsing
# 1  
Old 05-17-2014
Problem parsing
Hi,

I want to fetch a text.Clipping.

Code:
{version='1encoding='UTF-8'?><!DOCTYPExmeml><xversion='4'i='2C360C00115905800800460202155173'><name>C0001</name><duration>184</duration><rate><ntsc>FALSE</ntsc><timebase>25</timebase></rate><labels><label2></label2></labels><comments><mastercomment1></mastercomment1><mastercomment2>En-montage</mastercomment2><clipcommenta></clipcommenta><clipcommentb></clipcommentb></comments><logginginfo><lognote></lognote><description></description><scene>rugby-fabien-galtier-pour-tous-le-sport</scene><shottake>2011-12-1608:53:32</shottake><scenenote>FJean-philipJri</scenenote></logginginfo><fileid='2C360C00115905800800460202155173_file'><name>C0001</name><pathurl>file://localhost/Volumes/intermediation/4D760F00085905C12202080046020125/Clip/C0001MXF</pathurl><duration>184</duration></file></clip><cl='F3900D00115905800800460202154F6F'><name>C0001</name><duration>50</duration><rate><ntsc>FALSE</ntsc><timebase>25</timebase></rate><labels><label2></label2></labels><comments><mastercomment1></mastercomment1><mastercomment2>En-montage</mastercomment2><clipcommenta></clipcommenta><clipcommentb></clipcommentb></comments><logginginfo><lognote></lognote><description>Presse-Bouton-B-point-de-Tugny</description><scene>Disparition-KADA</scene><shottake>2011-12-09:52:45</shottake><scenenote>RENARDAurelieJournaliste-redactrice</scenenote></logginginfo><fileid='F3900D00115905800800460202154F6F_file'><name>C0001</name><pathurl>file://localhost/Volumes/intermediation/72A11400105905C12202080046020125/Clip/C0001MXF</pathurl><duration>50</duration></file></clip><cli='81C31000115905800800460202155176'><name>C0001</name><duration>586</duration><rate><ntsc>FALSE</ntsc><timebase>25</timebase></rate><labels><label2></label2></labels><comments><mastercomment1>BRI</mastercomment1><mastercomment2>En-montage</mastercomment2><clipcommenta></clipcommenta><clipcommentb></clipcommentb></comments><logginginfo><lognote></lognote><description></description><scene>musee-du-moulages</scene><shottake>2011-12-1612:12:25</shottake><scenenote>ACa/Redacteur</scenenote></logginginfo><filid='81C31000115905800800460202155176_file'><name>C0001</name><pathurl>file://localhost/Volumes/intermediation/C2EF1B00875805C20111216164346692/Clip/C0001MXF</pathurl><duration>586</duration></file></clip><importoptions><createnewproject>FALSE</createnewproject></importoptions></xmeml>};{utxtustl

i have the "file" in one line, i want all occurrences

Code:
4D760F00085905C12202080046020125/Clip/C0001MXF
72A11400105905C12202080046020125/Clip/C0001MXF
C2EF1B00875805C20111216164346692/Clip/C0001MXF

I try with awk but i don't know how to use the function substr, i try but without success

THX
# 2  
Old 05-17-2014
hi,
maybe can try sed instead of awk Smilie

Code:
# sed 's|intermediation/|\n|g' input.text|sed -n 's|^\([^ ]*/[^ ]*/[^ ]*\)</pathurl>.*|\1|p;'
4D760F00085905C12202080046020125/Clip/C0001MXF
72A11400105905C12202080046020125/Clip/C0001MXF
C2EF1B00875805C20111216164346692/Clip/C0001MXF

regards
ygemici
# 3  
Old 05-17-2014
Quote:
Originally Posted by ygemici
hi,
maybe can try sed instead of awk Smilie

Code:
# sed 's|intermediation/|\n|g' input.text|sed -n 's|^\([^ ]*/[^ ]*/[^ ]*\)</pathurl>.*|\1|p;'
4D760F00085905C12202080046020125/Clip/C0001MXF
72A11400105905C12202080046020125/Clip/C0001MXF
C2EF1B00875805C20111216164346692/Clip/C0001MXF

regards
ygemici
Thanks for your answer, but the first command sed don't substitute "intermediation" with a newline
My shell is bash and my OS is OSX
# 4  
Old 05-17-2014
Quote:
Originally Posted by protocomm
Thanks for your answer, but the first command sed don't substitute "intermediation" with a newline
My shell is bash and my OS is OSX
then try like this
Code:
sed 's/intermediation\//\'$'\n/g' input.text

This User Gave Thanks to ygemici For This Post:
protocomm
# 5  
Old 05-17-2014
With OS X's BSD Sed try this:
Code:
sed 's|intermediation/|\
 |g' input.text |sed -n 's|^\([^ ]*/[^ ]*/[^ ]*\)</pathurl>.*|\1|p;'

# 6  
Old 05-17-2014
Quote:
Originally Posted by ygemici
then try like this
Code:
sed 's/intermediation\//\'$'\n/g' input.text

excellent, it's works thx.

I've tried so:
Code:
awk '{gsub(/intermediation/,"\n",$0);print}'

it's work so.

anyway you have found the trick, i have don't thank to substitute the string intermediation by a newline.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk parsing problem

Hello fellow unix geeks, I am having a small dilemna trying to parse a log file I have. Below is a sample of what it will look like: MY_TOKEN1(group) TOKEN(other)|SSID1 MY_TOKEN2(group, group2)|SSID2 What I need to do is only keep the MY_TOKEN pieces and where there are multiple... (7 Replies)
Discussion started by: dagamier
7 Replies

2. Shell Programming and Scripting

Problem parsing args

Heya Tooltip: Parsing (getopts) for -u successfully sets mode=umnt, but case umnt is not executed, instead it either executes/show help or regular mount screen. I had copy pasted the structure of a getopts 'structure' from Man Page for getopts (posix Section 1) - The UNIX and Linux Forums... (1 Reply)
Discussion started by: sea
1 Replies

3. Shell Programming and Scripting

Parsing problem

Hello, I have a similar problem so I continue this thread. I have: my_script_to_format_nicely_bdf.sh | grep "RawData" |tr -s ' '|cut -d' ' -f 4|tr -d '%' So it supposed to return the percentage used of RawData FS: 80 (Want to use it in a alert script) However I also have a RawData2 FS so... (17 Replies)
Discussion started by: drbiloukos
17 Replies

4. Shell Programming and Scripting

Parsing Problem

Hi all, I am having problems parsing the following file: cat mylist one,two,three four five,six My goal is to get each number on a seperate line. one two three four five six I tried this command: sed -e 's/\,/^M/g' mylist (11 Replies)
Discussion started by: rob11g
11 Replies

5. Shell Programming and Scripting

Parsing textfile problem with cut

Hi, I have a textfile with several lines like this: text num: USER text (num) num num I need all these stuff. Problem is, how to get these stuff after ":". USER is a username and all chars are possible, even whitespace. So I cant use cut. Any ideas? (3 Replies)
Discussion started by: mcW
3 Replies

6. Shell Programming and Scripting

Parsing problem

I need to parse a string which looks like "xyx","sdfsdf","asf_asdf" into var1="xyx" var2="sdfsdf" var3="asf_asdf" (3 Replies)
Discussion started by: Sushir03
3 Replies

7. Shell Programming and Scripting

Parsing problem

Hi, i need to parse a string which looks like this "xyz","1233","cm_asdfasdf" (2 Replies)
Discussion started by: Sushir03
2 Replies

8. Shell Programming and Scripting

Parsing problem

I need to separate out the contents in the string "xyz","1233","cm_asdfasdf" as xyz,1233,cm_asdfasdf Can anyone help me on this?? (1 Reply)
Discussion started by: Sushir03
1 Replies

9. Shell Programming and Scripting

awk parsing problem

I need help with a problem that I have not been able to figure out. I have a file that is about 650K lines. Records are seperated by blank lines, fields seperated by new lines. I was trying to make a report that would add up 2 fields and associate them with a CP. example output would be... (11 Replies)
Discussion started by: timj123
11 Replies

10. Shell Programming and Scripting

parsing problem with script

I'm trying to parse the variables out of a comma delimited expression, but i'm having trouble with script: num_var=1 while do a=`echo "a=7, b=8, c=9" | awk '{print $num_var}' | cut -d= -f2` b=`echo $a | cut -d, -f1` echo $b num_var=`expr $num_var + 1`... (5 Replies)
Discussion started by: mike@freddiemac
5 Replies
Login or Register to Ask a Question