Jump to content
Macro Express Forums

Amerifax-Bob

Members
 View Profile  See their activity

  • Posts

    16

  • Joined

  • Last visited

 Content Type 

Posts posted by Amerifax-Bob

  5. Variable to Capture Selection - Not Line

    in Macro Express and Macro Express Pro

    Posted

    If I want to capture a Line I basically do the following:

     

    Variable Set to ASCII Char 13 to %CR%

    Variable Set to ASCII Char 10 to %LF%

    Variable Set String %Content% from the clipboard contents

    Split String "%Content%" on "%CR%%LF%" into %Line%, starting at 1

    // Place values from SelectPhone into Excel

    Window Activate: Microsoft Excel

    Text Type (Simulate Keystrokes): %Line[1]%

    Text Type (Simulate Keystrokes): <TAB>%Line[2]%

     

    At times I only want to capture a part of a line as example: Phone: 262-353-3278

    My Selection is made by: Ctrl+Shift(RightArrow), (RightArrow)(RightArrow), Shift (End)

    It seems to me I only need to change one line to do this: Text Type (Simulate Keystrokes): <TAB>%Line[2]%

     

    The following changes nothing. I still do get the entire Phone Line capture. I onlt want the number.

    Text Type (Simulate Keystrokes): <CTRLD><SHIFTD><ARROW RIGHT><CTRLU><SHIFTU><ARROW RIGHT><SHIFT><END><TAB>%Line[11]%

     

    Bob

  6. Macro Timing

    in Macro Express and Macro Express Pro

    Posted

    Kevin - What you and others have helped me with over the last week or so has given my company a breath of fresh air. We are part of a dying industry "New Home Info". With this help we can now convert and check info against our master "Permit" data base. Before time would make it almost impossable to complete.

     

    Thanks again.

     

    Bob

  7. Macro Timing

    in Macro Express and Macro Express Pro

    Posted

    Kevin,

     

    Wouldn't writing a file for every single record slow things down? If each record I copy gets written into a file I would think that would take a while. I could be completely wrong but...

     

    Learning is fun...but it's finally getting the result you've been working so hard at that makes it rewarding.

     

    I am going to play around with this a little bit with what you suggested and check it out.

     

    Thanks again!

     

    Bob

  8. Macro Timing

    in Macro Express and Macro Express Pro

    Posted

    Well I don't know why, but for some reason I don't think the clipboard was liking the copy being done in the Phone directory program. So what I did was paste it into my text editor, re-copy it; then the macro ran through fine. I know it's an extra step but it seems to need it to recognize the data properly. I thought about what you said and tested it on some text that I typed in and it split the lines properly with that test, so it pointed to the phone program.

     

    Well now for the real test, 1000's of records...we'll see!

     

    Thank you again for your help and above all your patience with me.

     

    Bob

  10. Macro Timing

    in Macro Express and Macro Express Pro

    Posted

    What exactly will a Hex Editor do for me and can you suggest one? I did try all the different combinations you suggested though. I tried, CR, LF and CRLF. Is there many more? Right now we use Ultra Edit which is a text editor and it shows a standard Paragraph mark at the end of each line. Does that count for anything?

     

    Actually I just found that UltraEdit has a HexEditor as part of the program. I looked at it but I have no idea what it means. At the end of every line I see an "OD OA" what does that mean? I attached an image file that I was hoping maybe you could look at and tell me what it is that I need from it.

     

    Actually I just found another part and it seems that it is using a CRLF. I have tried all these combinations...is there something I'm missing.

     

    Thanks again,

     

    Bob

     

    This is the furthest we have ever gotten with this. We usually end up getting frustrated and put the project on the shelf again. With the new update of Macro Express we thought we would give it another shot but...

    post-47-0-79069900-1304027217_thumb.png

  12. Macro Timing

    in Macro Express and Macro Express Pro

    Posted

    Thanks for the explanation. I understand now what they are and what they do and why both really are necessary. But...in my macro this is what I ended up doing:

     

      Variable Set to ASCII Char 13 to %CR%
 Variable Set to ASCII Char 10 to %LF%
 // Place Clipboard into Variable
 Variable Set String %Content% from the clipboard contents
 Split String "%Content%" on "%CR%%LF%" into %Line%, starting at 1

     

    I am using both but I am still getting the full results in the %Line[1]% Variable. Is there something else or another character I can try?

     

    Bob

  13. Macro Timing

    in Macro Express and Macro Express Pro

    Posted

    I figured out that I was missing this:

     

     

      Variable Set to ASCII Char 13 to %CR%
 Variable Set to ASCII Char 10 to %LF%

     

    I placed this in my Macro right above the "Variable Set String from Clipboard" but I am still getting the same response.

     

    I am getting all the lines of text in %Line[1]%.

     

    Bob

     

    P.S. Where would I find those commands above "Char 13 and Char 10" it took me a minute to figure out and I remembered the same thing in one of Cory's messages and it finally hit me...

  15. Macro Timing

    in Macro Express and Macro Express Pro

    Posted

    OK I have been working with it and this is where I am now...

     

      Delay: 150 milliseconds
 Window Activate: ProCD PhoneBooks
 Wait for Window Title: ProCD PhoneBooks
 Text Type (Simulate Keystrokes): <ARROW DOWN><ALT>vmo
 Text Type (Simulate Keystrokes): c
 Variable Set String %Content% from the clipboard contents
 Split String "%Content%" on "%CR%" into %Line%, starting at 1

 Window Activate: UltraEdit
 Wait for Window Title: UltraEdit
 Text Type (Simulate Keystrokes): %Line[1]%

     

    Result:

    HESTAD JAMES

    3905 LANCASTER LN N

    MINNEAPOLIS, MN 55441-1734

    Phone: 763-546-8059

    Listed Since: 04/2005

    Residence

    County: HENNEPIN (27053)

    MSA: MINNEAPOLIS-ST PAUL, MN (5120)

    Latitude: 45.028860

    Longitude: -93.402420

    Precision: Geocoded to address precision

     

    I am not sure what I am doing wrong (and I'm thinking it's minor). I think I might have the wrong Character in my Split On. I've tried %CR% and %LF% and neither one works for me. I am getting all the lines in variable %Line[1]%. In my text editor, it shows a "paragraph" mark at the end of each line, which I thought was a standard return or enter. I am almost there. And it is so much faster. I can't thank you enough for sticking it out and pushing me to listen more! I have been searching the help and I just can't get over this last hump...

     

    Bob

  16. Macro Timing

    in Macro Express and Macro Express Pro

    Posted

    First off...It seems Cory was trying to show us this procedure and we just weren't getting it (*sorry*). So I would like to thank Cory and Kevin for all their help with this matter! That said...

     

    I think I am finally starting to understand what you are trying to show here:

     

    Variable Set to ASCII Char 13 to %CR%
