Title: Export-Csv should have option to suppress quotes · Issue #8890 · PowerShell/PowerShell · GitHub
Open Graph Title: Export-Csv should have option to suppress quotes · Issue #8890 · PowerShell/PowerShell
X Title: Export-Csv should have option to suppress quotes · Issue #8890 · PowerShell/PowerShell
Description: Export-Csv should have option to suppress quotes By default Export-Csv puts quotes around all fields. This isn't always necessary and some programs even have problems reading the results. For example, Export-Csv will quote a numbers and ...
Open Graph Description: Export-Csv should have option to suppress quotes By default Export-Csv puts quotes around all fields. This isn't always necessary and some programs even have problems reading the results. For examp...
X Description: Export-Csv should have option to suppress quotes By default Export-Csv puts quotes around all fields. This isn't always necessary and some programs even have problems reading the results. For e...
Opengraph URL: https://github.com/PowerShell/PowerShell/issues/8890
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Export-Csv should have option to suppress quotes","articleBody":"# Export-Csv should have option to suppress quotes\r\n\r\nBy default Export-Csv puts quotes around all fields. This isn't always necessary and some programs even have problems reading the results. For example, Export-Csv will quote a numbers and dates:\r\n\r\n```…,\"227\",\"6/1/2018 12:00:00 AM\"\t```\r\n\r\nSome programs then interpret the data as strings, which generally isn't the intent.\r\n\r\nAlso, quotes generally aren't required for strings (unless they contain the delimiter character). \r\n\r\nNot using quotes (unless needed) would improve usability with other applications and reduce file output size.\r\n\r\n# Proposed technical implementation details\r\n\r\nA couple options:\r\n\r\n1) An option -UseQuotes which could be Never, Always, or (optionally) AsNeeded, StringsOnly.\r\n2) An option to specify the quote character/string, then I could do -Quote \"\" to suppress quotes.\r\n3) An option -QuoteFields \u003cfield-list> to specify which fields to quote.\r\n\r\nAny of these would solve my current problem (all of them would be a complete, powerful solution to most problems).\r\n\r\n## -UseQuotes options details:\r\n* Never - don't quote anything, ever.\r\n* Always - quote everything (current behavior).\r\n* AsNeeded - only quote fields that need it (they contain a delimiter character).\r\n* StringsOnly - quote all strings, but not numbers, dates, or other non-string values.\r\n\r\nThere's a good argument to be made that the default behavior should be AsNeeded or StringsOnly as they tend to be more compatible with other applications; however, it would be different and could break existing usage.\r\n","author":{"url":"https://github.com/DavidBerg-MSFT","@type":"Person","name":"DavidBerg-MSFT"},"datePublished":"2019-02-13T20:33:53Z","url":"https://github.com/PowerShell/PowerShell/issues/8890"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:c782c3b4-3aab-a38f-33b2-d659a8984095 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | A0EC:3B6F2C:24858E:3324BB:6AFD7262 |
| html-safe-nonce | 63131207258f6880e94ac458778049482a23abc1e15ebccb88ea7a0c9b4f354a |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBMEVDOjNCNkYyQzoyNDg1OEU6MzMyNEJCOjZBRkQ3MjYyIiwidmlzaXRvcl9pZCI6IjI4ODI4MjAwMTgzODEwOTE0MjYiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | e0eaa6b58b9ef7a6513857f4796ad9a690aa83cb231e219080081ca5292d4561 |
| hovercard-subject-tag | issue:409989146 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/PowerShell/PowerShell/8890/issue_layout |
| twitter:image | https://opengraph.githubassets.com/212979e68e65f37ba143b498a8d7d6639be0d953fc08aa377c74a97568579126/PowerShell/PowerShell/issues/8890 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/212979e68e65f37ba143b498a8d7d6639be0d953fc08aa377c74a97568579126/PowerShell/PowerShell/issues/8890 |
| og:image:alt | Export-Csv should have option to suppress quotes By default Export-Csv puts quotes around all fields. This isn't always necessary and some programs even have problems reading the results. For examp... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | DavidBerg-MSFT |
| hostname | github.com |
| expected-hostname | github.com |
| None | e54006cf2b96d1ac260960edd10003132911469ccd1ec99c9803119fe2a4e032 |
| turbo-cache-control | no-preview |
| go-import | github.com/PowerShell/PowerShell git https://github.com/PowerShell/PowerShell.git |
| octolytics-dimension-user_id | 11524380 |
| octolytics-dimension-user_login | PowerShell |
| octolytics-dimension-repository_id | 49609581 |
| octolytics-dimension-repository_nwo | PowerShell/PowerShell |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 49609581 |
| octolytics-dimension-repository_network_root_nwo | PowerShell/PowerShell |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 5be0bf2b8cf26f8897d31e6bc3c232d328b12a54 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width