AutoHotkey Community

maitresin

Corrected mod and it works

CheckDigit := (10 - ((3*OddSum + EvenSum) mod 10)) mod 10

should be

CheckDigit := mod((3*OddSum + EvenSum),10)

maitresin

The below code should calculate all the odd number of 06420011589 and multiply by 3, then calculate the even number. Add the odd number total 57 to the even number total 17 to make 74. Then you need to round up to the next 10s value and make the difference between it and the 74. 80 - 74 should retur...

maitresin

Perfect

Thanks!

maitresin

Great Thank! It works as expected but for the first code when the value from File-1.txt is like "1ABC" or contains other characters like a "-ABC" it does not work

maitresin

The Master List

File-1.txt: (3 Bytes) Downloaded 23 times

File to match with the Master List

Result-1.txt: (3 Bytes) Downloaded 20 times

Expected result

MasterListing.txt: (32 Bytes) Downloaded 29 times

maitresin

I have a master file that return the equivalent of a string. MasterListing.txt Exemple of that file: ABC = B.2 DEF = B.5 HIJ = B.12 I also have multiple file: File-1.txt File-2.txt File-3.txt ... and so on but can be 1, 2, 10 or more files with same patern. There is only 1 value per file. In those f...

maitresin

It is the Fileread that does not get character correctly when there is an accent I did change only this section of the line: </span></spanàé>ABC Group</div></div> Test1 work because the variable did store your input correctly FileRead1 = <div class="geodir-post-meta-container bsui sdel-298db276" ><d...

maitresin

ok I found. Sorry my mistake there was a special character with an accent

Regex does not recognize accent characters like "é,à,è..."

maitresin

Like this it works but from the file it does not work.

I did copy the line exactly as per the file and it work if I put it manually in the variable FileRead1, but from the file it refuse to work.

Is there linefeed or carriage that block from file?

maitresin

Hi, What is wrong with my grep? It should not msgbox "ABC Group"? This is a line in the download.htm file <div class="geodir-post-meta-container bsui sdel-298db276" ><div class="geodir_post_meta text-left d-block geodir-field-banniere"><span class="geodir_post_meta_icon geodir-i-select" style=""><i ...

maitresin

Hi, How to compare a same variable with its previous stored value? In the below how would File1 accomplish this? If File1 stored value is higher than its previous stored value continue until new stored value is lower example: File1 = 1.05, continue, File1 = 2.89, continue, File1 = 3.53, continue, Fi...

maitresin

Perfect! thanks you!

maitresin

Hello, I need help with the below synthax "s)2022-08-25,(.*)," should not return only 2.050000 ? What should be the correct synthax to return only the in between value? anything between "2022-08-25," and "," see code FileRead, FileRead1, file.txt g:=grep(fileread1, "s)2022-08-25,(.*),") for i, v in ...

maitresin

Hi, I need to loop from target folder and sub folder for all picture that contain the text from the list.txt IE: 99-2554, 75-8875 Folders can have picture .jpg, .gif, .tif... named 99-2254-1, 99-2254-2, fullsize-99-2254... that's why I do not put prefix or suffix or file extension. If the file conta...

maitresin

Code: Select all

fileread, Missing, Missing.txt
sort, Missing, D,

filedelete, Missing.txt

Fileappend,
(
%Missing%
),Missing.txt

maitresin

Hi, I'm trying to sort a list but it does not sort correctly or same as Excel does. Any idea on how to sort same as Excel does? Example of data in the list sorted by Sort, varname 94-996 95-305 B256-13508 B455-32438 13-041 13-044 13-061 13-15 Example of data in the list sorted by Excel 13-041 13-044...

maitresin

Hi, Thanks for help on this script it is very appreciated Clarification: my approach finds values in newer file not found in previous file regardless of their rows! Yes, regardless of the rows .text Yes, because everything paste in the file is in "TEXT" value, regardless if it is numbers or text.

maitresin

Perfect it's working!

However, I'm wondering why it show value with 6 digit in the file.txt ? EX: 23.000000

Value should be as text and return 23 and not 23.000000

With a Xl.Range("A:A").copy it return 23 and not 23.000000

Anyway to fix this in your code?

Thanks!

maitresin

Hi,

I want to delete all double value, not only the duplicate. Keep only non duplicate.

EX:
1
1
2
3
3
4
4
5

Result : 2, 5

Sort, var, U

Remove duplicate and keep all unique but I need to keep only non duplicate. What is the option for this??

Thanks

maitresin

Hi, I want to make a script and compile it into executable and run it through task scheduler each +1hour 10 minutes Idea is to compare file.xls with the previous one and create a .txt with the new value Loop column "A" of file.xls with the previous one and store the new value and past them into the ...

Search found 45 matches

Re: UPC function sum of even and odd number Topic is solved

UPC function sum of even and odd number Topic is solved

Re: Match a file value with another file value Topic is solved

Re: Match a file value with another file value Topic is solved

Re: Match a file value with another file value Topic is solved

Match a file value with another file value Topic is solved

Re: Help with Grep issue Topic is solved

Re: Help with Grep issue Topic is solved

Re: Help with Grep issue Topic is solved

Help with Grep issue Topic is solved

Compare stored variable value inside a loop

Re: Regexmatch & Grep issue

Regexmatch & Grep issue

Help with loop for files from a list in folders and copy them

Re: Sort function same as Excel?

Sort function same as Excel?

Re: Compare Excel file and make a list of new value

Re: Compare Excel file and make a list of new value

Remove all duplicate from list

Compare Excel file and make a list of new value