I am utilizing Matches and Regex to get 7 values [using groups in Regex], see image. After extracting the data I am using a ForEach activity to assign the data items as such:
- Company_Name = item.Groups(1).Value
- Customer_Name = item.Groups(2).Value…
- Original_Trace = item.Groups(7).Value
As part of development and troubleshooting, I am writing out the values to a dialog box just to check data. The first one is returning the correct value; however, the others are coming back NULL. Is my assign incorrect or will the RegEx as I have it not work?
I eventually need to get them into Orchestrator as queue items, but need to get data correct first. Any thoughts on what I may be doing wrong?