StringInStr - can this script be faster? (texts files included)

[mikell]

kylomas,
I did but in this case the time saving is really negligible - 0.1 sec for a total time of 3.7 sec on my old machine 

[kylomas]

I would love to hear jchd's comments on our two very different approaches to this problem (sub select vs join)...

[mikell]

Yes. But I believe that the OP wants the complete concerned lines in standard.txt to be returned, because if they want only the (Director, Year) part then using Scripting.Dictionary on the 2 arrays1D would be a better way

[Italiano]

Hi guys, sorry for no feedback yet, but i am sick... 39 fever and i almost see pink dancing elephants in my room :/ 

I see there are many answers... i will look better for them (and i will reply) next days when i will be fine. Thx to everybody, much appreciated and greetings from italy!

[Italiano]

Yes. But I believe that the OP wants the complete concerned lines in standard.txt to be returned, because if they want only the (Director, Year) part then using Scripting.Dictionary on the 2 arrays1D would be a better way

yes

I admit that I'm trying your code but it does not show any result... i guess it must be a problem on my side but I can't understand where. I am using SciTE-Lite  Version 3.5.4 and I have both sqlite.au3 and array.au3

Building arrays = 0.0068 seconds
SQLite global work = 0.0761 seconds
Formatting = 0.0000 seconds
Total time = 0.0831 seconds
+>19:10:28 AutoIT3.exe ended.rc:0
>Exit code: 0    Time: 1.798

 

it's what i get, but i suppose that i should get the results in the final arraydisplay, which does not appear at all...  

Now i try to understand what is wrong in my configuration but being sick is little more complicated than usual

 

Edited January 7, 2016 by Italiano

[Trong]

Download SQLite:

http://www.sqlite.org/2016/sqlite-dll-win32-x86-3100000.zip
http://www.sqlite.org/2016/sqlite-dll-win64-x64-3100000.zip

Unzip, copy and rename!
Change code, run and check:
 

If @AutoItX64 Then
    _SQLite_Startup(@ScriptDir & "\SQLite3_x64.dll")
Else
    _SQLite_Startup(@ScriptDir & "\SQLite3.dll")
EndIf
If @error Then
    MsgBox(0, "SQLite Error", "SQLite3.dll Can't be Loaded!")
    Exit -1
EndIf
ConsoleWrite("_SQLite_LibVersion=" & _SQLite_LibVersion() & @CRLF)

 

Edited January 7, 2016 by Trong

[guinness]

Download SQLite:

http://www.sqlite.org/2016/sqlite-dll-win32-x86-3100000.zip
http://www.sqlite.org/2016/sqlite-dll-win64-x64-3100000.zip

 

Only the one shipped with AutoIt, is guaranteed to be supported by the AutoIt team.

[BrewManNH]

That's the beauty of SQLite, backwards compatibility. As long as you're using the same or higher version, the commands should be the same, and the database files should always be readable backwards.

[Trong]

Let me know, I do not find sqlite in Autoit folder!
Path or link to download SQLite by AutoIt, ..
Or is it already embed into autoit, but why not load?

Edited January 7, 2016 by Trong

[AdamUL]

Look in the Help File for _SQLite_Startup.  The link is in the remarks.  

 

Adam

[Trong]

Thanks AdamUL 

[mikell]

Italiano,
Once you are sure that you have SQLite.dll, please check the path of both txt files. In my code there is no path because I placed them in the script folder 

[Italiano]

Italiano,
Once you are sure that you have SQLite.dll, please check the path of both txt files. In my code there is no path because I placed them in the script folder 

Amazing! this is FAST! if i think that i was doing that horrible script, i feel really dumb Now i am studying that logic, but i trust and i almost sure the results are what i needed )))

Seriously, i had no idea this could be done so quickly!

If i should compile the script, I suppose i should embed just the dll file, right?

Thank you Mykell and thanks to everybody gave their time to help. I hope someday i will be good enough to help too

[mikell]

f i should compile the script, I suppose i should embed just the dll file, right?

Right. You can't rely on the fact that SQLite.dll will be at the right place when needed (depending on the use)

Glad I could help ( © Melba) 

[Italiano]

 

#include <Array.au3>

$t0 = TimerInit()
Local $aStandard = StringRegExp(FileRead(@ScriptDir & '\standard.txt'), "(?m)^(.*)\(([^\)]+).*$", 3)
;_ArrayDisplay($aStandard)
Local $aStandard2D[UBound($aStandard)/2][2]
For $i = 0 to UBound($aStandard)-1 step 2
   $aStandard2D[$i/2][0] = $aStandard[$i]
   $aStandard2D[$i/2][1] = $aStandard[$i+1]
Next
;_ArrayDisplay($aStandard2D)

 

Ehm, sorry to bump this   I played with your great code, but i need again help cause i am not sure to understand the stringregexp I updated the code according to my needs and something little changed about what is inside textfile "standard.txt"

before it looked like this:

-2: Livello Del Terrore (Khalfoun, 2007)
... Altrimenti Ci Arrabbiamo! (Fondato, 1974)

and the regex above was great... now it little changed to this:

-2: Livello Del Terrore (Khalfoun, 2007)|3571968
... Altrimenti Ci Arrabbiamo! (Fondato, 1974)|195145

So basically, after the year, i have a code which i need too :/ i would like to have in the array also a third value, after title and the "director, year"... just i am not sure how to get it... any help, pls?

If i'm understanding quite fine autoit commands, i admit that regexp is like chinese to me...

Sorry for my bad english

[mikell]

OK 
So if you have a standard.txt file like this

-2: Livello Del Terrore (Khalfoun, 2007)|3571968
something! (Author, 1965) ; lets say there is no code here
... Altrimenti Ci Arrabbiamo! (Fondato, 1974)|195145

Then you can use a slightly modified regex and array formatting :

#include <Array.au3>

Local $aStandard = StringRegExp(FileRead(@ScriptDir & '\standard.txt'), "(?m)^(.*)\((.+)\)\|?(\d*).*$", 3)
;_ArrayDisplay($aStandard)
Local $aStandard2D[UBound($aStandard)/3][3]
For $i = 0 to UBound($aStandard)-1 step 3
   $aStandard2D[$i/3][0] = $aStandard[$i]
   $aStandard2D[$i/3][1] = $aStandard[$i+1]
   $aStandard2D[$i/3][2] = $aStandard[$i+2]
Next
_ArrayDisplay($aStandard2D)

Edit
Apparently you are healed and healthy now 

Edited January 9, 2016 by mikell

[Italiano]

Thx Mikell, as usual   I hope someday I will manage to understand regex better than now... at the moment it's very foggy in my mind... i understood just now that I must put every "group" inside ()

Hopefully i will not need again to bump this thread

Yes, I am healthy now, but my english still sucks