Variable Set to ASCII Char 10 to %LF%

     

    1st Line: Start with Character 13 and go to the "Return" and copy that into a Variable

    2nd Line: Start with Character 10 and go to the "End of the Line" and copy that into a Variable

     

    So would I be correct in thinking that both lines are actually showing the same thing, just 2 different ways to do it?

     

    Variable Set String %Content% from the clipboard contents
Split String "%Content%" on "%CR%%LF%" into %Lines%, starting at 1

// Here:
 %Lines[1]% contains line 1
 %Lines[2]% contains line 2

     

    Now this part is telling me...

    1st line: Copy the contents of the clipboard to a Variable called "Content"

    2nd line: Split the "Content" at the "Return" or "End of Line" into separate Variables called "Lines" starting with line 1. (Am I getting it???)

     

    Then to get my result into Excel or whatever I would text type "%Lines[1]%" etc. So even if I have a blank line that would still count as a Variable, in my case %Lines[5]%, and I just would not use or paste it.

     

    The second code you showed, I assumed that would process an entire file, if you had a long text file that you wanted to process? In my case my text will always be in the same format as below. After I copy it into variables and paste it, I copy the next record to the clipboard...

     

     

     

    So once I do my Capture (AltVMOC), I have this in the clipboard (and it usually always, if not always, follows this format):

     

    HAWKINSON Robert

    5905 LANCASTER LN N

    MINNEAPOLIS, MN 55441-1734

    Phone: 763-544-2029

     

    Listed Since: 06/2007

    Residence

     

    County: HENNEPIN (27053)

    MSA: MINNEAPOLIS-ST PAUL, MN (5120)

    Latitude: 45.088860

    Longitude: -93.102420

    Precision: Geocoded to address precision

     

    I am going to give it a try.

     

    Thanks again for all your help and patience!

     

    Bob

  17. Macro Timing

    in Macro Express and Macro Express Pro

    Posted

    I might have an idea but I need someone to tell me if I'm going in the right direction. Example:

     

     

    HAWKINSON Robert

    5905 LANCASTER LN N

    MINNEAPOLIS, MN 55441-1734

    Phone: 763-544-2029

     

    Listed Since: 06/2007

    Residence

     

    County: HENNEPIN (27053)

    MSA: MINNEAPOLIS-ST PAUL, MN (5120)

    Latitude: 45.088860

    Longitude: -93.102420

    Precision: Geocoded to address precision

     

    This how I was doing it to the second line of text.

     

    // Select: Address to Excel var2

    Clipboard Empty

    Text Type (Simulate Keystrokes): <ARROW DOWN><HOME><SHIFT><END>

    Clipboard Copy

    Text Type (Simulate Keystrokes): <ARROW DOWN><HOME><SHIFT><END>

    Variable Set String %T[2]% from the clipboard contents

     

    This is what I'm thinking.

    "Shift End" "Delete" each line. Than repeat each line.

    My problem is how to create variable.

    The "Text Type" box gives me the "Shift End" "Delete" and also the mention of variable. I don't have a clue on if I can even capture at this point and get the variable i need. I was thinking if I created a globe variable for capture so I could use it in the "Text Type". I'm a summing all this since I saw variable listed in the "Text Type" box.

     

    Bob

  18. Macro Timing

    in Macro Express and Macro Express Pro

    Posted

    Kevin - It just dawned on me that you must have been thinking I had only one line of text. I see that would be easy. It would be nice if we had a feature that would allow us to get items from clipboard by "Line Number". Here's hoping.

     

    Bob

     

     

    >>

    HIRT PETER

    W299N7320 BREEZY CIR

    HARTLAND, WI 53029-8478

    Phone: 262-538-1186

     

    Listed Since: 10/2003

    Residence

     

    County: WAUKESHA (55133)

    MSA: MILWAUKEE-WAUKESHA, WI (5080)

    Latitude: 43.150620

    Longitude: -88.339320

    Precision: Geocoded to address precision<<

  19. Macro Timing

    in Macro Express and Macro Express Pro

    Posted

    Once you have the information in the clipboard you can get it into a variable in a macro.

     

    I only place it in UltraEdit to create the variables. Since my clipboard has the text as Example: I don't know how to create the variable, in the clouds, with out seeing it. I do know the line numbers without having to see it.

     

    Bob

     

    HIRT PETER

    W299N7320 BREEZY CIR

    HARTLAND, WI 53029-8478

    Phone: 262-538-1186

     

    Listed Since: 10/2003

    Residence

     

    County: WAUKESHA (55133)

    MSA: MILWAUKEE-WAUKESHA, WI (5080)

    Latitude: 43.150620

    Longitude: -88.339320

    Precision: Geocoded to address precision

  20. Macro Timing

    in Macro Express and Macro Express Pro

    Posted

    Where does the information exist before you paste it into UltraEdit?

     

    It a Phone Directory. Using "Alt vmo" ids the only way to capture the date. Some of the data only exist on other windows within Directory Program. From here I past "Ctr V" into any text program. I use MultiEdit. The format is almost always on the money. Some times the "Phone" is missing. I only use Name - Address - City ST Zip - Listed Since - Latitude - Longitude,

    which I past into Excel-2007. This evening my biggest problem is closing the Vmo window so I can continue macro. "C

    closes the window. So I do alt vmoc. I even tryied the "C" in the next line as TYPE TEXT.

     

    // SelectPro - to Excel\T\File\Excel\SelectPro - to Excel (Waukesha Resident).xlsx

    Repeat Start (Repeat 1 times)

    Window Activate: ProCD PhoneBooks

    Wait for Window Title: ProCD PhoneBooks

    Text Type (Simulate Keystrokes): <ARROW DOWN><ALT>vmo

    Also tried Text Type (Simulate Keystrokes): <ARROW DOWN><ALT>vmoc

    Text Type (Simulate Keystrokes): c

    Window Activate: UltraEdit

    Wait for Window Title: UltraEdit

    Text Type (Simulate Keystrokes): <CONTROL>a<DELETE>

     

     

    Sample of Text:

    HIRT KARI

    W24081 CLOVER DR

    SUSSEX, WI 53089

    Phone: 262-372-4302

     

    Listed Since: 01/2009

    Residence

     

    County: WAUKESHA (55133)

    MSA: MILWAUKEE-WAUKESHA, WI (5080)

    Latitude: 43.124640

    Longitude: -88.226040

    Precision: Geocoded to address precision

  24. Macro Timing

    in Macro Express and Macro Express Pro

    Posted

    Cory it might seem like i'm not lisening but... There are days when we need to put "Cory" on the front door. We do thamk you for your great help but some times it is a bit over our heads.

    Example:

    variable manipulation commands

    visibleway

     

    I guess this was in the back of my mind when I said process on clipboard - Out ragious statement but only tring to make my point. I agree visual is killing the time when sharing only a couple of seconds amounts to hours each days. Right know I'm running 7 computers to process the date.

     

    But you have a skill, knowlege, that slips by me. I'm not using "variable manipulation commands" becouse I have a better way. I know this is what I need to learn. Again don't think for a second that you have not infuenced our operations.

     

    Bob

×
×
  • Create New...