View Single Post
 
Old 06-28-2019, 01:48 AM
arunchandar9 arunchandar9 is offline Windows 7 32bit Office 2013
Banned
 
Join Date: Jun 2019
Posts: 8
arunchandar9 is on a distinguished road
Default

Hi,

It works well with first scenario whereas causing error with second

157 73079290 ADAPTER AS.-ELBOW 90 DEG (NON ELECTRICAL) (50 NOS) | PL_361
7A026


173 73079290 ADAPTER AS.-ELBOW 90 DEG (NON ELECTRICAL) (50 NOS)
| PL_3617A026

Below is the code I'm using now. It's not finding above highlighted Text if it's partial with first and second row or in second row


.Text = "([0-9]{1,})[!^13]@| ([A-Z]{2}_[A-Z0-9]@>)*^13"

I know it's complicated. It's a system generated word reports


Regarding 3rd Scenario, I need to find every third text of below contents

1 73181500 0L1352 BOLT

2 73181500 0S1573 BOLT

354 73181500 3215144 BOLT-WHEEL

330 85365020 2552751 SWITCH AS-START

331 40169990 2588917 SLEEVE-HOSE
Reply With Quote