The code part is not to be done in Global Code area.
Instead create a new page, and inside that page add a code stage where the above code should reside.
The collection Data Items have to be created in the same page and should be passed as Inputs & Outputs to the code stage.
This requirement is not something that comes pre-package in Word VBO.
You will have to create a custom action, to traverse all paragraphs in the active document.
If a heading is found, set range.style = "Heading1" and so on
The API clearly requires a Body for you to be able to directly download the file. Without relevant details like address, body and header information, there is only so much one can help you with.
Easier way out is to : Paste the contents of the text data item in the file.
Pretty sure that the Resource PC is not started on the target VM where you want the process to execute.
When you open BP client, it launches a Resource PC by default.
Without opening BP client, you need to explicitly start the Resource PC.
Try this : On the VM, without opening BP client...
I couldn't find a single xml file containing <CPV MAIN>12345678</CPV MAIN>.
So, with limited information, here's what you can try:
Use Regex to extract the specific value : (?<=<CPV MAIN>).*(?=<\/CPV MAIN>) which will return 12345678
Try to explain the question again.
Are you looking to get a collection of all file names, inside the zip ?
Are you looking to get a collection of each file's entire contents, inside the zip ?
Are you looking to get a collection with only specific XML data extracted ?
That would be an incorrect solution, besides the fact that it would take more time to execute.
Merging & removing duplicates will fetch all unique records from both collections. OP only wants unique values present in 1st collection that are not present in 2nd collection.
Make sure to add below 3 Namespaces in Code Options Section :
Make sure to add below 2 External References in Code Options Section :
Create a code stage with Collection_1 & Collection_2 as...
[TEXT] is the data item having values like 26243-Jan, 99-Feb etc
Step 1: Use this in calculation stage Right([TEXT],3)&"-"&Left([TEXT],"-")-1)
This will convert 26243-Jan to Jan-26343
Store this back in [TEXT]
Step 2: Use a long REPLACE statement to replace Jan=1,Feb=2,March=3 & so on...
Everything appears fine.
I even tried running the query mentioned in the post and it was successful.
Excel File :
Query : "SELECT * FROM [Folha1$] WHERE [F1] ='#DET;2021;01;0498874;OPAO;0000645282,00;000987;0087,09;000000000,00;;'"