Extract specific data from notpad++

[supermanPunch (Arpan)]

@mironb

Since I don’t know in which batch file the same XML is found (it is dynamic) it is created after a new customer is created in the system, so I have to locate the same batch file only through Notepad++
I search by the customer ID number I created and I am shown the following.

@mironb ,

For this above mentioned purpose, as said earlier, we can use the below Steps :

1. Use Directory.GetFiles(“Your Network Path”,“*.xml”) and get the list of all the xml files present in the Folder.

2. Next, Loop through the files, and read the file using Read Text File activity.

3. Check if the text data present has the customer ID present in it, specifically in the xml format below :

<customerID>500054627</customerID>

For this we can use a Regex IsMatch for identifying if it is present or not.

4. If present within the file, then we get to know which file contains this number, we can then read that file data, or parse that file as XML document and then perform the actions required.

Check the example workflow below:
Files_GetRequiredFile_ForProcessing.zip (4.4 KB)

Output Visuals :

@mironb

I need to read XML that is inside a Batch file (within it there are several merged XMLs).

Maybe this part is not clear yet, However I believe when using the Directory.GetFiles() previously you were able to get all the xml files as well.

However, try the workflow and apply it to your requirements and let us know what are your findings.