Regex to extract data between 3 - 8 digit number and 3 letter texT

Jelrey · August 31, 2020, 7:09am

I wanted to extract the data between 3 - 8 digit number and 3 letter text(casplock text) using regex. Any idea would be much appreciated thank you.

Data

"
"06/29/20 B QM 02004946 TEST HOME MORTGAGE TRU

03/10/20 B BC 2440720 BK OF TEST XPN

03/07/20 B QZ 00060298 CPORT RU TRU"

"
OUTPUT should be : TEST HOME MORTGAGE , BK OF TEST and CPORT RU

Yoichi · August 31, 2020, 8:00am

Hi,

Hope the following helps you.

Regards,

system · September 3, 2020, 8:58am

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

Topic		Replies	Views
Regex to extract data between 3 - 8 digit number and 3 letter text(casplock text) Studio uiautomation , studio , data_scraping , string , question	5	929	September 3, 2020
How to extract data between 3 - 20 alpha numeric characters using regex Help uiautomation , pdf , studio , data_scraping , string , question	2	1222	September 7, 2020
Regex to extract data between 3 - 20 aplha numeric characters and 3 letter texT Help uiautomation , pdf , activities , data_scraping , string , question	1	1248	September 3, 2020
UIPath dynamic regex Activities uiautomation , studio , data_scraping , string , question	9	1286	August 30, 2020
Extract data using regex from data scrapping Studio studio , data_scraping , regex , question , global_handler	4	981	April 28, 2021