Casey

[RESOLVED] RegEx Resource

5 posts in this topic

#1 ·  Posted (edited)

Hello,

I'm back to working on my RegEx skills and trying to come up with something to reformat file directory / file paths that are coming from other applications so that I can feed the resulting list into another script that I came up with. My problem is that I have been testing my RegEx by using https://regex101.com/ with PCRE(PHP). To date it has worked well for me, however, I have hit a stumbling block. In the example below the RegEx on line 158 when applied to pattern "C:\S\*" should pass through the ELSE on line 162 and then get trapped by line 175.

Instead, it flows to 159 and then 188. I'm going cross-eyed and I can't spot the problem in the RegEx, If you have a moment and have experience with this kind of thing, would you please take a quick look and tell me what you think is wrong besides this being probably the ugliest way to go about a simple task.

The task is simply end up with either a full file path or a directory without a trailing backslash. Thanks in advance,

Casey

EDIT - [RESOLVED]  Replaced script block with corrections, though I am not at all happy with how sloppy it is and I am going to rewrite after learning quite a bit in the process. I just didn't want to leave a truly broken bit out here on the site.

#include <Array.au3>
#include <Constants.au3>
#include <MsgBoxConstants.au3>



; Where we have a full path to a file including file extension
Local $aArray[1] = ["C:\S\File.txt"]


_ArrayAdd($aArray, "C:\S\Some File.txt")
_ArrayAdd($aArray, "C:\Windows\winsxs\FileMaps\program_files_business_objects_common_3.5_bin_d4f3c306b49748a7.cdf-ms")
_ArrayAdd($aArray, "C:\S\0_Some File.cdf-ms")

; Where the training backslash is missing from a directory - This is good, DirGetSize format
_ArrayAdd($aArray, "C:\S")


