View Single Post
 
Old 06-25-2019, 08:30 AM
priyadharshane priyadharshane is offline Windows 10 Office 2016
Novice
 
Join Date: Jun 2019
Posts: 6
priyadharshane is on a distinguished road
Default Interpretation of Word Macro

Hello all,

I'm new to Word macro. A Word expert has supported me to automate capturing specific contents from word to excel. Now, I need some little more modification with mentioned macro file.

Can someone guide to explain below word macros please? It will make easier to modify based on my requirement

.Text = "Declaration*NIC*^13*[^12^13]{1,}" - What does ^13*[^12^13]{1,} means?

.Text = "[ ]{1,}[OI][rn][id][gi][ia][[n]*Inv No & Dt.*^13" - What does [ ]{1,}[OI][rn][id][gi][ia][[n]?

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

How it works?

Above macro used to pull part numbers, what if there is a symbol mentioned in part number or like this PK_2314K16 ? Will it capture it

Also, need understanding if it meant for one row or can be used for two rows of specific data like this

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

.Replacement.Text = "\1^t\2^t\3^t\4^t\5^p" - What does it mean?