Extract matches

[tomaz (Tomaz Seserko)]

Hello, i Have XML File that I Read into string. I need To extract two results that are between and . So result should be 1588.48 and 40824.17.

4 1588.48 33 40824.17

[postwick (Paul)]

Use Deserialize XML activity to get it into a proper XML object then you can reference the XML properties to get the values out.

[raja.arslankhan]

@tomaz Do you want to get through regex?

[tomaz (Tomaz Seserko)]

Yes, I would be veary happy with regex expresion

[raja.arslankhan]

@tomaz

(\d+.\d+)

[tomaz (Tomaz Seserko)]

This is example file:

TxsSummry
TtlCdtNtries
NbOfNtries>4</NbOfNtries
Sum>1588.48</Sum
/TtlCdtNtries
TtlDbtNtries
NbOfNtries>33</NbOfNtries
Sum>40824.17</Sum
/TtlDbtNtries
/TxsSummry

[raja.arslankhan]

@tomaz
Try this one

[Parvathy (PS Parvathy)]

Hi @tomaz

If you trying to extract both the values using single regex go with the below expression:

[\d]+\.+[\d]+

Shared the workflow for reference
Sequence1.xaml (10.8 KB)

Hope it helps!!
Regards,

[mkankatala (Mahesh Kankatala)]

Hi @tomaz

You can use the below regex expressions which will give your required output.
For extracting 4 1588.48 33 40824.17

System.Text.RegularExpressions.Regex.Matches(yourstringinput.ToString,“((?<=\>)\d+\.*\d*(?=\<))”)

For extracting only 1588.48 40824.17

System.Text.RegularExpressions.Regex.Matches(yourstringinput.ToString,“((?<=\>)\d+\.\d*(?=\<))”)

Hope it helps!!

[vrdabberu (Varunraj)]

Hi @tomaz

Try the below regex expression

\d+\.\d*

Hope it works !!