Recherche avancée

Sur d’autres sites (10046)

• Docs : Added 'Browser-Specific Known Issues' section

  21 novembre 2014, par JamesMGreene

  Docs : Added ’Browser-Specific Known Issues’ section
  Ref #459
  Also did some minor formatting updates to the "instructions.md".
  

• indeo : Bound-check before applying transform

  12 juillet 2013, par Luca Barbato

  indeo : Bound-check before applying transform
  Reported-by : Mateusz "j00ru" Jurczyk and Gynvael Coldwind
  
  CC : libav-stable@libav.org
  

  • [DH] libavcodec/indeo4.c
  • [DH] libavcodec/indeo5.c
  • [DH] libavcodec/ivi_common.c
  • [DH] libavcodec/ivi_common.h

• How to count variable in for loop in power shell

  17 avril 2020, par ilham zacky

  I am using powershell and i have got a for loop running each time 3 variables get printed, for now, loop runs 5 times. I need to get the count like $i++

  



  This is a part of my code

  



  $file = "D:\edl\input\CPExport.xlsx"
$sheetName = "Sheet1"
$objExcel = New-Object -ComObject Excel.Application
$workbook = $objExcel.Workbooks.Open($file)
$sheet = $workbook.Worksheets.Item($sheetName)
$objExcel.Visible = $false
$rowMax = ($sheet.UsedRange.Rows).count
$nu = 0
$rowcount = 000 

for ($i = 0; $i -le $rowMax - 1; $i++) {
    $id = $sheet.Cells.Item($rowName + $i, $colName).text
    $name = $sheet.Cells.Item($rowAge + $i, $colAge).text
    $subtitle = $sheet.Cells.Item($rowCity + $i, $colCity).text
    $jpgId = "$id.jpg"
    $videoId = "$id.mp4"
    $audioId = "$id.m4a"
    $duration1 = if ((ffmpeg -i $audioId 2>&1 | Out-String) -match 'Duration:\s+([\d:"."]+)') { $matches[1] };
    $duration2 = if ((ffmpeg -i $jpgId 2>&1 | Out-String) -match 'Duration:\s+([\d:"."]+)') { $matches[1] };
    $duration = if ((ffmpeg -i $videoId 2>&1 | Out-String) -match 'Duration:\s+([\d:"."]+)') { $matches[1] };

    $newduration = ("$duration").Replace(".", ":")
    $newduration1 = ("$duration1").Replace(".", ":")
    $newduration2 = ("$duration2").Replace(".", ":")

    $out1 = ""
    $out2 = ""
    $out = ""
    $nu++
    $rowcount++
    if ($newduration1) {

        if ($nu -eq 1) {
            $audioA = "00:00:00:00"
        }

        $audioB = Add-Frame -Base $newduration1 -Offset $audioA
        $out1 = "$rowcount" + "  " + "AX" + "   " + "AA" + "     " + "C" + "   " + "00:00:00:00" + " " + $newduration1 + "   " + $audioA 
    }

    if ($newduration2) {

        $imagecal = Add-Frame -Base $imageA -Offset "00:00:06:00"
        $imageB = $imagecal
        $out = "$rowcount" + "  " + "AX" + "   " + "V" + "      " + "C" + "   " + "02:00:05:15" + " " + $newduration2 + "   " + " " + $imageA 
    }


    if ($newduration) {

        $videoA = $imageB
        $videocal = Add-Frame -Base $newduration -Offset $videoA
        $videoB = $videocal
        $out2 = "$rowcount" + "  " + "AX" + "   " + "AA/V" + "   " + "C" + "   " + "00:00:00:00" + " " + $hh + "   " + " " + $videoA 
    }
    else {
        $videoB = ""
    }
    $gg = $out1 + "`n" + "`n" + $out + "`n" + "`n" + $out2 + "`n"
    echo $gg

    $gg | Out-File -FilePath d:\edl\input\output.txt -Append
}
#close excel file
$objExcel.quit()


  



  i have echo $gg
this is the output

  



  1 AX   AA     C   00:00:00:00 00:00:03:48   
1  AX   V      C   02:00:05:15 02:00:11:15
1  AX   AA/V   C   00:00:00:00 00:00:06:93 
2  AX   AA     C   00:00:00:00 00:00:03:46   
2  AX   V      C   02:00:05:15 02:00:11:15    
2  AX   AA     C   00:00:00:00 00:00:03:46  
3  AX   AA     C   00:00:00:00 00:00:03:52   
3  AX   V      C   02:00:05:15 02:00:11:15   
3  AX   AA/V   C   00:00:00:00 00:00:06:93    
4  AX   AA     C   00:00:00:00 00:00:03:21   
4  AX   V      C   02:00:05:15 02:00:11:15    
4  AX   AA     C   00:00:00:00 00:00:03:21   
5  AX   AA     C   00:00:00:00 00:00:03:05   
5  AX   V      C   02:00:05:15 02:00:11:15    
5  AX   AA/V   C   00:00:00:00 00:00:06:93    


  



  Output prints only 1-5 
I need it to be printed 1 - 15

  



  any suggestions ?

  



  thank you for reading