Convert csv file to base64 format in Powershell

Question

I have a Python script to convert the CSV file to base64.

import base64
file = open("D:\test.csv", 'rb')
base64_csv = base64.b64encode(file.read()).decode('utf-8')

I need to write a Powershell to do the same thing due to company recruitment. I tried this module but doesn't work:

$csv = Import-Csv -Path "D:\test.csv"
base64_csv = [System.Convert]::ToBase64String([char[]]$csv)

Cannot convert the "@{My CSV File content}" value of type 
"System.Management.Automation.PSCustomObject" to type "System.Char[]".

I am very new to Powershell, any help is appreciated!

Anon Coward · Accepted Answer · 2021-02-26 23:09:28Z

2

The fact the file is CSV isn't part of the processing needed to converting it to base64 representation. You should be able to simply convert the file as raw data to a base64 string:

$base64_csv = [Convert]::ToBase64String([IO.File]::ReadAllBytes("D:\test.csv"))

answered Feb 26, 2021 at 23:09

Anon Coward

11k3 gold badges31 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert csv file to base64 format in Powershell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related