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