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?
The RegEx is below. (normally it would start with a backslash, however, UiPath doesn’t like that):
COMPANY-NAME(?<COMPANY_NAME>.)|\CUSTOMER-NAME(?<CUSTOMER_NAME>.)|\CUSTOMER-ID(?<CUSTOMER_ID>.)|\AMOUNT(?.)|\RETURN/COR-CODE(?<RETURN_CODE>.)|ORIGINAL-TRACE(?<ORIGINAL_TRACE>.)
Regarding the data, below is an example of two blocks of data. The number of blocks could vary daily, but the data elements in each block is the same.
1431394730
DATE AND TIME 200518153000
COMPANY-NAME PPP FINANCIAL SE
COMPANY-ID 1431394730
SEC PPD
ENTRY DESCRIPTION AUTH PAYME
EFFECTIVE-DATE 020200515
CUSTOMER-NAME Novus Contracting Servi
CUSTOMER-ID 1004761
ACCOUNT 00000007027573364
TRAN-CODE 26
AMOUNT 1,926.81
TRACE 101000692652624
ADDENDA-TYPE 99
RETURN/COR-CODE R01 INSUFFICIENT FUNDS
ORIG-RDFI-T/R 06100022
ORIGINAL-TRACE 101000690000054
DATE-OF-EVENT 000000
ADDENDA-INFO
DATE AND TIME 200518154000
COMPANY-NAME PPP FINANCIAL SE
COMPANY-ID 1721394730
SEC PPD
ENTRY DESCRIPTION AUTH PAYME
EFFECTIVE-DATE 020200515
CUSTOMER-NAME MEP Service
CUSTOMER-ID 1224761
ACCOUNT 00000008527573364
TRAN-CODE 26
AMOUNT 2,926.81
TRACE 101000692652624
ADDENDA-TYPE 99
RETURN/COR-CODE R01 INSUFFICIENT FUNDS
ORIG-RDFI-T/R 06100022
ORIGINAL-TRACE 101000870000054
DATE-OF-EVENT 000000
ADDENDA-INFO