Solved

String Manipulation using Regex expression

  • 13 April 2023
  • 1 reply
  • 392 views

Badge +2

Hi 
I extract text from my pdf 

Var= PEARL BRANCH BEACON BUILDING PRODUCTS 205 PRIESTER DR. PEARL, MS 39208 Telephone: 601-939-9128 WATKINS CONSTRUCTION DBA: MICHAEL DIER 1072 HIGH STREETJACKSON, MS 39202

This text could be cahnge everytime 
There could be a JACKSON,
These could be ALBAMA,
There could be LOUSIANA 
inplace of JACKSON shown in above var(pdf extracted text)

I only want to extract JACSON from above pdf
..
Currently using string text extract action, but it only works best for particular variable
My text changes every time, how it only extracts  JACKSON,
ALBAMA, LOUSIANA from my whole extracted text


 

icon

Best answer by LoganPrice 13 April 2023, 22:18

View original

1 reply

Userlevel 3
Badge +9

I used ChatGPT to find the answer to your question. The following regex will use the phrase immediately before and the one immediately after the city to locate whatever text is in that space.



You could also just use the “Extract text” action in A360 to specify the phrase before and the phrase after the city so it functions the same as the Regex:

Let me know if that helps you.

Reply