TopMiniSite
-
5 min readYou can execute a multi-line PowerShell script using Java by first creating a ProcessBuilder object and setting the command to "powershell.exe". Then, you can pass the script as a parameter to the ProcessBuilder object using the command line arguments. Make sure to include the "-Command" flag before the script to indicate that it is a PowerShell command. Finally, start the process and read the output if needed.
-
4 min readIn PowerShell, environment variables can be accessed through the $env: prefix followed by the name of the variable. When dealing with environment variable types in PowerShell, it is important to remember that all variable values are inherently stored as strings. This means that if you need to use an environment variable as a specific type (e.g. integer, boolean), you will need to explicitly cast or convert the value to the desired type.
-
5 min readTo split on the first occurrence using regex in PowerShell, you can use the -split operator along with a regular expression pattern that matches the first occurrence. For example, if you want to split a string $input on the first comma ,, you can do it like this: $input = "first,second,third" $parts = $input -split ",(?=.*?,)" In this example, the regex pattern ",(?=.*?,)" matches the first comma , in the string without consuming any characters after it. The (?=.*.
-
4 min readTo find the sum of two columns in PowerShell, you can use the Measure-Object cmdlet.First, import the data from the columns using Import-Csv or Get-Content, then select the two columns you want to find the sum of using Select-Object.Next, pipe the output to the Measure-Object cmdlet with the -Sum parameter to calculate the sum of the selected columns.
-
4 min readTo connect MongoDB with PowerShell, you can use the MongoDB PowerShell module. This module provides cmdlets for interacting with a MongoDB database. To connect to MongoDB using PowerShell, you first need to install the MongoDB PowerShell module using the PowerShell Gallery. Once installed, you can use the Connect-MongoDb cmdlet to establish a connection to your MongoDB database by providing the server and database details.
-
6 min readTo enable SQL filestream using Powershell, you can use the following steps:Open Powershell with administrator privileges.Load the SQL Server module by running the command: Import-Module SQLPSConnect to the SQL Server instance by running the command: $server = New-Object Microsoft.SqlServer.Management.Smo.Server("")Set the filestream access level by running the command: $server.Settings.
-
7 min readTo remotely execute a script in PowerShell, you can use the Invoke-Command cmdlet. This cmdlet allows you to run commands on remote computers. First, you need to establish a remote session using the New-PSSession cmdlet and provide the remote computer name. Then, you can use the Invoke-Command cmdlet with the -ScriptBlock parameter to specify the script you want to run remotely. Make sure to include the -Session parameter and provide the session you created earlier.
-
3 min readIn PowerShell, you can step backwards in a path by using the double dot notation. For example, if you are currently in the directory "C:\Users\John\Documents" and you want to move one level up to "C:\Users\John", you can use the command "cd ..". This will take you back one level in the directory structure. You can continue to use ".." to move further up in the directory hierarchy.
-
4 min readIn Powershell, arguments can be passed to a command line by specifying the argument values after the command name. This can be done by separating the command name and argument values with a space. Arguments can be strings, numbers, or flags that modify the behavior of the command.For example, if you have a script named "myscript.ps1" that accepts two arguments, you can run the script and pass the arguments like this: .\myscript.
-
7 min readWhen exporting data to a CSV file in PowerShell, you can separate columns by using a specific delimiter. By default, PowerShell uses a comma (,) as the delimiter when exporting to a CSV file. If you want to use a different delimiter, you can specify it using the -Delimiter parameter when using the Export-CSV cmdlet. For example, if you want to use a tab as the delimiter, you can use the following command: Export-Csv -Path "output.csv" -Delimiter "`t" -NoTypeInformation.
-
3 min readTo extract a value inside a column in a certain pattern in Oracle, you can use the REGEXP_SUBSTR function. This function allows you to extract substrings that match a specified regular expression pattern from a column.For example, if you have a column that contains text data in the following format: "Name: John", and you want to extract the value after the colon, you can use the following SQL query:SELECT REGEXP_SUBSTR(column_name, ':(.