Scrape Text File Smart

[Slipk]

Hello everyone,

expandcollapse popup

#include <GUIConstantsEx.au3>
#include <GUIListBox.au3>
#include <WindowsConstants.au3>

#cs

    FILE DATA :

    <name>John</name>
    <random>Hello</random>
    <name>Silly</name>
    <other>Test</other>
    <other>World</other>
    <name>Billy</name>

#ce

Local $file = "file.txt"

$Form1 = GUICreate("Get items from text", 360, 250, -1, -1)
$List1 = GUICtrlCreateList("", 8, 8, 160, 235, -1, 0)

_getitems()

GUISetState(@SW_SHOW, $Form1)

While 1
    $nMsg = GUIGetMsg()
    Switch $nMsg
        Case $GUI_EVENT_CLOSE
            Exit

    EndSwitch
WEnd

Func _getitems()
EndFunc   ;==>_getitems

 

I have the code above and I try to figure out the next one :

It must read a text file with fields like in example below.

<name>John</name>
<random>Hello</random>
<name>Silly</name>
<other>Test</other>
<other>World</other>
<name>Billy</name>

How to add into list only what is between <name>*</name>, something like a wildcard tried to applied but not working.

Any suggestions?

Thank you!

Edited January 29, 2019 by Slipk

[JLogan3o13]

@Slipk there are a number of ways to accomplish this. I would suggest taking a look at _StringBetween in the help file, as it is a pretty straight-forward path to what you want.

[Slipk]

Thank you!

I will take a look and come back.

[FrancescoDiMuro]

@Slipk

You can use SRE too:

#include <Array.au3>
#include <StringConstants.au3>

Global $strString = "<name>John</name>" & @CRLF & _
                    "<random>Hello</random>" & @CRLF & _
                    "<name>Silly</name>" & @CRLF & _
                    "<other>Test</other>" & @CRLF & _
                    "<other>World</other>" & @CRLF & _
                    "<name>Billy</name>", _
       $arrResult
       
$arrResult = StringRegExp($strString, "(?m)^(?:<[^>]+>)([^<]*)(?:<\/[^>]+>)$", $STR_REGEXPARRAYGLOBALMATCH)

_ArrayDisplay($arrResult)

Edited January 30, 2019 by FrancescoDiMuro

[Slipk]

Hello Francesco,

Thank you for your answer.

This is how I want to extract but it's one problem that makes the difference.

It has to extract only what it's between <name></name>

And I don't know the other data from the text it could be random text, something like scrape but for some text files.

 

I tried but no results.

[FrancescoDiMuro]

@Slipk
Just change the SRE pattern in this way:

#include <Array.au3>
#include <StringConstants.au3>

Global $strString = "<name>John</name>" & @CRLF & _
                    "<random>Hello</random>" & @CRLF & _
                    "<name>Silly</name>" & @CRLF & _
                    "<other>Test</other>" & @CRLF & _
                    "<other>World</other>" & @CRLF & _
                    "<name>Billy</name>", _
       $arrResult


$arrResult = StringRegExp($strString, "(?m)^(?:<name>)([^<]*)(?:</name>)$", $STR_REGEXPARRAYGLOBALMATCH)

_ArrayDisplay($arrResult)

[mikell]

FrancescoDiMuro,
It could be done simpler :   "<name>([^<]+)</name>" 

[FrancescoDiMuro]

@mikell
Yes, thanks
I overused non-capturing group, and I didn't remove the ^ $ anchors since I was testing the pattern on a single line string.

Edited January 30, 2019 by FrancescoDiMuro

[jdelaney]

I'd use microsoft.xmldom (do a search on this forum), and xpaths to parse out my specific node.   assuming your file is a proper syntax xml document