Skip to main content
Solved

String Manipulation using Regex expression

  • April 13, 2023
  • 1 reply
  • 648 views

Forum|alt.badge.img+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


 

Best answer by LoganPrice

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.

View original
Did this topic help answer your question?

LoganPrice
Most Valuable Pathfinder
Forum|alt.badge.img+12
  • Most Valuable Pathfinder
  • April 13, 2023

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings