AutoHotkey Community

Monoxide3009

Thanks. I already have a working function, but this is good to know. The issue was that I have never used the A_Loopfield, so that is something to look into for the future. I think that can help me a lot.

Monoxide3009

Thanks, I actually looked there, but I somehow missed these lines:

if var contains 1,3 ; Note that it compares the values as strings, not numbers.
MsgBox Var contains the digit 1 or 3 (Var could be 1, 3, 10, 21, 23, etc.)

Monoxide3009

Looks like everything works well when tested. Thanks a ton.

I tried researching for contains using multiple parameters, but I was unable to find anything - the wiki didnt seem to answer my question properly. I have updated everything and looks to be working great.

Monoxide3009

I didnt think that worked - let me try it. However, I have another line that I was hoping to fix as well: if (PROJ = "OPT") and HAWB contains MST { Sleep, 50 wrkbk1.Sheets(SheetName).Range("C"ROW).Characters.Text := "Skipped MST HAWB" Sleep, 50 continue } EDIT - I will test this as (PROJ = "OPT"),HA...

Monoxide3009

Hello All, I am having a hard time figuring out a solution to a function that has multiple contain parameters on a single line. This seems extremely simple, but I cannot find the solution. Please be gentle; I am self taught (please be as descriptive as you can with any suggestions). segment of funct...

Monoxide3009

I 'may' be able to get strsplit to work, but it looks like I have to use indexing, which I am not super familiar with. I will try to put something together and trial-and-error it. If you come up with an idea, Scr1ptor, I would still love to see it. Sorry for the spam, I was able to get it working si...

Monoxide3009

Scr1pter wrote: ↑
31 Dec 2018, 14:01
Did I understand it correctly?

What you wrote looks to be correct for what I am looking for.

I will also check out string split in the meantime.

Monoxide3009

Hello All, I assume this will have a simple solution, but I am drawing a blank. I have an excel sheet (that cant be edited) that has multiple entries in a single cell that I need to split up. The data points are separated by a semicolon, so I think this will have an easy solution. Example - 17022056...

Monoxide3009

I was able to get it functioning with your help awel20. However, I had to alter/remove several things you changed, as 'exactly' what you wrote does not work at all. I came across a proper setup by trial and error, as I didn't understand what the m)^ was for, I removed it. I also changed the $ end of...

Monoxide3009

Hello All, I know there are a lot of posts on this topic, but all of them so far have been far beyond my understanding. I have tried to piece things together for several days, and I am getting no where. My goal is to pull multiple regex matches in a batch of text. I currently have a working script t...

Monoxide3009

Hello All, I am looking to make a completed script easier for the end user. Currently, my script obtains dates and puts them in excel, pretty cut and dry. However, there is confusion as the dates arent in "date formatting" on the end spreadsheet; everything works fine from my end, but their equation...

Monoxide3009

Back after spending the weekend pondering/playing with all this. I currently have internet explorer connected via com, and (finally) figured out how to get it to wait for the page to finish loading. I now have a new/similar issue to the ones above. I was able to work around the "moving" link I was d...

Monoxide3009

Create works - however I am trying to utilize an already open window. Everything I have found on the topic was close but not the same, or simply didnt work (or at the very least *I* couldnt get it to work). Verison: 1.1.27.00 I have played with the idea of creating a new window and starting from the...

Monoxide3009

Hello All, Im back again. I am trying to click on a moving button on a web page. From what I can tell, ControlClick can accomplish this task. However, I cannot get it to work. I think part of the problem is that the button appears to be an image in the html and not actual text: <A onclick="if(typeof...

Monoxide3009

Took me about 2 hours to really figure out what was going on here; once I played with it a while, I got it.

Works like a charm. Cut a LOT of inefficiency out of my script.

Thanks, FG, you Fatastic Guru.

Monoxide3009

FG Thanks. I have seen something "similar" to this, but I wasnt able to decipher it. This looks clear and to the point, I think I should be good. Any suggestions on finding the next blank cell when dealing with multiple sheets? What I have 'works' but after a few dozen rows, it slows down drastical...

Monoxide3009

Hey All, TL;DR - 1) how do you test if a sheet name exists, 2) how do you create a sheet - I'm new, the more details/descriptions you provide the better. I am trying to figure out (what I assume to be) a simple function but I am drawing a blank. I am working with 2 workbooks at a time, and I need a ...

Monoxide3009

Playing around, I used a regex match to change the format of both dates to yyyymmdd then used EnvSub, and it seems to be working. I am going to try to adapt this to the main script. If anyone has suggestions or a better working process, please let me know still. What I came up with: var1 = %A_Now% ;...

Monoxide3009

I have seen MANY forum posts on this, so I apologize, but I cannot get what I am doing wrong even with some of those answers. I am still quite new, so any advice would help if extremely detailed. Do not worry about condescending =p Right now, I am trying to compare a date pulled from an internal pro...

Monoxide3009

Welp, after you responded saying this should work, I started to copy over my entire code with the examples I have... Only to stop and notice that my variable FTL and FLT is not the same... I had been using a different variable the entire time. However, now that the variables are matched up and it is...

Search found 32 matches

Re: Multiple Contains Functions on Single Line Topic is solved

Re: Multiple Contains Functions on Single Line Topic is solved

Re: Multiple Contains Functions on Single Line Topic is solved

Re: Multiple Contains Functions on Single Line Topic is solved

Multiple Contains Functions on Single Line Topic is solved

Re: Single Cell - Multiple Output Topic is solved

Re: Single Cell - Multiple Output Topic is solved

Single Cell - Multiple Output Topic is solved

Re: Multiple RegEx Matches Topic is solved

Multiple RegEx Matches Topic is solved

Format Date - Excel Com

Re: ControlClick Help

Re: ControlClick Help

ControlClick Help

Re: if (excel sheet exists) ? create

Re: if (excel sheet exists) ? create

if (excel sheet exists) ? create

Re: Comparing Dates

Comparing Dates

Re: RegExMatch Help Topic is solved