Recherche avancée

Sur d’autres sites (5672)

• 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

  


• avfilter/vf_colorcorrect : fix average analyze mode and add minmax mode

  20 août 2021, par Paul B Mahol

  avfilter/vf_colorcorrect : fix average analyze mode and add minmax mode
  

  • [DH] doc/filters.texi
  • [DH] libavfilter/vf_colorcorrect.c

• tcp : set socket buffer sizes before listen/connect/accept

  9 janvier 2017, par Joel Cunningham

  tcp : set socket buffer sizes before listen/connect/accept
  From e24d95c0e06a878d401ee34fd6742fcaddeeb95f Mon Sep 17 00:00:00 2001
  
  From : Joel Cunningham <joel.cunningham@me.com>
  
  Date : Mon, 9 Jan 2017 13:37:51 -0600
  
  Subject : [PATCH] tcp : set socket buffer sizes before listen/connect/accept
  Attempting to set SO_RCVBUF and SO_SNDBUF on TCP sockets after connection
  
  establishment is incorrect and some stacks ignore the set call on the socket at
  
  this point.  This has been observed on MacOS/iOS.  Windows 7 has some peculiar
  
  behavior where setting SO_RCVBUF after applies only if the buffer is increasing
  
  from the default while decreases are ignored.  This is possibly how the incorrect
  
  usage has gone unnoticed
  Unix Network Programming Vol. 1 : The Sockets Networking API (3rd edition, seciton 7.5) :
  "When setting the size of the TCP socket receive buffer, the ordering of the
  
  function calls is important.  This is because of TCP’s window scale option,
  
  which is exchanged with the peer on SYN segments when the connection is
  
  established. For a client, this means the SO_RCVBUF socket option must be
  
  set before calling connect.  For a server, this means the socket option must
  
  be set for the listening socket before calling listen.  Setting this option
  
  for the connected socket will have no effect whatsoever on the possible window
  
  scale option because accept does not return with the connected socket until
  
  TCP’s three-way handshake is complete.  This is why the option must be set on
  
  the listening socket. (The sizes of the socket buffers are always inherited from
  
  the listening socket by the newly created connected socket)"
  Signed-off-by : Joel Cunningham <joel.cunningham@me.com>
  
  Signed-off-by : Michael Niedermayer <michael@niedermayer.cc>
  

  • [DH] libavformat/tcp.c