Hi,
In my clipboard i have
"ShipmentReference" "Name" "Attention" "Address1" "Address2" "City" "StateProv" "PostalCode" "Country" "Phone" "Email" "ServiceCode" "ShipmentInsuranceFreight" "CurrencyCode" "PackageCount" "PackageReference" "PackageWeight" "WeightUnit" "Length" "Width" "Height" "DimensionsUnit" "ItemSKU" "ItemQuantity" "ItemUnitPrice" "ItemDescription" "ItemCountryOfOrigin" "ItemHSCode" "Commercial Clearence" "VendorName" "VenderAddress1" "VendorAddress2" "VendorCity" "VendorStateProv" "VendorPostalCode" "VendorCountry""85800000000000748710" "AgnÞs AUFEVRE" "" "Street" " " "citu" "50" "'postcode" "FR" "phone" "email" "LGINTBPIP""" "EUR" "1" "85800000000000748710" "0.5010" "Kilos" "28.5" "15.5" "5" "cm" "MS25356" "1.000" "29.13" "Product" "CN" "7117190090" "" "company name " "street" "Chalgrove " "Oxfordshire" "" "'postcode" "GB"
From $DataSetTable | ConvertTo-Csv -NoType -Del "
t" | Clip;`
If I call
$comps = (Get-Clipboard).Split("`t");
Write-Host $comps [0];
I get
ShipmentReference
If I call
$comps = (Get-Clipboard).Split("`n")
Write-Host $comps [0];
I get
"ShipmentReference" "Name" "Attention" "Address1" "Address2" "City" "StateProv" "PostalCode" "Country" "Phone" "Email" "ServiceCode" "ShipmentInsuranceFreight" "CurrencyCode" "PackageCount" "PackageReference" "PackageWeight" "WeightUnit" "Length" "Width" "Height" "DimensionsUnit" "ItemSKU" "ItemQuantity" "ItemUnitPrice" "ItemDescription" "ItemCountryOfOrigin" "ItemHSCode" "Commercial Clearence" "VendorName" "VenderAddress1" "VendorAddress2" "VendorCity" "VendorStateProv" "VendorPostalCode" "VendorCountry"
I want to be able put that into a 3dimensional array so I can say
[1,1] is "ShipmentReference"
[1,2] is "Name"
[2,1] is "AgnÞs AUFEVRE"
What is the best way of going about this. I have tried to reference the table itself without copying to clipbaord but that doersnt work so found tbhe only way to see the data is to copy the table to the clipboard.
Any help appreciated.