vbscript - Find and replace words in XML string -


i have string xml content, has configurations required execute test script.

$sub_send, $country_code, $domain read config file.

<provisioning xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"><request><header><command>create</command><entityidentifiers><identifier type="telephonenumber" value="$sub_send"/></entityidentifiers><entityname>subscriber</entityname></header><data><subscriber><!--<rcvmaxmmsmsgsize>53</rcvmaxmmsmsgsize>--><operatorcode>54</operatorcode><sendautoreply>0</sendautoreply><copyreceivedmessagesenabled>0</copyreceivedmessagesenabled><requestmmsdeliveryreport>1</requestmmsdeliveryreport><copysentmessagesenabled>0</copysentmessagesenabled><sendmmstombx>0</sendmmstombx><addsignature>0</addsignature><subscribercosname>standard mms</subscribercosname><!--<sendmmsmaxattachnum>50</sendmmsmaxattachnum>--><!--<sendmmsmaxrcptnum>51</sendmmsmaxrcptnum>--><!--<handsettype>legacyphone</handsettype>--><subscriberdomainname>$domain</subscriberdomainname><autoprovindication>1</autoprovindication><!--<sendmaxmmsmsgsize>52</sendmaxmmsmsgsize>--><mmsusertype>none</mmsusertype><bwlistinuse>none</bwlistinuse><allowmmsdeliveryreport>1</allowmmsdeliveryreport><!--<billingtype>prepaid</billingtype>--><countrycode>**$country_code**</countrycode><subscribername>$sub_send</subscribername></subscriber></data></request></provisioning>

now need read each line , find occurrence of words beginning $ , replace config file. how can words beginning $ in vbscript?

if can treat .xml plain ascii text, use regexp replace function , dictionary data: 

option explicit  ' path src file const p = "e:\work\proj\soa\tmp\45371693.xml"  dim s : s = createobject("scripting.filesystemobject").opentextfile(p).readall()  ' regexp find $ + seq of alphas or _ dim r : set r = new regexp r.global = true r.pattern = "\$[a-z_]+"  ' find/replace pairs in dictionary dim d : set d = createobject("scripting.dictionary") d("$sub_send") = "abra" d("$domain") = "cada" d("$country_code") = "bra"  ' regexp replace using function f s = r.replace(s, getref("f"))  wscript.echo s  wscript.quit 0  ' replace found $x d($x) function f(m, p, s)   if d.exists(m) m = d(m)   f = m end function

output:

cscript 45371693-2.vbs <provisioning xmlns:xsi="http://www.w3.org/2001/xmlschema-instance">         <request>                 <header>                         <command>create</command>                         <entityidentifiers>                                 <identifier type="telephonenumber" value="abra"/>                         </entityidentifiers>                         <entityname>subscriber</entityname>                 </header>                 <data>                         <subscriber>                                 <!--<rcvmaxmmsmsgsize>53</rcvmaxmmsmsgsize>-->                                 <operatorcode>54</operatorcode>                                 <sendautoreply>0</sendautoreply>                                 <copyreceivedmessagesenabled>0</copyreceivedmessagesenabled>                                 <requestmmsdeliveryreport>1</requestmmsdeliveryreport>                                 <copysentmessagesenabled>0</copysentmessagesenabled>                                 <sendmmstombx>0</sendmmstombx>                                 <addsignature>0</addsignature>                                 <subscribercosname>standard mms</subscribercosname>                                 <!--<sendmmsmaxattachnum>50</sendmmsmaxattachnum>-->                                 <!--<sendmmsmaxrcptnum>51</sendmmsmaxrcptnum>-->                                 <!--<handsettype>legacyphone</handsettype>-->                                 <subscriberdomainname>cada</subscriberdomainname>                                 <autoprovindication>1</autoprovindication>                                 <!--<sendmaxmmsmsgsize>52</sendmaxmmsmsgsize>-->                                 <mmsusertype>none</mmsusertype>                                 <bwlistinuse>none</bwlistinuse>                                 <allowmmsdeliveryreport>1</allowmmsdeliveryreport>                                 <!--<billingtype>prepaid</billingtype>-->                                 <countrycode>**bra**</countrycode>                                 <subscribername>abra</subscribername>                         </subscriber>                 </data>         </request> </provisioning>

Comments

Post a Comment

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

i've set bento/ubuntu-16.04 vagrant box using php 5.6, , getting following error quite few times when try , run shell script: "uncaught reflection exception: class domdocument not exist". i've tried adding following top of script (not together), each no success: "sudo apt-get install php5.6-xml", "sudo apt-get install php5-xml", "sudo apt-get install php-dom" i've tried resetting server "sudo service apache2 restart". does have suggestions?
Read more

vue.js - Create hooks for automated testing -

Image
qa guys complained can't automate frontend testing. because our html looks same outside. lazy hack did this <template> <div :role="$options.name"> ... </div> </template> <script> export default { name: 'vmcomponentname' } </script> which takes name script , applies html. in browser get: <div role="vmcomponentname"> ... </div> line :role="$options.name" goes in every component. is there dry er solutions? please share. additional details i'll explain in details looking for. imagine have vmusercreate form creates user. test case can create user . to automatically test without role, have use following selector: .wrapper > .wrapper > .wrapper > .submit-button the test extremely brittle (will break lot). if use roles can use [role="vmusercreateform"] .submit-button selector. many folds less brittle. so basically, i'm ...
Read more

Add new key value to json node in java -

i have json file : { "id":1, "name":"abc", "addressdetails": { "city":"newyork" } } i wanted add 1 more key-value ("pincode" : "414141") node 'addressdetails'. i tried using : objectmapper mapper = new objectmapper(); jsonnode root = mapper.readtree(new file("d://test.json")); objectnode node = mapper.createobjectnode(); node.with("addressdetails").put("pincode", "414141"); but it's not getting added, there way can ? you can try you should modify file path objectmapper mapper = new objectmapper(); objectnode nodes = mapper.readvalue(new file("d:\\test.txt"), objectnode.class); nodes.with("addressdetails").put("pincode", "414141"); mapper.writer().writevalue(new file("d:\\test.txt"), nodes);
Read more