Click here to Skip to main content
15,880,967 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I am looking to get vbscript to load soap xml file from one of the table columns (CLOB type). In this xml, we are searching for ' character under a child tag within parent tags.
Below is structure:
soap:envelope/msg:payload/soi:formsubmitted/soi:form/soi:associatedactivity/soi:activity/ns5/dkcus/dkcomment/


Under <dkcomment> tag we are searching for ' character.
If it is present, delete the file else keep as it is.

Drawback here is we are updating vb script hence require vb script only for this. Dependency is with notepad++, VS 2013/15.
please suggest what IDE to use?

What I have tried:

I have tried using Visual Basic 2008.
Posted
Updated 19-Jan-17 0:06am
v2

1 solution

Use XPath / DOM for parsing XML in VBScript: XML Files - XML Tutorial - Microsoft XML Parser[^]

One very common way to extract XML elements from an XML document is to traverse the node three and extract the text value of each elements. A small snippet of programming code like a VBScript for/each construct can be written to demonstrate this.

The following VBScript code traverses an XML node tree, and displays the XML elements in the browser:
VB
set xmlDoc=CreateObject("Microsoft.XMLDOM")
xmlDoc.async="false"
xmlDoc.load("note.xml")

for each x in xmlDoc.documentElement.childNodes
  document.write(x.nodename)
  document.write(": ")
  document.write(x.text)
next
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900