PowerShell

CSV Enable Quotes

Explains the EnableQuotes property for the CSV class. PowerShell

Add-Type -Path "C:\chilkat\ChilkatDotNet47-x64\ChilkatDotNet47.dll"

$success = $false

# The CSV in this example contains this:   test;"123;abc";xyz

$csv = New-Object Chilkat.Csv

# EnableQuotes is $true by default, but we'll explicitly set to $true here:
$csv.EnableQuotes = $true
$success = $csv.LoadFile("qa_data/csv/enableQuotes.csv")

# Show row 0, column 0
$($csv.GetCell(0,0))
# Show row 0, column 1
$($csv.GetCell(0,1))
# Show row 0, column 2
$($csv.GetCell(0,2))

# Output is: 
#  test
#  123;abc
#  xyz

# -------------------------------------------
# Turn off EnableQuotes and see what happens:

$csv2 = New-Object Chilkat.Csv
$csv2.EnableQuotes = $false

$success = $csv2.LoadFile("qa_data/csv/enableQuotes.csv")

$($csv2.GetCell(0,0))
$($csv2.GetCell(0,1))
$($csv2.GetCell(0,2))
$($csv2.GetCell(0,3))

# Output is:

#  test
#  "123
#  abc"
#  xyz