Search found 59 matches

by Krd
01 Mar 2021, 10:38
Forum: Ask For Help
Topic: Cut linebreak when copying from Exel? Topic is solved
Replies: 5
Views: 123

Re: Cut linebreak when copying from Exel? Topic is solved

This fixed for me after the first value copy from exel:

11digit := substr(clipboard, 1, 11)

Thanks
by Krd
01 Mar 2021, 10:17
Forum: Ask For Help
Topic: Cut linebreak when copying from Exel? Topic is solved
Replies: 5
Views: 123

Re: Cut linebreak when copying from Exel? Topic is solved

Is there another way to remove other than first 11 digits from clipboard? I want first 11 digits copied.
by Krd
01 Mar 2021, 09:26
Forum: Ask For Help
Topic: Cut linebreak when copying from Exel? Topic is solved
Replies: 5
Views: 123

Re: Cut linebreak when copying from Exel? Topic is solved


Don't know where to put it, thats what I have seen before...
by Krd
01 Mar 2021, 08:24
Forum: Ask For Help
Topic: Cut linebreak when copying from Exel? Topic is solved
Replies: 5
Views: 123

Cut linebreak when copying from Exel? Topic is solved

Hello, Send, {Ctrl Down}c{Ctrl Up} ;copying 11 digits number from exel. Sleep, 500 11digit := Clipboard The problem is that if I use "If and else" it doesn't match the same 11 digit numbers found in another place in order to make a match. Because if I paste the result to a word-doc it adds and extra...
by Krd
23 Feb 2021, 10:06
Forum: Ask For Help
Topic: Replace period with comma in clipboard? Topic is solved
Replies: 3
Views: 79

Replace period with comma in clipboard? Topic is solved

Hello, Send, {Ctrl Down}c{Ctrl Up} Sleep, 1000 Amount := Clipboard Sleep, 500 Send, %Amount% Where to add a line that would replace the value in Clipboard which is always in this format 500.00 to 500,00? The value before period is everthing from 1 to 100000.00. And an option to just cut everthing fr...
by Krd
27 Aug 2020, 01:50
Forum: Ask For Help
Topic: Move Mouse/cursor in text?
Replies: 1
Views: 52

Move Mouse/cursor in text?

Hello Lorem ipsum dolor sit amet, consectetur adipiscing elit (MOUSEMOVE/CURSOR), sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Or, ect... Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut (MOUSEMOVE/CURSOR) aliquip ex ea commodo consequat. How can I mov...
by Krd
10 Jul 2020, 01:47
Forum: Ask For Help
Topic: Change this code to another variant, dates again?
Replies: 9
Views: 2261

Re: Change this code to another variant, dates again?

I am thinking of making if conditions as this seem to not be easy task.

From posted code I can now make for past dates.

Anyone can share how to know if the future date in clipborad is newer than e.g 120 days from current date?
by Krd
10 Jul 2020, 01:43
Forum: Ask For Help
Topic: Change this code to another variant, dates again?
Replies: 9
Views: 2261

Re: Change this code to another variant, dates again?

I have already been thru your links before posting this...
by Krd
09 Jul 2020, 04:36
Forum: Ask For Help
Topic: Change this code to another variant, dates again?
Replies: 9
Views: 2261

Re: Change this code to another variant, dates again?

BoBo wrote:
09 Jul 2020, 02:23
:arrow: EnvAdd+/-= ... days
There is nothing there :P
by Krd
09 Jul 2020, 01:29
Forum: Ask For Help
Topic: Change this code to another variant, dates again?
Replies: 9
Views: 2261

Re: Change this code to another variant, dates again?

AFAIK, months having a different timespan (28-31 days) so "4 months" could vary depending on the date you wanna check. One reason why doing date&time math is so popular :lolno: It must not be exactly 4 months. Everything from 100 days to 120 days would do it. There must be a way to know if the date...
by Krd
08 Jul 2020, 10:57
Forum: Ask For Help
Topic: Change this code to another variant, dates again?
Replies: 9
Views: 2261

