Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-26-2024, 02:15 PM
IndianaITGuy IndianaITGuy is offline Searching for the lone string on a line that starts with a particular character Windows 11 Searching for the lone string on a line that starts with a particular character Office 2019
Novice
Searching for the lone string on a line that starts with a particular character
 
Join Date: Mar 2024
Location: Martinsville, IN
Posts: 25
IndianaITGuy is on a distinguished road
Default 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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching for the lone string on a line that starts with a particular character Word macro for deleting a line that starts with a specific character + deleting the line before eduardb Word 1 08-10-2022 03:17 AM
How to move a line to another line that starts with a chain selected in the 1st one? gloub Word VBA 24 03-19-2019 03:12 PM
Searching for string on a formula AMD2800 Excel 1 12-17-2014 10:41 AM
Searching for the lone string on a line that starts with a particular character Replace paragraph-marks (line-breaks) in tables with a character-string Aztec Word VBA 2 04-02-2013 10:52 PM
Searching for the lone string on a line that starts with a particular character Finding or searching ^ character in word document shahin3121 Word 2 03-05-2012 06:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:01 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft