Home
Reference Guide
This guide describes conceptual information about data design environment components when you want to use the data fabrication feature in HCL OneTest™ Server.
Schema design
A schema is a graphical data dictionary that contains metadata definitions of the structure of a document to generate test data. Schema provides visual cues for understanding the structure and complete definition of an object.
Functions and expressions
Text functions
FILLLEFT

Reference Guide
This guide describes conceptual information about data design environment components when you want to use the data fabrication feature in HCL OneTest™ Server.
- Files
  You add a file to a project to use it as input in the project. You can upload a file from your local file system to a project from the Files tab to generate test data. Alternatively, you can upload it when you define an action.
- Connections
  A connection defines the properties that are required to connect to an external resource. An action uses a connection to provide source data to a project or write data from a source to a target. Multiple actions can use the same connection. You can define both connections and actions at the project level.
- Schema design
  A schema is a graphical data dictionary that contains metadata definitions of the structure of a document to generate test data. Schema provides visual cues for understanding the structure and complete definition of an object.
  - Introduction to schema design
    Use the Schemas tab to define, modify, and view schemas. A schema describes the syntax, structure, and semantics of your data.
  - Type properties
    The properties of a type define the characteristics of the data objects of that type.
  - Item restrictions
    Item restrictions are an optional feature you can use to specify valid or invalid data objects for an item type. Item restrictions are grouped into three categories: Value, Character, and Range.
  - Components
  - Partitioning
  - Type inheritance
  - Schema analyzer
  - Distinguishable objects
  - Functions and expressions
    - Expressions and evaluations
    - Using functions
    - Syntax of a function
    - Function argument syntax
    - Functions that convert character-set encoding to the native code page
    - General functions
    - Bidirectional functions
    - Bit manipulation and testing functions
    - Conversion functions
    - Date/time functions
    - Error handling functions
    - External interface functions
    - Inspection functions
    - Logical functions
    - Lookup and reference functions
    - Math and statistics functions
    - Text functions
      - BCDTOTEXT
      - COUNTSTRING
      - CPACKAGE
      - CSERIESTOTEXT
      - CSIZE
      - CTEXT
      - DATETOTEXT
      - FILLLEFT
      - FILLRIGHT
      - FIND
      - HEXTEXTTOSTREAM
      - LEAVEALPHA
      - LEAVEALPHANUM
      - LEAVENUM
      - LEAVEPRINT
      - LEFT
      - LOWERCASE
      - MAX
      - MID
      - MIN
      - NORMXML
      - NUMBERTOTEXT
      - PACKAGE
      - PROPERCASE
      - RANDDATA
        The RANDDATA function returns random text based on the properties of the output type. The RAND function returns a pseudo-random integer between 0 and RAND_MAX (guaranteed to be at least 32,767). The RANDDATA function generates a valid random value of the item type that is being built when it is invoked.
      - REVERSEBYTE
      - RIGHT
      - SEED
        The SEED function primes the RAND and RANDDATA functions so they produce repeated results.
      - SERIESTOTEXT
      - SQUEEZE
      - SUBSTITUTE
      - TEXT
      - TEXTTOBCD
      - TEXTTONUMBER
      - TEXTTOTIME
      - TIMETOTEXT
      - TODATETIME
      - TONUMBER
      - TRIMLEFT
      - TRIMRIGHT
      - UPPERCASE
      - WORD
    - XML functions
    - Custom functions
    - Date and time format strings
    - Number format strings
    - RUN function return codes
    - Character set codes for CPACKAGE, CSERIESTOTEXT, and CTEXT

FILLLEFT

The FILLLEFT function returns a text item of the length specified. In the output, the text item is preceded with the specified pad value.

You can use FILLLEFT when you have a value that needs to be of a fixed size with a variable number of leading characters with a specified value.

Syntax:: FILLLEFT (single-text-expression , single-text-expression , single-integer-expression )
Meaning:: FILLLEFT (text_to_fill , pad_character , pad_to_length)
Returns:: A single text item

The FILLLEFT function returns the text string that results from padding out text_to_fill by preceding it with the pad_character up to pad_to_length bytes.

If the pad-length argument is less than the number of bytes in the text to fill, no padding will appear.

Examples

FILLLEFT ( AcctID:Transaction , "0" , 5 )
If AcctID has the value 14, FILLLEFT returns 00014
FILLLEFT ( NUMBERTOTEXT ( InvoiceAmt ) , "*" , 10 )
If InvoiceAmt has the value 24.75, FILLLEFT returns *****24.75

Related functions

FILLRIGHT
LEAVEALPHA
LEAVEALPHANUM
LEAVENUM
LEAVEPRINT
SQUEEZE
SUBSTITUTE
TRIMLEFT
TRIMRIGHT