Posts by musthajm

  • Excel VBA Code for work with external regex table file

    Dear Developers,


    I have a input files call input1.xml, input2.xml, input3.xml ...... etc in a separate folder also another txt will call regex.tbl, I need to run regex code which are found in the regex.tbl to all the input files and the output should come to separate folder.


    Input file contained:

    <?xml version="1.0" encoding="UTF-8"?>

    <note>

    <to>Tove</to>

    <from>Jani</from>

    <heading>Reminder</heading>

    <body>

    Don't

    <sup>1</sup>

    forget

    <sup>2</sup>

    me

    <sup>3</sup>

    this weekend!

    </body>

    </note>


    Regex file contained:

    <sup>[0-9]</sup>|<sub>[0-9]</sub>


    Thanks,

    Musthanjith