4.4 Field value

Table 4.2 shows the different data formats in the data field, the type of CSV data varies depends on how it is used and defined by the user.

Table 4.2: Format of field

Data

Format

Content of CSV Data

Example

Numerical value($num$)

${fieldname}

Integer, real number (including floating Numerical string

${amount}, ${stockprice}

Character string($str$)

$s{fieldname}

Character string

$s{gender}, $s{gender}

Date($date$)

$d{fieldname}

Fixed length year month day (yyyymmdd)

$d{date}, $d{orderdate}

Time($time$)

$t{fieldname}

Fixed length year month day minute second (yyyymmddHHMMSS)

$d{time}, $d{departuretime}

   

Fixed length hour minute second (HHMMSS)

 
   

(current date stored internally)

 

Boolean($bool$)

$b{fieldname}

The value is expressed as "1" if true and "0" if false态

$b{condition}, $b{condition}

   

Other cases treated as NULL