4.4 Field value

Data

Format

Content of CSV Data

Example

Numerical value()

${fieldname}

Integer, real number (including floating Numerical string

${amount}, ${stockprice}

Character string()

$s{fieldname}

Character string

$s{gender}, $s{gender}

Date()

$d{fieldname}

Fixed length year month day (yyyymmdd)

$d{date}, $d{orderdate}

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()

$b{fieldname}

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

$b{condition}, $b{condition}

Other cases treated as NULL