How can I export a report to a csv file with different field separators?
When running table based reports in the Natural HR report builder you can export the report to a comma separated variable (csv) file. As its name suggests, the data in the file is separated by commas ' , '
If you open the exported csv file in MS Excel, the data will look like this the image on the left. Opening the same csv file in MS Notepad, you can see in the image on the right, the data in both is separated by commas ' , '
There may be circumstances where the report you export requires a different separator than a comma, e.g. if the data you are exporting is going to be imported into another system. You can set this when building a new table report or editing an existing table report by going to
Reporting > Report builder
at the bottom of the screen you will see the 'Table options' section and from the 'CSV field separator dropdown you can select
- Tab
- Space
- Pipe
- Semicolon
- Other...
if you select 'Other', enter your preferred character in the box marked 'Single character'
In this example I have used ' & ' as the separator character
after clicking on 'Edit report' to save the changes, and then 'View report' to run, you can export the data to csv. If you open the csv file in MS Excel, the data will look like this the image on the left. Opening the same csv file in MS Notepad you can see in the image on the right, in both files the data is separated by the ' & ' character
Comments
0 comments
Please sign in to leave a comment.