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
|