cyberchief

HI all. I think from now on... I will wait until after I have done some research and playing around before posting dumb questions. I got it figured out... see below. Let me know if you have any suggestions to make this easier or to cut down on the code... Activate Window: "CSR TEST" Clipboard Copy Variable Set String %T1% from Clipboard Variable Modify String: Copy Part of %T1% to %T2% If Variable %T2% = "970" OR If Variable %T2% = "303" OR If Variable %T2% = "307" OR If Variable %T2% = "719" OR If Variable %T2% = "720" Variable Set String %T3% "CO" Activate Window: "OSCAR_CO_WY - USWest Connect" Delay 0.2 Seconds Clipboard Paste Else If Variable %T2% = "612" OR If Variable %T2% = "651" OR If Variable %T2% = "763" OR If Variable %T2% = "952" OR If Variable %T2% = "218" OR If Variable %T2% = "507" OR If Variable %T2% = "320" OR If Variable %T2% = "701" Variable Set String %T3% "NO" Activate Window: "OSCAR_EAST_NO - USWest Connect" Delay 0.2 Seconds Clipboard Paste Else If Variable %T2% = "308" OR If Variable %T2% = "319" OR If Variable %T2% = "402" OR If Variable %T2% = "515" OR If Variable %T2% = "563" OR If Variable %T2% = "605" OR If Variable %T2% = "641" OR If Variable %T2% = "712" Variable Set String %T3% "SO" Activate Window: "OSCAR_EAST_SO - USWest Connect" Delay 0.2 Seconds Clipboard Paste Else If Variable %T2% = "208" OR If Variable %T2% = "385" OR If Variable %T2% = "406" OR If Variable %T2% = "435" OR If Variable %T2% = "801" Variable Set String %T3% "UT" Activate Window: "OSCAR_AZ_ID_MT_NM_UT - USWest Connect" Delay 0.2 Seconds Clipboard Paste Else If Variable %T2% = "480" OR If Variable %T2% = "505" OR If Variable %T2% = "520" OR If Variable %T2% = "602" OR If Variable %T2% = "623" OR If Variable %T2% = "928" Variable Set String %T3% "NM" Activate Window: "OSCAR_AZ_ID_MT_NM_UT - USWest Connect" Clipboard Paste Else If Variable %T2% = "206" OR If Variable %T2% = "253" OR If Variable %T2% = "360" OR If Variable %T2% = "425" OR If Variable %T2% = "509" OR If Variable %T2% = "564" Variable Set String %T3% "WA" Activate Window: "OSCAR_WESTERN - USWest Connect" Delay 0.2 Seconds Clipboard Paste Else If Variable %T2% = "503" OR If Variable %T2% = "541" Variable Set String %T3% "OR" Activate Window: "OSCAR_WESTERN - USWest Connect" Delay 0.2 Seconds Clipboard Paste End If End If End If End If End If End If End If Text Type: <HOME> Delay 0.5 Seconds Text Type: <TAB><TAB><TAB><TAB><TAB><TAB> Date: Type Out MM (03) Date: Type Out YY (00) Text Type: <TAB><TAB> Text Type: %T3% Delay 0.2 Seconds Clear Text Variables: All Text Type: <F5> Delay 1 Seconds

Hello all! This program just keeps getting better. I need to set a variable to a specific 2 digit code depending on the first 3 digits of a 13 digit number in a spreadsheet. Say the digits are 9705554444333, I need ME to see the the first three and if it equals 970, set another variable to equal CO (state code). I have 41 area codes to work with, but 9 state codes identified (multiple 3 digit codes can equal the same state code). Example, 970 and 303 all equal CO, but if 3 digits are 612, equal NO (along with others). To start, I am sure there will be a long line of code setting these variables, but I am trying to figure out where to start... how to get ME to see only the first 3 digits off of the clipboard. Any suggestions?

The program I am using is archaic... pretty old... so a lot of the functions available will not work. But, I was able to put together a pretty brutal attempt that does work... though, it takes forever. I have set it up to copy 3 text spaces from each field. I have it copying to the clipboard and comparing it to the specifications requested. If it does not find it, it moves on... and repeats until it does find it. And then, goes on to the next field searching. I am still working on a better way. But Window Controls does not work as far as I can tell. I have tried, but nothing works as of yet. Activate Window: "SOPAD_CO_WY - USWest Connect" Repeat Until %T1% = "BN1" Text Type: <TAB> Text Type: <SHIFTD><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><SHIFTU> Clipboard Copy If Clipboard Text Equals "BN1" Text Type: <TAB> Text Type: Customer Name End If Variable Set String %T1% from Clipboard Repeat End Clear Text Variables: All Repeat Until %T1% = "BN2" Text Type: <TAB> Text Type: <SHIFTD><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><SHIFTU> Clipboard Copy If Clipboard Text Equals "BN2" Text Type: <TAB> Text Type: Customer Address End If Variable Set String %T1% from Clipboard Repeat End Clear Text Variables: All <SPKEY:0000><ACTIVATE2:SOPAD_CO_WY - USWest Connect><REP3:08:000001:000001:0001:0:01:BN1><TEXTTYPE:<TAB>><TEXTTYPE:<SHIFTD><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><SHIFTU>><CLIPC><IFOTH2:07:1:BN1><TEXTTYPE:<TAB>><TEXTTYPE:Customer Name><ENDIF><TVAR2:01:03:><ENDREP><CLEARVAR1:T:ALL><REP3:08:000001:000001:0001:0:01:BN2><TEXTTYPE:<TAB>><TEXTTYPE:<SHIFTD><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><SHIFTU>><CLIPC><IFOTH2:07:1:BN2><TEXTTYPE:<TAB>><TEXTTYPE:Customer Address><ENDIF><TVAR2:01:03:><ENDREP><CLEARVAR1:T:ALL>

Nevermind... I didn't realize that ShiftDown and Shift up would work for this. Got it figured out. now, on to reading on the If/Then issue and figure out how to get it to continue searching for these fields.

I don't think the Window Controls will work because with each account pulled, the BN1 feild can change relative to anywhere on the screen. Again, i apologize because I am a newb. I think if "copying text to clipboard and running a function if said copied text matches BN1, then do such and such, else, tab on" works... I might be in business. I have much to read in the help files... it is a little discouraging because there is so much and I am not finding much... but you all have put me on the right path. It is MUCH appreciated!!! Thank you all for your help. Now, I can figure out how to copy to a clipboard... but, I need to figure out how to extend the field. The program we are using was build specifically for the company... so it is not softward available anywhere else. common functions like ctrl-f for find do not work. I need to be able to hold the shift key and arrow over 3 times to cover all 3 spaces to copy to the clipboard. I am trying text type... but it only will highlight the first character. <Shift><End> will not work for my purposes. Anyone know how to do this? <Shift><Arrow Right><Arrow Right><Arrow Right> doesn't work... it only picks up the first arrow right and only highlights the first character. Thanks all for putting up with my newbie ignorance. I will continue reading and trying to help myself!

So, as far as anybody knows, there is no way for ME to find specific text in a text field? Man... this is almost depressing. I have read such great things... but it seems like my use of ME will be limited unless I can figure this thing out. Thanks all for any help!!! Much appreciated.

Thanks again for the reply. It is not web-based... so no web browser. And the window title does not change at all... hence my problem.

Thanks for the info... it does provide me with a glimmer of hope. First, the window does not "re-title" itself... it retains the same title even after the new information posts. This may just show my ignorance with ME... but doesn't the program look for the variation of the window title to continue processing commands (i.e. the title of a web page changes as you navigate). Also, the pogram is not really a database... it is more of a portal to a back end database. I put in the account number, and it searches and displays on the screen in a specific format ( but for the order application, not always in the same position). The order application displays all parts of a new order with fields that are typable. Each field has a beginning identifier (BN1 as before)... I need for the focus to be set specifically to the BN1 field wherever it is on the screen. Thanks much for all your help... I look forward to more replies! Everything is helpful!!!

My example of feilds didn't post right... there are spaces between the ____ Fields and the BN1 fields and data fields. These spaces are "dead" feilds and cannot take focus. you can tab between fields though. just wanted to clarify since in my example, they all look run together. TIA

Hey all! Brand new here... and just installed ME. I have gone through most of the tutorial and have read many of the topics here. I have a couple questions... I am trying to figure this fangdangle thing out We use programs that sometimes "hang" while waiting for information from the server and databases. After reading through here... it seems the only way to "pause" a macro is to put in a time delay. My problem is that most of the time, the application does not hang... but once in a while, it will be "not ready" while waiting for the database or server to respond. This creates quite a variable in time length for the delay. Most of the time, it is within a second. Sometimes, it can hang for 30 seconds. The macro program installed with the program "waits for screen" causing it to wait until the information or window has posted. Is there any type of function in ME to do this? It seems not, but I thought I would ask. Second, In a similar database program, I am trying to create a macro to change a customer's address. There are lines in the program with specific identifiers signifying what data each line should contain. See below for example: ____ BN1__ CUSTOMER NAME_________________ ____ BN2__ ATTENTION LINE__________________ ____ BA1__ CUSTOMER ADDRESS______________ ____ PO___ CITY, STATE, ZIP_________________ There is an entire page of data and most of the time, different quantity of lines between the home starting point and the address information. I would like for the macro to find "BN1", set focus to that spot, and tab over to overtype the text in the data feild. Also, in certain cases, I need to change that BN1 to IBN1, or in other cases, if no BN2 exists, insert a line and include a BN2. Are these things even possible? or am I day dreaming? And please remember... I am knew... and vulnerable Please.... be gentle.