Information on the Text Delimited Data Format

On this page:

Introduction

We offer the ability to upload files in comma-delimited text file format. Each line of text file represents a channel transmitted in a specified azimuth. Repeat all applicable data on each line. For example, if a station has three transmit antennas, repeat the information about the station on each line to indicate that the antennas are in the same station and for each antenna please identify all transmit and received channels in a specific azimuth that are potentially in operation.

top of page

Supporting Files for Delimited Text Upload Submissions

The documents listed below provide detailed supporting documents for the submission in delimited text format.

Documents for the submission in delimited text format
File Name Usage
Delimited Text Format for the upload of Technical Data for Stations Authorized under Spectrum Licences Detailed description of technical data required for data uploads including format, units and allowable values.
Spectrum_Licence_data_Spreadsheet_format_En.XLSX (23kB) Microsoft Excel Spreadsheet file format ready to use for data entry of technical data.
Spectrum_Licence_Data_Text_Sample_Data_En.Txt (2kB) Example of a text file format for a simple system.

top of page

Requirements

Use of commas

Commas must be used as a field separator only. If a comma is submitted for example in the location field (ex: 300, Slater St), then the field must be double quoted (ex: "300, Slater St") because the line format will not be accepted otherwise.

Station records ordering

Identical station records (same location name and coordinates) must all be grouped together and cannot be mixed with other stations. An error will be issued if the ordering is not met.

Non mandatory fields

If a field is not mandatory according to the data format, a null space must be submitted with comma delimiters.

Use of spaces

Use only the space required. Do not pad text with extra spaces at the start or end of text or numbers.

Use of quotes

Within delimited text files, text can optionally be enclosed in double quotes. When a series of characters begins with a double quote, it is assumed that the text is enclosed in double quotes.

Number Data Formats

Within delimited text files, do not use a comma in numbers, because it must be used as the delimiter. Numbers must not contain units or thousands separators. The period must be used as the decimal character.

Incorrect / Correct data example
Incorrect  Correct 
10,000 10000
3,14 3.14
12.5 kHz 12.5

Many spreadsheets and databases take their settings for number format from the software or operating system’s language settings. You may have to change the language setting to produce files in the correct format.

Within delimited text files, if text contains a comma, it must be enclosed in double quotes.

Example: "Jones, Kelsey & Leduc" contains a comma and must be enclosed in double quotes.

Date Data Formats

All dates are in the ISO standard numeric year-month-day format with a four digit year (YYYY-MM-DD).

Example: "March 6, 2015" is represented as 2015-03-06

top of page

Use of XLSX File Format

You cannot upload a file in this format. Data must be exported in a comma delimited text format (CSV) with the exact sequence specified by Innovation, Science and Economic Development Canada.

We provide a sample file in XLSX format ( Spectrum_Licence_data_Spreadsheet_format_En.XLSX) which can be very useful for data entry and allowing the export of data in comma delimited text format for data uploads.

top of page

Date modified: