Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

with vimgrep - or other vim possibility - how can i get groups of data out of a file ?

Posted on 2015-01-13
4
Medium Priority
?
146 Views
Last Modified: 2015-01-14
Hello every one.

I'm trying to do a vimgrep on a file in order to get only two attributs with their values out of the xml file.
so far i can get the complete lines  and i'd like with the help of groups to have a better display.

:vimgrep key= % | copen

^ I'd like to add to this command the grouping possibility with "\(  \)" ....but without success for the moment.

i'd appreciate your help in order to have a result as explained in the "result  expected"






part of the file that I'm working with :
.....................................................................................................................................................
 <policy name="Menu_Controls" class="User" displayName="$(string.Menu_Controls)" explainText="$(string.IE_ExplainMenu_Controls)" presentation="$(presentation.Menu_Controls)" key="Software\Policies\Microsoft\Windows\CurrentVersion\Internet Settings\AllowedControls">
      <parentCategory ref="AdminApproved" />
      <supportedOn ref="SUPPORTED_IE5" />
      <elements>
        <boolean id="MCSiMenu" valueName="{275E2FE0-7486-11D0-89D6-00A0C90C9B67}">
          <trueValue>
            <decimal value="0" />
          </trueValue>
          <falseValue>
            <decimal value="1" />
          </falseValue>
        </boolean>
        <boolean id="PopupMenu_Object" valueName="{7823A620-9DD9-11CF-A662-00AA00C066D2}">
          <trueValue>
            <decimal value="0" />
          </trueValue>
          <falseValue>
            <decimal value="1" />
          </falseValue>
        </boolean>
        <boolean id="Ikonic_Control" valueName="{F5131C24-E56D-11CF-B78A-444553540000}">
          <trueValue>
            <decimal value="0" />
          </trueValue>
          <falseValue>
            <decimal value="1" />
          </falseValue>
        </boolean>
      </elements>
    </policy>
    <policy name="Microsoft_Agent" class="User" displayName="$(string.Microsoft_Agent)" explainText="$(string.IE_Explain_Microsoft_Agent)" presentation="$(presentation.Microsoft_Agent)" key="Software\Policies\Microsoft\Windows\CurrentVersion\Internet Settings\AllowedControls">
      <parentCategory ref="AdminApproved" />
      <supportedOn ref="SUPPORTED_IE5" />
      <elements>
        <boolean id="Microsoft_Agent_Control" valueName="{D45FD31B-5C6E-11D1-9EC1-00C04FD7081F}">
          <trueValue>
            <decimal value="0" />
          </trueValue>
          <falseValue>
            <decimal value="1" />
          </falseValue>
        </boolean>
      </elements>
    </policy>
.....................................................................................................................................................



my expected result :
.....................................................................................................................................................
 name="Menu_Controls"  key="Software\Policies\Microsoft\Windows\CurrentVersion\Internet Settings\AllowedControls"
 name="Microsoft_Agent" key="Software\Policies\Microsoft\Windows\CurrentVersion\Internet Settings\AllowedControls"
......
.....................................................................................................................................................
0
Comment
Question by:toshi_
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 23

Expert Comment

by:savone
ID: 40548209
Here is how I would do it with bash:

#!/bin/bash
while read line
	do name=$(echo $line | grep -oP 'name=[^"]*"\K[^"]*')
	key=$(echo $line | grep -oP 'key=[^"]*"\K[^"]*')
	if [ -z "${name}" ]; then
		continue	
	fi
        echo "name=\"$name\" key=\"$key\""
done < file

Open in new window


Here is the output I received:

# ./do
name="Menu_Controls" key="SoftwarePoliciesMicrosoftWindowsCurrentVersionInternet SettingsAllowedControls"
name="Microsoft_Agent" key="SoftwarePoliciesMicrosoftWindowsCurrentVersionInternet SettingsAllowedControls"
0
 
LVL 23

Expert Comment

by:savone
ID: 40548212
I just noticed it stripped the \ out of the keys.... hmmmm....
0
 
LVL 23

Accepted Solution

by:
savone earned 2000 total points
ID: 40548218
Ahh, it seems echo was stripping the backslashes... This works better.

#!/bin/bash
while read -r line
	do name=$(echo $line | grep -oP 'name=[^"]*"\K[^"]*')
	key=$(echo $line | grep -oP 'key=[^"]*"\K[^"]*')
	if [ -z "${name}" ]; then
		continue	
	fi
echo name=\""${name}"\" key=\""${key}"\"
done < file

Open in new window


Output is now:
name="Menu_Controls" key="Software\Policies\Microsoft\Windows\CurrentVersion\Internet Settings\AllowedControls"
name="Microsoft_Agent" key="Software\Policies\Microsoft\Windows\CurrentVersion\Internet Settings\AllowedControls"
0
 

Author Comment

by:toshi_
ID: 40548379
thanks a lot for your help.
wonderful

toshi
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Over the last ten+ years I have seen Linux configuration tools come and go. In the early days there was the tried-and-true, all-powerful linuxconf that many thought would remain the one and only Linux configuration tool until the end of times. Well,…
Fine Tune your automatic Updates for Ubuntu / Debian
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Suggested Courses

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question