Remove Duplicate lines through RegExp

[Underdogger]

Something problem from mount...What's wrong with this code?

Thanks so much

#include <Array.au3>
#include <File.au3>
Dim $aArray
$opentxt = FileOpenDialog('Choose TXT', @DesktopDir, '(*.txt)', 1, '')
$aRegExp = StringRegExp(FileRead($opentxt), "[0-9]{6,12}", 3)
$startmount = Ubound($aRegExp) ;<<<<<Maybe get wrong from here
_FileReadToArray($opentxt, $aArray)
_ArrayDelete($aArray, 0)
$newfile = _ArrayUnique($aArray)
$outputtxt = FileOpen($opentxt, 2)
_FileWriteFromArray($outputtxt, $newfile, 1)
FileClose($opentxt)
$sRegExp = StringRegExp(FileRead($opentxt), "[0-9]{6,12}", 3)
$endmount = Ubound($sRegExp) ;<<<<<And here
MsgBox(0, "Mount", "Before: " &$startmount  &@CRLF &"After: " &$endmount  &@CRLF &"Total Deplicate: " &($startmount - $endmount))

Elson

[PhoenixXL]

Does this help?

#include <Array.au3>

Local $File = "First Line" & @CR & "Second Line" & @CRLF & "first line"
Local $aRegEx = StringRegExp( $File, '[^\v]+', 3 )
If @error Then Exit -1 ;No matches

_ArrayDisplay( $aRegEx )
$aRegEx = _ArrayUnique( $aRegEx )
_ArrayDelete( $aRegEx, 0 )
_ArrayDisplay( $aRegEx )

Note that the code will terminate any null character at the SOL/EOF

Edited February 4, 2013 by PhoenixXL

[Underdogger]

Sorry...Maybe I post the wrong topic name...

It get something wrong here >>

MsgBox(0, "Mount", "Before: " &$startmount &@CRLF &"After: " &$endmount &@CRLF &"Total Deplicate: " &($startmount - $endmount))

"Before:" should :13

"After:" should :7

"Total Deplicate:" should :6

But it appeared

Before : 25

After: 13

total:12

[PhoenixXL]

you used [0-9]{6,12} as the pattern

I dont know the condition and what are you trying to achieve

"Before:" should :13

"After:" should :7

"Total Deplicate:" should :6

But it appeared

Before : 25

After: 13

total:12

What do these mean ?

[AZJIO]

http://autoit-script.ru/index.php/topic,546.0.html

http://autoit-script.ru/index.php/topic,12596.0.html

[Underdogger]

By the way, how to get the string infront of "," ?

-----------------------------------

8598437769,h1234567

1339236010,h1234567

157412635,h1234567

2310790863,h1234567yu

176887898,h1fefee4

1050122245,h1234567

2867246473,lPX3hR1

-----------------------------------

like>

8598437769

1339236010

157412635

2310790863

176887898

1050122245

2867246473

[BrewManNH]

$aArray = StringSplit('8598437769,h1234567|1339236010,h1234567|157412635,h1234567|2310790863,h1234567yu|176887898,h1fefee4|1050122245,h1234567|2867246473,lPX3hR1', "|")
For $I = 1 To $aArray[0]
     $String = StringLeft($aArray[$I], StringInStr($aArray[$I], ",") - 1)
     ConsoleWrite('@@ Debug(' & @ScriptLineNumber & ') : $String = ' & $String & @CRLF & '>Error code: ' & @error & @CRLF) ;### Debug Console
Next

[PhoenixXL]

With the spirit of Regex

;Im assuming the chars required are digits if not use . in place of \d

#include <Array.au3>

$String = "8598437769,h1234567" & @CRLF & _
"1339236010,h1234567" & @CRLF & _
"157412635,h1234567" & @CRLF & _
"2310790863,h1234567" & @CRLF & _
"1768878978,h1234567" & @CRLF & _
"1050122245,h1234567" & @CRLF & _
"2867246473,lPX3hR1" & @CRLF & _
"2310790863,h1234567" & @CRLF & _
"1768878978,h1234567" & @CRLF & _
"1050122245,h1234567" & @CRLF & _
"2867246473,lPX3hR1" & @CRLF & _
"2310790863,h1234567" & @CRLF & _
"1768878978,h1234567" & @CRLF & _
"1050122245,h1234567" & @CRLF & _
"2867246473,lPX3hR1"

;Make the Array
$String = StringRegExp( $String, "\d+(?=,)", 3)
If @error Then Exit -1 ;No Match
$String = _ArrayUnique( $String )
_ArrayDelete( $String, 0 )
_ArrayDisplay( $String )

Hope this helps

[BrewManNH]

Why use _ArrayUnique?

[Underdogger]

Yes,I got it!!!Thank you so much!!

I really want to learn reg exp better as you !!

Best Regard

[PhoenixXL]

Why use _ArrayUnique?

I got a PM with the requirements stated to remove the duplicated values

[BrewManNH]

I got a PM with the requirements stated to remove the duplicated values

Ahh, another case of someone moving the goal posts mid-game.