; Where the training backslash exists on a directory - This is bad, DirGetSize won't work
_ArrayAdd($aArray, "C:\S\")

; Where the path ends in an * - This is bad, DirGetSize value less than C:\S
_ArrayAdd($aArray, "C:\S\*")

; Where the path ends in an *.* - This is real bad, DirGetSize won't work and attrib is a laundry list
_ArrayAdd($aArray, "C:\S\*.*")

_ArrayAdd($aArray, "C:\Program Files (x86)\No Problem\*.*")
_ArrayAdd($aArray, "C:\Program Files (x86)\No Problem\*.txt")
_ArrayAdd($aArray, "C:\Program Files (x86)\No Problem\a.txt")
_ArrayAdd($aArray, "C:\Users\A.Problem")
_ArrayAdd($aArray, "C:\Users\A.Problem")


;========================================================================================================================================

; A must as we are working with Winternal's Process Monitor Output and Handles.exe Output
Local $bArray = _ArrayUnique($aArray)

_ArrayColInsert($bArray, 1)
_ArrayColInsert($bArray, 2)

_ArrayDisplay($bArray, "Array @ Beginning")

;========================================================================================================================================

$Cnt = 0
For $i = 0 To UBound($bArray) - 1
    $Cnt = $Cnt + 1
Next
$Cnt = $Cnt - 1

For $i = 1 To $Cnt

    Local $LenRegEx = 0
    Local $LenArrayItem = 0

    ;Test for something that might look like a file extension, greedy, but length of file extension and composition is unknown
    ;Example: C:\Windows\winsxs\FileMaps\program_files_business_objects_common_3.5_bin_d4f3c306b49748a7.cdf-ms

    Global $cArray = StringRegExp($bArray[$i][0], "^\w:\\[\. \( \) \w \\ \-]+\\[\w \\ \.-]+", 2)
    If @error <> 0 Then
        ;_MsgBox("FIRST REGEX FAILED AND SET ERROR" & @CRLF & @CRLF & "$LenRegEx = " & @CRLF & @CRLF & $LenRegEx & @CRLF & @CRLF & "$LenArrayItem = " & @CRLF & @CRLF & $LenArrayItem)
        $cArray = StringRegExp($bArray[$i][0], "^\w:\\[\. \(\)\w\\\-]+\\[^\w \\ -]+", 2)
        If @error <> 0 Then
            Local $LenRegEx = 0
            Local $LenArrayItem = StringLen($bArray[$i][0])
            ;_MsgBox("SECOND REGEX FAILED AND SET ERROR" & @CRLF & @CRLF & "$LenRegEx = " & @CRLF & @CRLF & $LenRegEx & @CRLF & @CRLF & "$LenArrayItem = " & @CRLF & @CRLF & $LenArrayItem)
            $bArray[$i][2] = @ScriptLineNumber
        Else
            Local $LenRegEx = StringLen($cArray[0])
            Local $LenArrayItem = StringLen($bArray[$i][0])
            ;_MsgBox("$LenRegEx = " & @CRLF & @CRLF & $LenRegEx & @CRLF & @CRLF & "$LenArrayItem = " & @CRLF & @CRLF & $LenArrayItem)
            $bArray[$i][2] = @ScriptLineNumber
        EndIf
    Else
        Local $LenRegEx = StringLen($cArray[0])
        Local $LenArrayItem = StringLen($bArray[$i][0])
        ;_MsgBox("$LenRegEx = " & @CRLF & @CRLF & $LenRegEx & @CRLF & @CRLF & "$LenArrayItem = " & @CRLF & @CRLF & $LenArrayItem)
        $bArray[$i][2] = @ScriptLineNumber
    EndIf

    If $LenRegEx == $LenArrayItem Then
        ;_MsgBox("Some are FileGetSize and DirGetSize Compatible " & @CRLF & @CRLF & $bArray[$i][0] & @CRLF & @CRLF & $cArray[0])
        $bArray[$i][2] = @ScriptLineNumber

        $IsThereAnAsterixOrSlash = StringMid($bArray[$i][0], $LenArrayItem, 1)

        ;_MsgBox("$IsThereAnAsterixOrSlash = " & $IsThereAnAsterixOrSlash)
        $bArray[$i][2] = @ScriptLineNumber

        Select
            Case $IsThereAnAsterixOrSlash = "*"

                If StringMid($bArray[$i][0], ($LenArrayItem - 1), 2) = "\*" Then
                    ;_MsgBox("A \* existed " & StringLen($bArray[$i][0]))
                    $bArray[$i][2] = @ScriptLineNumber
                    $bArray[$i][1] = StringTrimRight($bArray[$i][0], 2)
                    ;_ArrayDisplay($bArray, @ScriptLineNumber)
                Else

                    $IsItAsterixDotAsterix = StringMid($bArray[$i][0], $LenArrayItem - 3, 4)
                    ;_MsgBox("$IsItAsterixDotAsterix:   " & $IsItAsterixDotAsterix)
                    $bArray[$i][2] = @ScriptLineNumber

                    If $IsItAsterixDotAsterix = "\*.*" Then
                        ;_MsgBox("\*.* " & @CRLF & @CRLF & $IsItAsterixDotAsterix)
                        ;_MsgBox("StringLen($bArray[$i][0] " & @CRLF & @CRLF & StringLen($bArray[$i][0]) & @CRLF & @CRLF & "StringLen($bArray[$i][0] - 4 " & @CRLF & @CRLF & StringLen($bArray[$i][0]) - 4)
                        $bArray[$i][1] = StringTrimRight($bArray[$i][0], StringLen($bArray[$i][0]) - 4)
                        ;_MsgBox("A * or \ existed " & $bArray[$i][0])
                        $bArray[$i][2] = @ScriptLineNumber
                        ;_ArrayDisplay($bArray, @ScriptLineNumber)

                    ElseIf StringTrimRight($IsItAsterixDotAsterix, 2) = "\*" Then
                        ;_MsgBox("\* " & @CRLF & @CRLF & $IsItAsterixDotAsterix)
                        ;_MsgBox("StringLen($bArray[$i][0] " & @CRLF & @CRLF & StringLen($bArray[$i][0]) & @CRLF & @CRLF & "StringLen($bArray[$i][0] - 4 " & @CRLF & @CRLF & StringLen($bArray[$i][0]) - 2)
                        $bArray[$i][1] = StringTrimRight($bArray[$i][0], StringLen($bArray[$i][0]) - 2)
                        ;_MsgBox("A * or \ existed " & $bArray[$i][0])
                        $bArray[$i][2] = @ScriptLineNumber
                        ;_ArrayDisplay($bArray, @ScriptLineNumber)

                    Else
                        ;_MsgBox("We shouldn't be able to see this so what's wrong?: " & @CRLF & @CRLF & $bArray[$i][0])
                        $bArray[$i][2] = @ScriptLineNumber
                    EndIf
                EndIf

            Case $IsThereAnAsterixOrSlash = "\"
                ;_MsgBox("A * or \ existed " & $bArray[$i][0])
                $bArray[$i][2] = @ScriptLineNumber
                $bArray[$i][1] = StringTrimRight($bArray[$i][0], StringLen($bArray[$i][0]) - 1)
                ;_ArrayDisplay($bArray, @ScriptLineNumber)

            Case Else
                ;_MsgBox("We have a good full file path. " & @CRLF & @CRLF & $bArray[$i][0])
                $bArray[$i][2] = @ScriptLineNumber
                $bArray[$i][1] = $bArray[$i][0]
                ;_ArrayDisplay($bArray, @ScriptLineNumber)
        EndSelect

    Else
        ;===========================================================================================================================
        ;Check if no possible file extension by looking if returned regex length equals array element string length


        ;_MsgBox("$LenRegEx = " & @CRLF & @CRLF & $LenRegEx & @CRLF & @CRLF & "$LenArrayItem = " & @CRLF & @CRLF & $LenArrayItem)
        $bArray[$i][2] = @ScriptLineNumber
        ; Could be: C:\S\*

        $dArray = StringRegExp($bArray[$i][0], "^(.+\\\w+)", 2)
        If @error <> 0 Then
            ;_MsgBox("SECOND REGEX FAILED AND SET ERROR")
            $bArray[$i][2] = @ScriptLineNumber
        EndIf

        #cs
            Full String Match On:

            C:\S
            C:\S [return matches source, we have a winner and we already like this guy so we will do nothing to him]

        #ce

        $LenRegEx = StringLen($dArray[0])
        $LenArrayItem = StringLen($bArray[$i][0])

        ;_MsgBox("$LenRegEx = " & @CRLF & @CRLF & $LenRegEx & @CRLF & @CRLF & "$LenArrayItem = " & @CRLF & @CRLF & $LenArrayItem)
        $bArray[$i][2] = @ScriptLineNumber

        If $LenRegEx == $LenArrayItem Then

            ;_MsgBox("DIR NO SLASH " & $dArray[0])
            $bArray[$i][2] = @ScriptLineNumber
            $bArray[$i][1] = $bArray[$i][0]
            ;_ArrayDisplay($bArray, @ScriptLineNumber)

        Else

            $eArray = StringRegExp($bArray[$i][0], "^\w:\\[\. \( \) \w \\ \-]+\\[^\w \\ \.-]+", 2)
            ;$eArray = StringRegExp($bArray[$i][0], "(?x) ^ \w : \\ [\. \(\)\w\\-]+ \\ [^\w\\ \.-]+", 2) [Same results as above] Thank you for the insight JCHD
            If @error <> 0 Then
                ;_MsgBox("THIRD REGEX FAILED AND SET ERROR")
                $bArray[$i][2] = @ScriptLineNumber
                $eArray = StringRegExp($bArray[$i][0], "^\w:\\[\. \( \) \w \\ \-]+\\[^\w \\ \.-]?", 2) ; C:\S\
                If @error <> 0 Then
                    ;_MsgBox("FOURTH REGEX FAILED AND SET ERROR")
                    $bArray[$i][2] = @ScriptLineNumber
                    $eArray = StringRegExp($bArray[$i][0], "^\w:\\[\. \(\)\w\\\-]+\\[^\w \\ -]+", 2) ; C:\S\*.* -FAILING BC LINE 136 "^(.+\\\w+)" HAS PARTIAL MATCH
                    If @error <> 0 Then
                        ;_MsgBox("FIFTH REGEX FAILED AND SET ERROR")
                        $bArray[$i][2] = @ScriptLineNumber
                        Local $LenRegEx = 0
                        Local $LenArrayItem = StringLen($bArray[$i][0])
                        ;_MsgBox("INSANE ->" & $bArray[$i][0] & "<-")
                        $bArray[$i][2] = @ScriptLineNumber
                    Else
                        Local $LenRegEx = StringLen($eArray[0])
                        Local $LenArrayItem = StringLen($bArray[$i][0])
                        ;_MsgBox($eArray[0] & @CRLF & @CRLF & $LenRegEx)
                        $bArray[$i][2] = @ScriptLineNumber
                        ;_ArrayDisplay($bArray, @ScriptLineNumber)
                    EndIf
                Else
                    Local $LenRegEx = StringLen($eArray[0])
                    Local $LenArrayItem = StringLen($bArray[$i][0])
                    ;_MsgBox($eArray[0] & @CRLF & @CRLF & $LenRegEx)
                    $bArray[$i][2] = @ScriptLineNumber
                    ;_ArrayDisplay($bArray, @ScriptLineNumber)
                EndIf
            Else
                Local $LenRegEx = StringLen($eArray[0])
                Local $LenArrayItem = StringLen($bArray[$i][0])
                ;_MsgBox($eArray[0] & @CRLF & @CRLF & $LenRegEx)
                $bArray[$i][2] = @ScriptLineNumber
                ;_ArrayDisplay($bArray, @ScriptLineNumber)
                If $LenRegEx = $LenArrayItem Then
                    $bArray[$i][1] = $bArray[$i][0]
                    $bArray[$i][2] = @ScriptLineNumber
                    ;_MsgBox("$LenRegEx = " & @CRLF & @CRLF & $LenRegEx & @CRLF & @CRLF & "$LenArrayItem = " & @CRLF & @CRLF & $LenArrayItem)
                    ;_ArrayDisplay($bArray, @ScriptLineNumber)
                EndIf
            EndIf

            $fArray = StringRegExp($bArray[$i][0], "^\w\:\\[\. \(\)\w\\\-]+\\[^\w \\ -]+", 2)
            If @error <> 0 Then
                $bArray[$i][2] = @ScriptLineNumber
                ;_ArrayDisplay($bArray, @ScriptLineNumber)
            Else
                Local $LenRegEx = StringLen($fArray[0])
                Local $LenArrayItem = StringLen($bArray[$i][0])
                ;_MsgBox($fArray[0] & @CRLF & @CRLF & $LenRegEx)
                $bArray[$i][2] = @ScriptLineNumber
                ;_ArrayDisplay($bArray, @ScriptLineNumber)
                If $LenRegEx = $LenArrayItem Then
                    $bArray[$i][1] = StringTrimRight($bArray[$i][0], 4)
                    ;$bArray[$i][1] = $bArray[$i][0]
                    $bArray[$i][2] = @ScriptLineNumber
                    ;_MsgBox("$LenRegEx = " & @CRLF & @CRLF & $LenRegEx & @CRLF & @CRLF & "$LenArrayItem = " & @CRLF & @CRLF & $LenArrayItem)
                    $LenRegEx = 0
                    ;_ArrayDisplay($bArray, @ScriptLineNumber)
                Else
                    $gArray = StringRegExp($bArray[$i][0], "^\w\:\\[\. \(\)\w\\\-]+\\[^ \\ -]+", 2)
                    If @error <> 0 Then
                        $bArray[$i][2] = @ScriptLineNumber
                        ;_ArrayDisplay($bArray, @ScriptLineNumber)
                    Else
                        Local $LenRegEx = StringLen($gArray[0])
                        Local $LenArrayItem = StringLen($bArray[$i][0])
                        ;_MsgBox("$LenRegEx = " & @CRLF & @CRLF & $LenRegEx & @CRLF & @CRLF & "$LenArrayItem = " & @CRLF & @CRLF & $LenArrayItem)
                        If $LenRegEx = $LenArrayItem Then
                            $bArray[$i][1] = StringTrimRight($bArray[$i][0], 6)
                            ;$bArray[$i][1] = $bArray[$i][0]
                            $bArray[$i][2] = @ScriptLineNumber
                            ;_MsgBox("$LenRegEx = " & @CRLF & @CRLF & $LenRegEx & @CRLF & @CRLF & "$LenArrayItem = " & @CRLF & @CRLF & $LenArrayItem)
                            ;_ArrayDisplay($bArray, @ScriptLineNumber)
                        EndIf
                    EndIf
                EndIf
            EndIf

            $IsThereAnAsterixOrSlash = StringMid($bArray[$i][0], $LenArrayItem, 1)

            ;_MsgBox($bArray[$i][0] & @CRLF & @CRLF & "->" & $IsThereAnAsterixOrSlash & "<-")
            $bArray[$i][2] = @ScriptLineNumber

            Select
                Case $LenRegEx == $LenArrayItem

                    #cs
                        Full String Match On:

                        C:\S\
                        C:\S\*
                    #ce
                    If $IsThereAnAsterixOrSlash = "*" Then
                        $bArray[$i][1] = StringTrimRight($bArray[$i][0], 2)
                        ;_MsgBox("An * existed " & $bArray[$i][0])
                        $bArray[$i][2] = @ScriptLineNumber
                        ;_ArrayDisplay($bArray, @ScriptLineNumber)
                    EndIf

                    If $IsThereAnAsterixOrSlash = "\" Then
                        $bArray[$i][1] = StringTrimRight($bArray[$i][0], 1)
                        ;_MsgBox("A \ existed " & $bArray[$i][0])
                        $bArray[$i][2] = @ScriptLineNumber
                        ;_ArrayDisplay($bArray, @ScriptLineNumber)
                    Else
                        ;_MsgBox("OUCH Who Knows")
                        $bArray[$i][2] = @ScriptLineNumber
                    EndIf


                Case Else
                    ;_MsgBox("We shouldn't be able to see this so what's wrong?: " & @CRLF & @CRLF & $bArray[$i][0])
                    $bArray[$i][2] = @ScriptLineNumber

            EndSelect

        EndIf
    EndIf
    ;===========================================================================================================================
Next

$bArray[0][0] = "*** Source Format of Text ***"
$bArray[0][1] = "*** Reformatted Text ***"
$bArray[0][2] = "*** Script Line Exited ***"

_ArrayDisplay($bArray, "Array @ End")





; #FUNCTION# ====================================================================================================================
; CUSTOM MSGBOX - ADDS SCRIPT LINE NUMBER AS TITLE FOR DEBUGGING - ADD MSGBOXES TO SOURCE IF NEEDED

; EXAMPLE MSGBOX
;_MsgBox("The value for $stringinput is not as expected == " & $stringinput)

Func _MsgBox($sText, $sTitle = @ScriptLineNumber)
    MsgBox(0, "-" & $sTitle & "-", $sText)
EndFunc   ;==>_MsgBox
; ===============================================================================================================================

 

Edited by Casey

Share this post


Link to post
Share on other sites



Let's see:

#include <Array.au3>

$eArray = StringRegExp("C:\S\*", "(?x) ^ \w : \\ [\. \(\)\w\\-]+ \\ [^\w\\ \.-]+", 2)
_ArrayDisplay($eArray)

 


This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.
Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe here
RegExp tutorial: enough to get started
PCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta.

SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.
SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.
An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.
SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)
A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!
SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)

