XML field with different structure

[darie.leolea (Dean)]

Hello,

I have a problem when I try to accces elements of a XML file.

I need a way to extract the values for “start”, “end” and “level”, but the syntax is different.

Thanks in advance!

[Gokul001 (Gokul Balaji)]

Hi @darie.leolea

You can try with regex Expression

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=start\D+)\d+").ToString

Output -> 2004

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=end\D+)\d+").ToString

Output -> 2008

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=level\D+)\d+").ToString

Output -> 5

Regards
Gokul

[Gokul001 (Gokul Balaji)]

Another way to get the extracted data using Regex @darie.leolea

System.Text.RegularExpressions.Regex.Matches(YourString,"(?<!\s\D)\d+",System.Text.RegularExpressions.RegexOptions.Multiline)

Regards
Gokul

[Yoichi]

Hi,

Can you share your xml as a file?

Regards,