![]() What's interesting is that i examined the output for both files (your way and the follwoing way) and didn't see any hidden chars that your way inserts thus telling PowerShell to parse it properly. ![]() Script that I had tried earlier but it didn't produce the correct output. I had used the 'here-string' earlier and didn't get the correct results and after seeing your solution I see it has to do with the way the content is prepped and exported. Import-csv C:\temp\test1.csv -Delimiter '|' | ft -Wrap If you can generate here-strings from your data source? would only map's the text "before" this double quote."Īnd a PSObject -Property Carter"' 'Description'='"PowerShell maps this whole text to the description column."'} "Bob Segel" "PowerShell would only map's the text "before" this double quote." "John Carter" "PowerShell maps this whole text to the description column." Import-csv C:\temp\test1.csv -Delimiter '|' | ft -AutoSize $temp | export-csv 'c:\temp\test1.csv' -Delimiter '|' -NoTypeInformation $temp =New-Object PSObject -Property Segel"' 'Description'=$herestring} Generating 'here' strings appears could be a solution: would only map's the text "before" this double PSObject -Property Carter"' 'Description'='"PowerShell maps this whole text to the description column."'} Until I find a better alternative, I am thinking to export all the data as XML and use 'CDATA' to export the values for the 'description' column. Any other out of the box PowerShell functionality that i can leverage? Solution I am thinking of:: So while importing, PowerShell treats all the text in the 'description' column as a single string (including While exporting, is there a way to use 'here-string' like symbol that can be inserted infront of the text for the 'descrition' column. I need to keep the original formating intact. 1997, Ford, E350, 'Super, ''luxurious'' truck' So a csv file needs those double quotes to be escaped (by using another set of double quotes), because the double quote by itself denotes the boundaries of a field. ![]() While exporting, I do not want to manipulate the description data, like replace double quotes with single quote. Each of the embedded double-quote characters must be represented by a pair of double-quote characters. But I need to find a way to map all of the text (including quotes and post double quotes) to the column 'description'. I understand that, while reading column value, PowerShell would treat double quotes as the end of string. In PowerShell, i run the follwoing command: Import-csv -Path "c:\\sample-input.csv" -Delimiter "|" To import the c:sqlitecity. "Bob Segel"| "PowerShell would only map the text "before" this double quote." "John Carter"|"PowerShell maps this whole text to the description column." Note, the 'description' column can contain any rich html syntax (, class="some-name", qouble/single quotes, carriage returnd, end of line, etc.): Via PowerShell, I export the follwoing two column 'csv' file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |