Searching for the lone string on a line that starts with a particular character
Given
;TOOL:5 - DIAM:.75 CRAD:0 REF GL:0
;DESC: Q026
;MATL: HSS
M06 T5.5
(UAO,1)
(UIO,Z(-1*L370))
(TCP,5)
G00 X.429 Y-20.9056 Z11. A0. C0. S18000 M03
Z8.8065
G01 Z7.8065 F50.
X-1.571
Y-20.3033 Z7.802 F80. A-.761
Y-19.7012 Z7.7895 A-1.525 C-3.776
Y-19.0993 Z7.769 A-2.288
Y-18.4977 Z7.7405 A-3.051
Y-17.8965 Z7.704 A-3.813
Y-17.296 Z7.6596 A-4.576
Y-16.6961 Z7.6072 A-5.339
Y-16.6045 Z7.5985 A-5.455
Y-16.0054 Z7.5368 A-6.218
Y-15.4072 Z7.4673 A-6.98
Y-15.151 Z7.435 A-7.307
Y-14.5543 Z7.3541 A-8.07
Y-13.9586 Z7.2653 A-8.833
Y-13.4262 Z7.1791 A-9.516
Y-13.3791 Z7.1711 A-9.576
Y-13.1104 Z7.1248 A-9.922
Y-12.7073 Z7.0523 A-10.44
Y-12.3041 Z6.9759 A-10.96
X-1.5754 Y-12.0936 Z6.9348 A-11.176 C-3.682
X-1.5888 Y-11.8832 Z6.8929 A-11.393 C-3.592
X-1.6112 Y-11.6734 Z6.8501 A-11.61 C-3.504
My current algorithm does a search for "X*Y", which in my implementation expects that nonspecific string to exist on one line. In this example, there is a initially single value for X (1.571), and only the other variables change. Eventually, it reverts back to changing X & Y values. I need to be able to search for the unchanging X or Y value and then make a decision on what to do once that is done.
For the life of me, I cannot find the correct VBA syntax for finding a single string that starts with a particular letter (in this case "Y" and ends in a Paragraph Break.
|