extract string from XML file 1

[Draoued]

Hi

I m ashamed to post such question but I can not figure out how to do it.

I have a big XML file , with lots of tag.
One of the line contains this:

<reportViewSearchPath>CAMID("MYportal Security:u:authid=4184878700")/folder[@name='Blablabl bala']/reportView[@name='My report Test']</reportViewSearchPath>

What I want to do is to extract "My report Test" and replace the space by underscore , so the expected result is My_report_Test


the beginning of my script looks like this

grep 'reportView\[@name=' /usr/local/../xml/myfile.xml >temp.txt
cut -d']</reportViewSearchPath>' -f2 temp.txt >temp2.txt
Result=$(cut -d'@name=' -f2 temp2.txt)
echo $Result

It's really huggly, that's why I ask you for some hits.
I have the impression that it could be possible to do everything in one line, and not going through intermediate temp files.
I think there is also problems with the [ char in the xml file and it seems that my cut command does like.

 

[feherke]

Hi

If I understood you correcty :

sed "/@name=/{s/.*reportView\[@name='\([^']*\)'\].*//;y/ /_/;p}" myfile.xml

( Note : tested with GNU [tt]sed[/tt]. )

By the way, [tt]cut[/tt]'s delimiter must be a single character, so you can not use it that way.

Feherke.

http://rootshell.be/~feherke/

 

[Draoued]

thanks
I get an error Sed command cannot be parsed
and there are 2 @name strings in the line , would that be a problem ??

 

[feherke]

Hi

Is that a GNU [tt]sed[/tt] ? If not, just give up with the above code.

Feherke.

http://rootshell.be/~feherke/

 

[PHV]

something like this ?
Result=$(sed -n "s! !_!g;s!.*/reportView\[@name='\([^']*\)'.*!\1!p" /usr/local/../xml/myfile.xml)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[feherke]

Hi

If you have [tt]gawk[/tt] :

awk '/@name=/{s=gensub(/.*reportView\[@name='"'"'(.*)'"'"'\].*/,"\\1","");print gensub(/ /,"_","g",s)}' myfile.xml

Feherke.

http://rootshell.be/~feherke/

 

[Draoued]

Thanks PHV it works perfectly.
Now I have to read your command and trying to understand it.

Sorry Feherke, I don't know which sed I m running.