Jump to content

csv split and if why not recognize a content?

Recommended Posts

hi guys  i have a csv , i attached ,   i  have create a script for insert inside of db 


Func _main()

    Local $hTimer = TimerInit()
    Local $aLListinoComp = FileReadToArray(@ScriptDir & "\WEB-SITE\CGross\xls\listino.csv") ; listino completo
    If @error Then
        MsgBox($MB_SYSTEMMODAL, "", "There was an error reading the file. @error: " & @error) ; An error occurred reading the current script file.

    For $i = 0 To UBound($aLListinoComp) - 1

        Local $aLPart = StringSplit($aLListinoComp[$i], ';')
Local $sStrippedString = StringStripCR($aLListinoComp[3])
        If $sStrippedString = "Prezzo Listino" Then
            MsgBox(0, '', 'de made ')

            If $aLListinoComp[3] = "Prezzo Listino" Then

            ElseIf $aLListinoComp[3] = "" Then

            Local $sLSyntax = "INSERT INTO ge_CGross_listino (codice,DescProd,Produttore,DescCatMerc,Dispo,PrezzoSiSconto,Grossista)" & _
            " VALUES ('" & $aLListinoComp[1] & "','" & $aLListinoComp[2] & "','" & $aLListinoComp[8] & "','" & $aLListinoComp[9] & "','" & $aLListinoComp[6] & "','" & $aLListinoComp[5] & "', 'CompGross' )"
            Local $sLQueryResult = _Mysql_Query($sLSyntax)
            If @error Then
            SetError(@error, @extended, $ADO_RET_FAILURE)

    Local $fDiff = TimerDiff($hTimer) ; Find the difference in time from the previous call of TimerInit. The variable we stored the TimerInit handlem is passed as the "handle" to TimerDiff.
    ConsoleWrite("Time Difference= " & $fDiff)
    MsgBox($MB_SYSTEMMODAL, "Time Difference", $fDiff)

the problem always popup _arraydisplay($aLPart) also when inside of  $aLListinoComp[3] = "Prezzo Listino"  , why  do this ??? 



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
  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...