Assigning Values and Creating Queue Items

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?

@etaulton Can you send the data and the Full Regex Expression that you have used ? We will try to correct the regex to Extract the Required data

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

@etaulton Do you need the COMPANY-NAME as well or Just it’s values ?

@supermanPunch
Just the values after each of the following fields:

COMPANY-NAME
CUSTOMER-NAME
CUSTOMER-ID
ACCOUNT
AMOUNT
RETURN/COR-CODE
ORIGINAL-TRACE

@etaulton Can you Check this workflow :
RegexTest.zip (2.5 KB)

@supermanPunch
About to test now. Will update in a few

2 Likes

also, in_TransactionItem is Argument with type of QueueItem with In/Out direction

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.