About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Question & Answer
Question
How to convert an Excel file to CSV format
Answer
How do you convert an Excel file to CSV format with "|" as delimiter?
- Save the xls file as type - csv (comma delimited)
- Open the csv file in wordpad
- Replaced all '' -> '|'
(created by Suneeta Chandrasekaran last modified by Ann Begun on 2011-09-28T21:44:35.000Z)
"
[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSUP5C","label":"DemandTec"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
More support for:
DemandTec
Software version:
All Versions
Document number:
772945
Modified date:
08 December 2018
UID
ibm10772945
Manage My Notification Subscriptions