Hi,
I have a XML message from which I need to extract one field.
I need to extract the number 212121212 from the following string which is towards the middle of the full xml message: <pacs:CdtrAcct><pacs:Id><pacs:Othr><pacs:Id>212121212</pacs:Id></pacs:Othr></pacs:Id></pacs:CdtrAcct>
I have tried xml parse but that doesn't seem to work. I've used a regex parse (attached) which seems to split the full field into 3 parts from where I was hoping to further extract the digits as mentioned above. However, I've had no success so far.
Can anyone give me any advice on how I can extract that number?
Thanks
Hi, @hasithg
FYI.
(?<=<pacs\:CdtrAcct><pacs:Id><pacs:Othr><pacs:Id>)(\d+?)(?=<\/pacs:Id><\/pacs:Othr><\/pacs:Id><\/pacs:CdtrAcct>)
That worked!!! Thanks flying008!!!
Hi, @hasithg
If can help get your want, please mark it as a solution and give a like for more share.