How to delete values from xml in NOTEPAD++

notepadxml

I have a large xml that has the below structure:

            <subform name="PRE_EC02_S1A">
                <field name="RIGA07">R7</field>
                <field name="RIGA08">R8</field>
                <field name="IMPOR20">I20</field>
                <field name="IMPOR21">I21</field>
                <field name="IMPOR22">I22</field>
                <field name="IMPOR23">I23</field>
                <field name="IMPOR24">I24</field>
                <field name="IMPOR25">I25</field>
                <field name="IMPOR26">I26</field>
                <field name="IMPOR27">I27</field>
                <field name="IMPOR28">I28</field>
            </subform>

I need to delete all the values from all of the fields. I can do it manually but as the document is very large it will take a lot of time. I would like to know if there is a way to delete them automatically. For example: I need deleted all the values like R7, R8, I20, I21 and so on

Thank you very much in advance.

Best Answer

I have tested this with the sample you provided and it works in Notepad++. Open the replace dialog (Ctrl+H) and select at the bottom "Regular expressions". Then type the following: ([\>]).*([\<]) Replace with: \1\2

Edit: If you happen to have other xml tags with text inside you do not want to delete, if you want to empty only the field tags, then search for the following:

([\<]field name[\=\"].*[\"\>]).*([\<]\/field[\>])

Replace again with \1\2

Related Solutions

How to modify/create values in XML files using PowerShell

PowerShell fully supports dealing with XML files.

For example, if we take the first blurb you supplied and just paste it into an XML file named settings.xml in folder "C:\blah", you could get the ID of each setting as such:

[xml]$myXML = Get-Content C:\blah\settings.xml
$myXML.settings.setting.id

Which returns:

Location2
Location2id

And

$myXML.settings.setting.value

returns:

Barcelona, Spain
zmw:00000.1.08181

If we replace the XML file contents with the blurb you provided in Syntax #2:

[xml]$myXML = Get-Content C:\blah\settings.xml
$myXML.settings.musicplayer.crossfade

returns:

To read crossfade, change it (to 2), and save back:

[xml]$myXML = Get-Content C:\blah\settings.xml
$myXML.settings.musicplayer.crossfade = 2
$myXML.Save("C:\blah\settings.xml")

Edit after comments:

To change the XML elements themselves (as in the Barcelona example) is a little trickier, because you're editing the XML structure itself, not the data it contains.

[xml]$myXML = Get-Content C:\blah\settings.xml
$myXML.settings.ChildNodes.Item(0).value = "New York, USA"
$myXML.Save("C:\blah\settings.xml")

For the Skinsettings example, try something like:

$myXML.settings.skinsettings.setting."#text" = "true"

Check out these resources:

Notepad++ – How to remove everything after the last backslash “\” on a line in a text file

You can use a RegEx capture group (denoted by the round brackets) to capture all characters (.*) up to (and including) the slash (\\ - you need to 'escape' the slash with another slash), and also include the rest of the characters in the Regex match (the second .*), since we want to replace them as well.

Then Replace the whole line with the contents of (just) that capture group (\1).

So this works for me:

Find: (.*\\).*

Replace with: \1

Make sure ". matches new line" is disabled.

Best Answer

Related Solutions

How to modify/create values in XML files using PowerShell

Notepad++ – How to remove everything after the last backslash “\” on a line in a text file

Related Question