To convert ECL output into CSV format, you can follow these steps:
Save the ECL output into a file, for example "output.txt".
Open a text editor like Notepad or Sublime Text.
Copy the content of the "output.txt" file into the text editor.
Replace all the delimiters with commas (","). For example, if the delimiter is a tab, replace it with a comma.
Save the modified content as a CSV file, for example "output.csv".
Open the CSV file with a spreadsheet software like Microsoft Excel or Google Sheets.
Verify that the data is properly formatted and in the correct columns.
You can also use a dedicated tool like HPCC's ECL Watch to export your data in CSV format directly from the platform.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2023-07-04 09:11:32 +0000
Seen: 9 times
Last updated: Jul 04 '23
The content inside my buttons is not visible on the screen.
What causes peep and pop operations to produce invalid outputs?
What does the message "No tests found" from playwright VSCode mean?
Why does SVG fail to display in Safari, but functions properly in Chrome?
How to use hyperlinks in SharePoint List within Teams?
What is the meaning of the build error message "NoClassDefFoundError: org/apache/xpath/XPathAPI"?
What is the correct way to load the jQuery fullcalendar plugin in a div that is not visible?