Issue: When performing an export of any report within CoreView and opening the resulting CSV, the full output for each record is contained within a single cell. The results are not broken up into discrete fields making the information difficult to view.
Cause: CoreView uses the pipe character (|) as the default delimiter, and not the comma character. This is because output fields such as DisplayName often include commas, resulting in a false break within a field. The pipe character is not by default recognized within Excel as a delimiter, causing a multi field record to be displayed within a single cell.
Resolution 1: You can change the output delimiter to be a comma by expanding the “Action Pane” arrow in the extreme upper right corner. Click More. Click Settings. Change both the company delimiter and the user delimiter to the comma character.
Resolution 2: If utilizing a comma in your output creates issues, you can instruct Excel to use the pipe character as the delimiter. First rename the output file from “CoreView.csv” to “CoreView.txt”. Open Excel, and direct Excel to open the file from its internal file menu. Once you click open, this will prompt the Excel “Text Import Wizard” to automatically launch. Verify that “Delimited” is selected. Click, “My data has headers”. Click Next. Uncheck “Tab”. Check “Other”. Type | into the “Other” field. Click “Next”. Click “Finish”. Your data should now be correctly rendered within Excel.
You may also launch the Excel “Text Import Wizard” from the “Data” tab and selecting, “From Text” on the ribbon. Launching the wizard in this fashion removes the file rename step.