Extract XML DATA

[Shaik.Yezdani (Yezdani)]

Hi Team,

Can you please help me to get the “relatedOrderIds” from below XML string
attached XML dataXML2.txt (1.3 KB)

[prasath17 (Guru)]

Hi…@Shaik.Yezdani - Would like to use RegEx or XML Parsing?

[Shaik.Yezdani (Yezdani)]

@prasath17 anything is fine for me

[prasath17 (Guru)]

@Shaik.Yezdani - Here you go…

RegEx Pattern: RegEXPattern.txt (86 Bytes)

In the above screenshot, you can see the matched string at the bottom…

[Shaik.Yezdani (Yezdani)]

@prasath17 Thanks once again. But what if we have more than two id’s at one place

[prasath17 (Guru)]

@Shaik.Yezdani…that will also work, I have tested that before sending … please try that and let me know.

[prasath17 (Guru)]

@Shaik.Yezdani - I spoke too soon, above given pattern doesn’t work if its more than 2 ids…

Just change the middle pattern to : [0-9,\s]+

Explanation: This pattern would any digits from 0-9 comma and Space(\s) …

Update: Since there is an extra " inside the pattern…you have handle as shown below

Output: