StringInStr - (Moved)

[stiv]

Buen Dia compañeros de Autoit,

soy nuevo en este lenguaje y quiero saber si hay alguna forma que cuando se copie  una variable con mouseclip o sellecionar una variable de un block de notas (contrl C ), se  pueda comparar con  una columna de excel para realizar un condicional siendo igual a un mismo valor.

Estaré atento 

Gracias

lo interpreto algo asi.

Translation:

Good morning, colleagues from Autoit,

I am new to this language and I want to know if there is any way that when copying a variable with mouseclip or selecting a variable from a notepad (contrl C), it can be compared to an excel column to perform a conditional being equal to a same value.

I am waiting

Thanks

I interpret it something like this.

WinActivate("notas pendientes: Bloc de notas")
Sleep(500)
Send("{CTRLDOWN}e{CTRLUP}")
Sleep(500)
Send("{CTRLDOWN}c{CTRLUP}")
Local $sData2 = ClipGet()
;---------------------------------

With $oExcel
.Range("F1:F10").Select     ;Select F1:F10  COLUMNA QUE QUIERO COMPARAR 
.Selection.FormatConditions.Delete  ;Delete Existing FormatConditions
EndWith

Send("{CTRLDOWN}c{CTRLUP}")
Local $sData2 = ClipGet()

If StringInstr($Copy,$oExcel,0) then 

PROCESO A REALIZAR 

 

Edited September 16, 2021 by Melba23
Added trans and code tags

[Melba23]

Moved to the appropriate forum.

Moderation Team

P.S.

1.  I can understand your Spanish, but this is an English-speaking forum - please use a translation website before posting in future.

2.  When you post code in future please use Code tags - see here how to do it.  Then you get a scrolling box and syntax colouring as you can see above now I have added the tags.

Thanks in advance for your cooperation in these matters.

 

Edited September 16, 2021 by Melba23

[Danyfirex]

Hello. I think you want to do something like this:

Hola. Creo que quieres hacer algo como esto:

#include <Misc.au3>
#include <MsgBoxConstants.au3>

HotKeySet("{ESC}", "_Exit")
Global Const $g_hDLL = DllOpen("user32.dll")


_Main()

Func _Main()
    While Sleep(30)
        If _IsPressed("11", $g_hDLL) Then
            If _IsPressed("43", $g_hDLL) Then
                _DoSomething()
            EndIf
        EndIf
    WEnd
EndFunc   ;==>_Main


Func _Exit()
    DllClose($g_hDLL)
EndFunc


Func _DoSomething()
    Local $sTextoCopiado = ClipGet()
    ConsoleWrite($sTextoCopiado & @CRLF)
    ClipPut("")
    Sleep(1000)
EndFunc   ;==>_DoSomething

 

PD: If It's not what you're trying to do, send me a PM and explain in Spanish It's my native language.

PD Spanish: Si no es lo que estas tratando de hacer enviame un mensaje privado en Español. Es mi lenguaje nativo.

 

Saludos

 

 

[stiv]

Hola Dany,

No, básicamente lo que quiero es que la variable que yo guarde con ClipGet, la pueda comparar con una variable igual en una columna excel donde debe estar ese mismo valor.

Trans:

No, basically what I want is that the variable that I save with ClipGet, I can compare it with an equal variable in an excel column where that same value must be. 

Edited September 23, 2021 by Melba23
Translation added

[Melba23]

stiv,

I told you above that this is an English speaking forum - please stop posting in Spanish or you may find you cannot post at all.

M23

[Musashi]

@stiv :

Since you are a new member, you may be unfamiliar with what is meant by PM.

PM (abbreviation for Personal or Private Message) is a feature of the forum to have a private conversation with one (or more) members. Such a conversation, as the name already indicates, does not appear as a public post, and there you can use whatever language you prefer.

To start a private conversation, use the "Envelope Button" from the website header :

However, you should consider the following excerpt from the forum rules :

Quote

5. Do not PM other users asking for support - that is why the forum exists, so post there instead.

 

On 9/17/2021 at 4:11 AM, Danyfirex said:

If It's not what you're trying to do, send me a PM and explain in Spanish It's my native language.

In this case it is fine, because @Danyfirex was so kind to offer you additional help.

EDIT : A good translation tool for your future contributions can be found e.g. here :  https://www.deepl.com/translate

 

Edited September 23, 2021 by Musashi

[Skysnake]

On 9/23/2021 at 3:44 PM, stiv said:

compare it with an equal variable in an excel column where that same value must be. 

Hi @stiv

you need to do two things. First copy the data. 2nd compare. I don't know what your data look like. A simple Excel VLOOKUP should do what you want.

The alternative is always SQL and do a SELECT there.

S

[stiv]

Hi there. @Skysnake
Of course, I did, as a solution, was to filter the excel file (column), and perform a copy and paste process in another row so that I took the initial variables. however it is more process.

func pasar()

 

 

Global $oExcel = _Excel_Open()

    Global $oWorkbook = _Excel_BookOpen($oExcel, ".\probar.xlsx" )

    Sleep(5000)

     

;---------------recort func------------

    WinWaitActive("Microsoft Excel - probar")

    

    Send("{CTRLDOWN}{HOME}{CTRLUP}") ;casilla principal

    Sleep(3000)

    send("{TAB 5}")

    Send("{ALTDOWN}{DOWN}{ALTUP}")

    send("{TAB 7}")

    Sleep(3000)

    Send("^v") ;Pega la variable

 

    Send ("{ENTER}")

    Sleep(9000)

   

Local $aResult = _Excel_RangeRead($oWorkbook, Default, "G2")

 

Local $sData = ClipGet() ; Cluck Obtiene la variable 

 

;ClipPut($sResult)

$sData = ClipGet() ; Envia La variable obtenida

    

   

    Sleep(3000) ; tiempo

    Send("^C") ; Pega la variable

    $Copy = ClipGet() ;

 

WinActivate("Reserva de Citas ")

MouseClick("left",893,50,2)

 

    If StringInstr ($Copy,"confirmacion",0) then  ;Cuando el archivo excel termine su recorrido, realiza una validacion de la casilla G para dar por terminado el robot 

    

    WinActivate("Reserva de Citas ")

    Sleep(2000)

    ;Correo()

    EndIf

EndFunc

[Skysnake]

I think you are making this more complicated than it really is.

1. You have data. Where does it originate? Is it a one time or repetitive event? This needs to be read
2. This data needs to placed somewhere, where it can be manipulated. Excel, CSV, or memory Array
3. Once the data store has been selected, use the appropriate tool to find matched.

 

• I would write the data to disk. SQLite or CSV so that it is available for inspection and troubleshooting
• I would loop the data through an array, because it probably is faster and more versatile that Excel.
• If your SQL is OKish, then simply running repeat SELECT loops on the data may also work

See this Comparing Arrays