Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to convert raw text to the CSV (Comma Separated Values) in PowerShell?
We have a raw text example and to convert it into the CSV values, we can use below code.
Example
PS C:\> $text = "This is a PowerShell latest version" PS C:\> $text.Replace(' ',',')Output
This,is,a,PowerShell,latest,version
If there are multiple spaces between the keywords then the above replace command would go wrong. For example,
Example
PS C:\> $text = "This is a PowerShell latest version" PS C:\> $text.Replace(' ',',')Output
This,,is,,,a,,,,PowerShell,latest,version
So we can use another method as shown below.
$text -replace '\s+',' '
In the above command, \S indicates the whitespace and + indicates the occurrence of the specific character. So more than one white space will be removed.
Next is to add the comma (,) between them so the whole command will be as below.
($text -replace '\s+',' ') -replace (' ',',')
Updated on: 20-Nov-2020
788 Views
Advertisements