Home > Cloud Cruiser 4 > Administering > CCIMPORT and CCEXPORT reference > Lookup table CSV file format

Lookup table CSV file format

This article specifies the format of a CSV file that is required to import lookup tables with ccimport and written by ccexport.

Format

The first line of the file is a header row that defines the format of the subsequent rows. The following table describes the valid field names for the header row, some of which also have short names that you can use instead. In the full field names, you can substitute dots (.) for underscores (_).

CSV rows beginning with a pound sign (#) are treated as comments and ignored by the importer.

Handling special characters

 

Field Name

Description

Required

pattern An exact pattern to match. When matched, targetValue is returned. Takes precedence over lowId and highId. No
lowId The low end of a range to match. When a source value is between this value and highId, inclusive, targetValue is returned. No
highId The low end of a range to match. When a source value is between lowId and this value, inclusive, targetValue is returned. No
targetValue The value to return if the row is matched. Yes

Sample CSV

The following is a sample CSV file.

,a,,C-AA-KKKK-11
,b,,C-AA-LLLL-11
,c,,C-AA-MMMM-11
,d,,C-AA-NNNN-11
,e,,C-AA-OOOO-11
,,z,C-BB-KKKK-11
Last modified

Tags

Classifications

This page has no classifications.
© Copyright 2018 Hewlett Packard Enterprise Development LP