Problem with Number function

[_Func]

Hello everyone,

I'm a new user of Autoit and my first post is with the Number() function.

I have a text file with differents values

A;2
A;2.78
A;"3.9"
A;"3.11"
A;"3.11"
A;7.9
A;N/A
A;N/A
A;N/A
A;7.95
A;8.04
A;8.10
A;8.22
A;8.15
A;8.15
A;8.15
A;9.6
A;9.44
A;"9.59"
A;11
A;14
A;15
A;15.6
A;N/A
A;15.88

I tested the IsNumber() function but it doesn't work with quotes "". If I use Number()  and after IsNumber(), N/A return 1. I don't understand...

 

[JLogan3o13]

Welcome to the forum @_Func. Can you please post the code you're using? There are, as with most languages, innumerable ways to skin the proverbial cat; seeing how you are going about this process will help us help you.

[_Func]

$file = @DesktopDir & "\Data.txt"

$hFileOpen = FileOpen($file, 0)

If $hFileOpen = -1 Then
    MsgBox(16, "Erreur", "Impossible d'ouvrir le fichier.")
    Exit
EndIf

While True
    Local $line = FileReadLine($hFileOpen)
    If @error = -1 Then ExitLoop
    $result = StringTrimLeft($line, 2)

    If IsNumber(Number($result)) Then
;~  If IsFloat($result) Then
        ConsoleWrite("$result :" & $result & @LF)
    EndIf
WEnd

FileClose($hFileOpen)

 

[Nine]

#include <Array.au3>

Local $aList = FileReadToArray("Test5.txt"), $aTemp
_ArrayDisplay($aList)
For $i = 0 to UBound ($aList) - 1
  $aTemp = StringRegExp($aList[$i], "A;\""*(\d+\.*\d*)", 1)
  $aList[$i] = IsArray($aTemp) ? Number($aTemp[0]) : 0
Next
_ArrayDisplay($aList)

 

[_Func]

I hadn't thought of using StringRegExp() and FileReadToArray()

I don't understant the line with ? and : but, I will read the help file.

Thank you

[bogQ]

@_Func ? : are a shorter way for inline if then else

  $aList[$i] = IsArray($aTemp) ? Number($aTemp[0]) : 0

is

; something similar to this
$aList[$i] = somefunc()
Func somefunc()
  If IsArray($aTemp) Then return Number($aTemp[0])
  return 0
EndFunc

https://www.autoitscript.com/autoit3/docs/keywords/Ternary.htm

 

[mistersquirrle]

Here's something to keep in mind regarding data types and comparing them (or even checking if they are a specific type): https://www.autoitscript.com/autoit3/docs/intro/lang_operators.htm#:~:text=Comparing different datatypes

Another thing to look at is: https://www.autoitscript.com/autoit3/docs/functions/VarGetType.htm

Maybe not entirely useful here, but it's along the same lines and is important to keep in mind.

[mikell]

Not sure that using Number() is necessary while \d is used in StringRegExp ...

#Include <Array.au3>

$res = StringRegExp(FileRead("Data.txt"), '(\d+(?:\.\d+)?)', 3)
_ArrayDisplay($res)

 

[Nine]

Well SRE retracts string, if you truly want a number as the variable (ex. for further sort) then it is recommended.