Share this post


Link to post
Share on other sites

JCHD,

Thank you and I am very sorry. Like I said I was getting cross eyed and the string that I'm stuck on is "C:\S\" and not "C:\S\*". My RegEx actually works on that one. The problem is that it also works on the other using tester. I'll also say that though it is going to take me a bit to read through your version, it looks a bit more intelligent and I think I'll be able to learn something from it. I spotted an error in trimming a string so I have updated my code above and I also see more problems down the line which is fine and why I am working through this exercise.

Casey

Share this post


Link to post
Share on other sites

This is the + quantifier right at the end of the pattern that prevents matching on "C:\S\" by requiring at least one char after the last backslash.


This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.
Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe here
RegExp tutorial: enough to get started
PCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta.

SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.
SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.
An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.
SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)
A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!
SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)

Share this post


Link to post
Share on other sites

Oh, you on it! I had to add another bit of logic after it failed out on the third RegEx. Added a fourth replacing the + with a ? to catch "C:\S\". I'll update my code in a minute. Now just need to tweak the logic to get rows 8-10 and I'll be done. Thanks a million for catching that.

Casey

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Similar Content

    • Trong
      By Trong
      Hi,
      I need help string RegEx to get string from CREATE to GO
      #include <StringConstants.au3> ;~ Global $fileSQL1 = @ScriptDir & "\fileSQL1.sql" ;~ Global $fileSQL2 = @ScriptDir & "\fileSQL2.sql" Global $tmpSQLfile = @TempDir & "\tmpFile.sql" OnAutoItExitRegister("_OnExit") _SetTMPsql() If Not FileExists($tmpSQLfile) Then OnAutoItExitUnRegister("_OnExit") Exit MsgBox(48, "/!\", "File: " & $tmpSQLfile & @CRLF & " is not Exists!", 3) EndIf Global $ContentSQLfile = FileRead($tmpSQLfile) _Start() Func _Start() Local $aArray, $iOffset = 1, $stringRegExp = '(?i)CREATE(.*?)GO' While 1 $aArray = StringRegExp($ContentSQLfile, $stringRegExp, $STR_REGEXPARRAYMATCH, $iOffset) If @error Then MsgBox(48, "StringRegExp Error " & @error, "+> StringRegExp: " & $stringRegExp & @CRLF & @CRLF & "=> With STRING:" & @CRLF & @CRLF & $ContentSQLfile) ExitLoop EndIf $iOffset = @extended For $i = 0 To UBound($aArray) - 1 MsgBox(0, "RegExp Test with Option 1 - " & $i, $aArray[$i]) Next WEnd EndFunc ;==>_Start Func _SetTMPsql() Local $tmpSQLContent = "" $tmpSQLContent &= "USE [Master]" & @CRLF $tmpSQLContent &= "GO" & @CRLF $tmpSQLContent &= "" & @CRLF $tmpSQLContent &= "CREATE DATABASE [Sales] ON PRIMARY " & @CRLF $tmpSQLContent &= "( NAME = N’Sales’, FILENAME = N’\FSASQLDBSales.mdf’ , " & @CRLF $tmpSQLContent &= " SIZE = 2GB , MAXSIZE = 8GB, FILEGROWTH = 1GB )" & @CRLF $tmpSQLContent &= "LOG ON " & @CRLF $tmpSQLContent &= "( NAME = N’Sales_log’, FILENAME = N’\FSASQLDBSales_log.ldf’ , " & @CRLF $tmpSQLContent &= " SIZE = 1GB , MAXSIZE = 2GB , FILEGROWTH = 10%)" & @CRLF $tmpSQLContent &= "GO" & @CRLF $tmpSQLContent &= "" & @CRLF $tmpSQLContent &= "USE [Sales]" & @CRLF $tmpSQLContent &= "GO" & @CRLF $tmpSQLContent &= "" & @CRLF $tmpSQLContent &= "-- Table Product" & @CRLF $tmpSQLContent &= "CREATE TABLE [dbo].[Product]" & @CRLF $tmpSQLContent &= "(" & @CRLF $tmpSQLContent &= " [ProductId] [uniqueidentifier] DEFAULT NEWID() NOT NULL," & @CRLF $tmpSQLContent &= " [ProductName] [nchar](50) NULL," & @CRLF $tmpSQLContent &= " [ProductDescription] [nchar](3000) NULL," & @CRLF $tmpSQLContent &= " [ProductPrice] MONEY NULL" & @CRLF $tmpSQLContent &= ") ON [PRIMARY]" & @CRLF $tmpSQLContent &= "GO" & @CRLF $tmpSQLContent &= "" & @CRLF $tmpSQLContent &= "-- Table Sales" & @CRLF $tmpSQLContent &= "CREATE TABLE [dbo].[Sales]" & @CRLF $tmpSQLContent &= "( " & @CRLF $tmpSQLContent &= " [SaleId] [uniqueidentifier] DEFAULT NEWID() NOT NULL," & @CRLF $tmpSQLContent &= " [SaleName] [nchar](50) NULL," & @CRLF $tmpSQLContent &= " [SaleInfo] [nchar](3000) NULL," & @CRLF $tmpSQLContent &= " [SaleMoney] MONEY NULL" & @CRLF $tmpSQLContent &= ") ON [PRIMARY]" & @CRLF $tmpSQLContent &= "GO" & @CRLF $tmpSQLContent &= "" & @CRLF $tmpSQLContent &= "SET ANSI_NULLS ON" & @CRLF $tmpSQLContent &= "GO" & @CRLF $tmpSQLContent &= "SET QUOTED_IDENTIFIER ON" & @CRLF $tmpSQLContent &= "GO" & @CRLF $tmpSQLContent &= "" & @CRLF $tmpSQLContent &= "-- The End" & @CRLF Local $hOpen = FileOpen($tmpSQLfile, 2 + 8 + 128) FileWrite($hOpen, $tmpSQLContent) Return FileClose($hOpen) EndFunc ;==>_SetTMPsql Func _OnExit() Exit FileDelete($tmpSQLfile) EndFunc ;==>_OnExit  
      mikell
       
    • MuffinMan
      By MuffinMan
      I am trying to rebuild an old single signon script that has been giving us a bit of trouble lately.  I didn't write it and it was written in another script language.  If the target program is already open it will have the current user's last name as part of the window text, which I am trying to compare against the user name to see if I should just WinActivate or Process Close and start the program over.  I will be provided the username like "jones", or "smith" and the title check works fine for last names (with no spaces), but if the last name DOES contains spaces, say "Nom De Plume", then all I will be given as a username is "nomdeplume".  Is there any way (via a regex maybe) that I can still check the text on the screen and somehow ?  I have been reading about the Advanced (4) mode of WinTitleMatchMode, but it is over my head.  Any help is appreciated.  Here is a small reproducer script:
      Opt("WinTitleMatchMode", -1) Run("Notepad") WinWait("[CLASS:Notepad]", "", 10) Send ("Smith" & @CRLF & "Jones" & @CRLF & "Nom De Plume" & @CRLF) If WinExists("[CLASS:Notepad]", "jones") Then MsgBox(0,"FOUND","Found Jones") EndIf If WinExists("[CLASS:Notepad]", "nomdeplume") Then MsgBox(0,"FOUND","Found Nom De Plume") EndIf  
    • rcmaehl
      By rcmaehl
      Currently I have
      Switch StringLen($Serial) Case 0 Return "Please Enter a Serial #" Case 1 To 6 Return "UNKNOWN or INCORRECT" Case 7 Select Case StringLeft($Serial, 2) = "79" $Valid = "Device 1" Case StringLeft($Serial, 3) = "350" $Valid = "Device 2" Case StringRegExp($Serial, "72[HR](.*)") ; Match 72H and 72R $Valid = "Device 3" Case Else $Valid = "UNKNOWN or INCORRECT" EndSelect Case 8 Select Case StringRegExp($Serial, "\d[A-Z](.*)") ; Match a Digit (0-9), then a letter $Valid = "Device 4 short format" Case Else $Valid = "UNKNOWN or INCORRECT" EndSelect EndSwitch Which I'm using to match a number followed by a letter then any number of digits up to a string length of 8 characters.
      However I don't want it to match strings such as 1234A123 only 1D123456
      Is there anyway to do this using a flag or am I limited to having to use StringLeft()?
    • Chiitus
      By Chiitus
      Hello guys, i have a problem in this regex because its not groupping right.
      Look:
      (\d{1,2}\s?[\055|\056|\057|\134]\s?\d{1,2}(\s?[\055|\056|\057|\134]\s?\d{2,4})?) It checks for day or dayday, month or monthmonth, yearyear or yearyearyear+year.
      separated with or without space and the characters "\/.-"
      But, a problem! I tried to regex the date with or without the "separator + year" Eg: 05/05 or 05/05/05, but when i have 05/05/05, regex are separating 05/05 and /05
      Iam using group "()" wrong?
      Need help here
      Thx adv!
      ~~EDIT:
      Script used: (from autoitscript.com/forum/topic/129697-split-string-by-regular-expression/#comment-901335)
      #include <Array.au3> Local $sString = ClipGet() ; Extract the delimiters $aDelim = StringRegExp($sString, '(\d{1,2}\s?[\055|\056|\057|\134]\s?\d{1,2}(\s?[\055|\056|\057|\134]\s?\d{2,4})?)', 3) ; Split the string on the delimiters $aParts = StringSplit(StringRegExpReplace($sString, '(\d{1,2}\s?[\055|\056|\057|\134]\s?\d{1,2}(\s?[\055|\056|\057|\134]\s?\d{2,4})?)', "$<SEPARATOR>$"), "$<SEPARATOR>$", 3) ; Add the delimter to the start of the part For $i = 0 To UBound($aParts) - 1 ;$aParts[$i + 1] = $aDelim[$i] & $aParts[$i + 1] Next ; Set the count $aParts[0] = UBound($aParts) ; Display the result _ArrayDisplay($aParts) _ArrayDisplay($aDelim) Results in array: (the array parts in all string is ok; but the string delimitator himself is getting separated in every string that have year together)

      String used as test:
      Cheers.
    • TheDcoder
      By TheDcoder
      Hello , I am trying to find the best way to spilt this string:
      :<nick>!<host mask> PRIVMSG <channel/nick> :<message> into an array like this:
      Global Enum $SENT_BY, $HOST_MASK, $SENT_TO, $MESSAGE $aArray[$SENT_BY] = "<nick>" $aArray[$HOST_MASK] = "<host mask>" $aArray[$SENT_TO] = "<channel/nick>" $aArray[$MESSAGE] = "<message>" (Stuff between <> is dynamic)
      I can do that with inefficient code but I think it is possible to do it more efficiently with RegEx
       
      Thanks in Advance! TD
       
      P.S Yeah, that is the raw format of a message received in IRC