Is there a PowerShell equivalent of `paste` (i.e., horizontal file concatenation)? [duplicate]

by

A few months ago, I submitted a proposal for including a Join-Object cmdlet to the standard PowerShell equipment #14994.

Besides complexer joins based on a related property, the idea is to also be able to do a side-by-side join (by omiting the -On parameter).
Taken this Paste command in Linux as an example:

$State="Arunachal Pradesh",
'Assam',
'Andhra Pradesh',
'Bihar',
'Chhattisgrah'

$Capital="Itanagar",
'Dispur',
'Hyderabad',
'Patna',
'Raipur'

Installation

Install-Module -Name JoinModule

Creating a side-by-side array:

1..5 |Join $State |Join $Capital |% { "$_" }

1 Arunachal Pradesh Itanagar
2 Assam Dispur
3 Andhra Pradesh Hyderabad
4 Bihar Patna
5 Chhattisgrah Raipur

Creating a side-by-side object:

1..5 |Join $State |Join $Capital -Name Number, State, Capital

Number State             Capital
------ -----             -------
     1 Arunachal Pradesh Itanagar
     2 Assam             Dispur
     3 Andhra Pradesh    Hyderabad
     4 Bihar             Patna
     5 Chhattisgrah      Raipur

Concatenate (“Paste”) two objects:

$List = $State |Join $Capital -Name State, Capital
$Id = ConvertFrom-Csv @'
Id
A
B
C
D
E
'@

$Id |Join $List

Id State             Capital
-- -----             -------
A  Arunachal Pradesh Itanagar
B  Assam             Dispur
C  Andhra Pradesh    Hyderabad
D  Bihar             Patna
E  Chhattisgrah      Raipur

References:

Please give a 👍 if you support the proposal to Add a Join-Object cmdlet to the standard PowerShell equipment (#14994)

More Related Contents:

  1. String handling from Powershell script
  2. Powershell script to delete 15 days old .txt files [duplicate]
  3. How to create a zip archive with PowerShell?
  4. How to run an EXE file in PowerShell with parameters with spaces and quotes
  5. Use PowerShell to run virus scan on multiple servers
  6. Fastest Way to get a uniquely index item from the property of an array
  7. PowerShell IE9 ComObject has all null properties after navigating to webpage
  8. PowerShell script runs when pasted into the PowerShell window, but not when run from shortcut
  9. save PSCredential in the file
  10. How do I write a PowerShell script that accepts pipeline input?
  11. PowerShell’s Invoke-RestMethod equivalent of curl -u (Basic Authentication)
  12. How do I Start a job of a function i just defined?
  13. Remove files and foldes on Azure before a new deploy from VSTS
  14. try, catch doesent seem to work
  15. Specifying *.xls filter in Get-ChildItem also returns *.xlsx results
  16. Inserting a date into SQL
  17. Run a [Code] or PowerShell script in Inno Setup compiler
  18. Replacing a string with a variable in Get-ADGroup
  19. Create an incrementing variable from 2 variables in PowerShell
  20. Temporarily change powershell language to English?
  21. How to print environment variables to the console in PowerShell?
  22. How to recursively remove all empty folders in PowerShell?
  23. PowerShell script won’t execute as a Windows scheduled task
  24. How do I set an env variable in PowerShell if it doesn’t exist?
  25. What is the difference between [pwsh] and [Powershell Integrated Console] on VS Code?
  26. PowerShell App.Config
  27. Change DCOM config security settings using Powershell
  28. Are you able to use PtrToStringAuto to decrypt a secure string in Powershell 7 on macOS?
  29. Getting “Can’t find the drive. The drive called ‘IIS’ does not exist.”
  30. Prevent trailing newline in PowerShell Out-File command

Leave a Comment