$date = 0 $amount = 1 $price = 2 $order_type = 3 $side = 4 $symbol = 5 $state = 6 $fee = 7 $strategy_type = 8 $lineCount = 0 $inputFile = if ($args.count -ige 1) { $args[0] } else { "C:\PATH_TO_PIONEX_CSV" } $outputFile = if ($args.count -ige 2) { $args[1] } else { "C:\PATH_TO_KOINLY_CSV" } $output = foreach($line in Get-Content $inputFile) { $currentLine = $line.Split(',') if ($lineCount -eq 0) { "Date","Sent Amount","Sent Currency", "Received Amount", "Received Currency", "Fee Amount", "Fee Currency", "Net Worth Amount", "Net Worth Currency", "Label", "Description", "TxHash" -join ',' } else { $symbolArray = $currentLine[$symbol].Split('_') $description = $currentLine[$strategy_type], $currentLine[$state], $currentLine[$side], $currentLine[$order_type] -join ' - ' if ($currentLine[$side] -eq "BUY") { $currentLine[$date], $currentLine[$amount], $symbolArray[1], ($currentLine[$amount] / $currentLine[$price]), $symbolArray[0], $currentLine[$fee], $symbolArray[0],"","","",$description,"" -join ',' } else { $currentLine[$date], ($currentLine[$amount] / $currentLine[$price]), $symbolArray[0], $currentLine[$amount], $symbolArray[1], $currentLine[$fee], $symbolArray[1],"","","",$description,"" -join ',' } } $lineCount++ } $output | Out-File -Encoding utf8 -FilePath $outputFile