AutoHotkey Community

omar

Opening one file and processing is not the problem. I think I can do that. The problem is working with many files. This is what I need: - Create new.csv if it doesn't exist. If it exists, overwrite. - Read in from folder called CSVs, all files that are a CSV file. - Read in the first CSV, remove the...

omar

I want to create a new CSV by importing many CSVs in a specific folder. For each CSV imported, I wanted add the file name on the first row, then ignore the first 3 rows import all rows - but ignore last 2 rows. I want to cycle through all CSVs and do the same. Not sure where I should start. Should o...

omar

I want to scrape a website and get data and make charts.
It involves following 50-200 links from one page.

QUESTION: how do I deal with Captchas?
Just wondering if someone else has done before?

Thanks.

omar

I have loads of code snippets. That I run and use. But then don't need to be hanging around. What would be the best and efficient way to have the code automatically close itself after x minutes? Would it be possible to have it close x minutes after the last use? Let's say after the code is set to cl...

omar

@mikeyww thanks for explaining - i learned loads in your few words

i'll make my code similar to what you showed from now

omar

Thanks for the reply. Not the solution I was looking for. I wanted something like this: string1 := "Hello Word" string2 := "123 ABC" string3 := "XYZ pqr" myString = ( aaaaa aaaaaaa aaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa. %string1% aaaaaaaaaaaa aaaaaaaaaaaa aaaaaaaaaaaaaaaaaa. aaaaaaaaaaaaaa. aaaaaa...

omar

Let's say I have a couple of paragraphs. In there I have a few variables. At the moment, I separate the variables and text and join. Surely there must be a better way? I have something like this for example: ::]badewaytocode:: myText1 = ( First ready made text goes here... First ready made text goes...

omar

Thanks for both replies guys.
Both solved and helped

@submed KeyHistory is soo useful!
(I do think you got a bit greedy with having one too many Hotkeys)

omar

To the far right side of the keyboard, there are keys i NEVER EVER use! I tried making a keyboard shortcut using some of them - the top right hand 3 chars: / * and - None of these worked. I tried pressing Numlock No luck How can I use them? I was trying to make a combination with pressing the Window...

omar

Ooh. Very nice.
Works perfectly.
I had to make one correction: arr := StrSplit(Clipboard,"`n")
Had to put quotes around `n

Better than my solution

This will be great for me to start with

Thanks

omar

I want to read in lines from a clipboard. For each line, I want to execute some actions (a simple msgbox will be OK, I can change later). After performing actions, I want to move to the next line and do the same. Then keep on going until I come to the end. Not sure where to start. I was thinking: Ar...

omar

@BoBo Thanks

The solution you gave will do perfectly for now
The other 2 I assume are a bit more complicated?

omar

Say I have a script... I want it to end after x minutes. I have a keyboard short cut to end... But it would be nice to have it end automatically after 5 minutes say. But... if the code is used... then the 5 minute time starts again. Not sure if that makes it too complicated I can live without this p...

omar

@mikeyww That's awesome
I get stuck on this SAME problem again and again and forget the answer
This time I have made a bookmark!

omar

I've never done this before...
But, I want to have a msgbox popup that asks for 3 inputs say.
I then want to execute simple code using this 3 variables?

I'm guessing this is simple

Can someone show me code to start me off?

Thanks

omar

@mikeyww I have a small problem

My data is:

abc,123
efg,456
xyz,999

Now I copy this into clipboard.
But the final line has a new line character.
So the loop gets executed one extra time.

I've tried trimming the clipboard by using trim(Clipboard)
Doesn't seem to work.

Any ideas?

Thanks.

omar

Amazing
Thank you

omar

I'm reading in from clipboard some data like this: abc,123 efg,456 xyz,999 I want to read each line and then get the 2 items read into a variable I'm trying this: Loop, parse, clipboard, `n, `r { StringSplit, myArray, A_LoopField, `, MsgBox % myArray[1] + myArray[1] } Not working. What am I doing wr...

omar

Not sure if I explained properly... The sending address will always be different for ebay and Amazon - I don't know beforehand the details I looked at RoboForm Don't think that fits the bill I looked at other form fillers as well - same thing They are great for SAME values always (as far as I can se...

omar

There are many forms that I would like to have prefilled and posted. Examples: - Google Calendar events I use these as reminder events. I will add a note like: 3rd February, dentist appointment at 9.30am. I will then schedule a reminder email to be sent: 120 minutes before the event, 1 day before, 5...

Search found 545 matches

Re: How to import CSVs and remove top and bottom lines

How to import CSVs and remove top and bottom lines

Web scraping how to deal with Captchas

How best to automatically have a script end itself

Re: How best to include variables inside text on many lines

Re: How best to include variables inside text on many lines

How best to include variables inside text on many lines

Re: making keyboard shortcuts with keys from the far right side

making keyboard shortcuts with keys from the far right side

Re: Inputting data from clipboard and parsing one line at a time Topic is solved

Inputting data from clipboard and parsing one line at a time Topic is solved

Re: How to get input from msgbox and use as variables in code?

Best way of automatically ending a script after x time

Re: Trouble splitting comma separated data into array Topic is solved

How to get input from msgbox and use as variables in code?

Re: Trouble splitting comma separated data into array Topic is solved

Re: Trouble splitting comma separated data into array Topic is solved

Trouble splitting comma separated data into array Topic is solved

Re: Can I automate form posting?

Can I automate form posting?