Re: Change this code to another variant, dates again?

Would you please state "is within the next 4 months from current date (a now)" more precisely? E.g. which is the last dates fullfilling the request for 31.10. and 01.11. ? All dates that are in past, current and until 4 months from now. So 4 months from now would be dates until 08.11.2020. Dates fr...
by Krd
08 Jul 2020, 10:09
Forum: Ask For Help
Topic: Change this code to another variant, dates again?
Replies: 9
Views: 2261

Change this code to another variant, dates again?

clipboard := "01.06.2019" var := strsplit(clipboard,".").3 . strsplit(clipboard,".").2 . strsplit(clipboard,".").1 if (a_now - var * 1000000 > 30000000000) msgbox older than 3 years else msgbox newer than 3 years Anyone can help convert this line?: if (a_now - var * 1000000 > 30000000000) I pick up...
by Krd
07 Jul 2020, 00:40
Forum: Ask For Help
Topic: Change added days to years, help pls? Topic is solved
Replies: 8
Views: 2673

Re: Change added days to years, help pls? Topic is solved

flyingDman wrote:
06 Jul 2020, 14:34
This is a way to test whether the resulting date is not valid (i.e. in case Feb 29 is not in a leap year):

Code: Select all

dt := "20210229" 
if dt is date
	msgbox % dt " is a valid date"
else
	msgbox % dt " is not a valid date"
Great :)
Thank you!
by Krd
07 Jul 2020, 00:38
Forum: Ask For Help
Topic: Change added days to years, help pls? Topic is solved
Replies: 8
Views: 2673

Re: Change added days to years, help pls? Topic is solved

Tanks guys.

Yes boiler i just needed that. But thought maybe there is an "easy" way to be 100% accurate as I need accuracy :)

So much great input, I really appreciate this great community and hopefully I will one day be able to help others too :D
by Krd
06 Jul 2020, 03:26
Forum: Ask For Help
Topic: Change added days to years, help pls? Topic is solved
Replies: 8
Views: 2673

Change added days to years, help pls? Topic is solved

I really need this to work: Clipsave := Clipboard Clipboard := "" Send, {Ctrl down}c{Ctrl up} ClipWait, 0.5 Past := Clipboard Clipboard := Clipsave RegExMatch(Past, "^(\d{2})\.(\d{2})\.(\d{4})$", D) if !D1 return Date := D3 . D2 . D1 EnvAdd, Date, 14, D FormatTime, Clipboard, % Date, dd.MM.yyyy retu...
by Krd
26 Jun 2020, 06:53
Forum: Ask For Help
Topic: Search for multiple words in Clipboard, How? Topic is solved
Replies: 2
Views: 949

Search for multiple words in Clipboard, How? Topic is solved

^z:: Send,{Ctrl Down}c{Ctrl Up} Sleep, 1000 Haystack := Clipboard Needle := "A","B","C" If InStr(Haystack, Needle) MsgBox, Found Else MsgBox, Not found return How can I make this work? I have tried many variants and can't figure out more than one word to search for. I want to search for words that ...
by Krd
26 Jun 2020, 03:03
Forum: Scripts and Functions
Topic: Mouse And Keyboard Macro Recorder
Replies: 105
Views: 84866

Re: Mouse And Keyboard Macro Recorder

Anyone know how to change the mouse to Clicks instead of Mouseclick?

https://www.autohotkey.com/docs/commands/Click.htm
by Krd
22 Jun 2020, 08:26
Forum: Ask For Help
Topic: What is wrong with my "shortcut"? Topic is solved
Replies: 2
Views: 685

Re: What is wrong with my "shortcut"? Topic is solved

Thank you so much. I could not understand the prefix or natie key, lol.
But you sir are a good teacher :D

I really appreciate your help as always!

Go to advanced search