I'm definitely not the best guy to answer questions but if you are searching for a string where 2 letters - underscore - 4 numbers - 1 letter - 2 numbers then:


Find=[A-Z]{2}_[0-9]{4,}[A-Z]{1,}[0-9]{2}


is the naming convention always the same? (PK_2314K16)


Best to post a sample of what you are looking for and what to replace it with.

Hiii,

I need below code to get modified to capture

Text which as PK_2314K161 (Total Characters is 11), 1186878 (total Characters 7), 9R2613 (Total Characters 6). As of now, it's capturing 1186878 & 9R2613

Also, need to capture if it's in second line as well. As of now, it's capturing if it's in one row

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

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