Problems with Generate Regex Patterns

Help Studio
, ,
1

Hello Experts,
I would like help with generating a regex pattern to get specific data the Address field.
Your help will be appreciated
Here is a duplicate sample of what I mean, I just want the Address data
Starting Date Ending Date Address
1/1/2021 2/3/2021 ABCDEF12345-132 7543 XY
2/2/2021 3/2/2021 XCVRWT*5667-111 98765 ZC

2

Where did this data come from? Is it in a file? Might be tab delimited.

3

Hi @phionamartinez ,

Could you Check with the below Expression :

(\d{1,2}\/\d{1,2}\/\d{4})\s+(\d{1,2}\/\d{1,2}\/\d{4})\s+(.*)

image
image1087×304 33.8 KB

We can access each value by Groups 1, 2, 3.

Let us know if this doesn’t work for your case.

4

No, it’s not working

5

@phionamartinez ,

Could you let us know what steps have you tried ?

Additionally could you also send the sample data in text file ?

6

The data is in a tex file, am trying to get the specific data using regex
The data has addresses for people so i can’t share due to confidentiality I just made a duplicate

7

@phionamartinez , Could you maybe post screenshots of how you’re accessing the values from the regex expression/ Activity in the workflow ?

We would need to know what exactly is not working.

8

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