<roll where="house" session="112" year="2012" roll="17" source="house.gov"
aye="175" nay="247" nv="10" present="0">
<type>On the Motion to Recommit</type>
<question>On Motion to Recommit with Instructions: H R 1173 Fiscal Responsibility and Retirement Security Act</question>
Is it possible to write a SHORT macro that looks for the equal sign and quotations marks (=") and then stores the text that is between the " " to a line in the file (or another file)
Finds first ="
Then gets the value "house" (without the quotation marks!) and stores it in a kine
Finds next ="
Stores "2012" in the same line
I can always do a search and replace and replace where I find the where=" and replace it with nothing which will leave the values I want
but if there is a function that comes close to what I was looking for, that would be great.
Dont write any code….just let me know the functions I need to look at and I will take it from there….I hope !!!
Sorry for the delay. I suppose you posted just before the server when down, and we just got the forums restored on the new site.
You can use SandR to find the text =” then read forward (mark block, forward_till, mark block and copy block) collecting the characters into a variable, you can open a second window with a blank file having you macro remember its win number and the original file’s also. Then Swichwin and write your values then switch back.
In the CMac manula look for text maniputation, block comments and window function list.