AMT Datasouth Fastmark M1 Guia do Utilizador descarregar pdf (Página 285)

100

101

Formula Data Source

Function Description

Left-String

Returns the first (or leftmost) character or characters from

the selected field.

Syntax: left(fieldname, num-chars)

fieldname: the field to extract data from

num-chars: the number of characters to copy

Example: Returns the first (or leftmost) four characters

from the selected field TEXT0003. LEFT(Text0003,4)

Left-Trim

Removes stated characters from the beginning (or left most

side) of the field.

Syntax: ltrim(‘trim character’,fieldname) trim_char:

character to be trimmed from field

fieldname: the field to extract data from.

Example: Removes all consecutive occurrences of the

character N from the leftmost side of the field

TEXT0002. LTRIM(‘N’,Text0002)

Mid-String

Returns a specific number of characters from the selected

field, starting at the position you specify.

Syntax: mid(fieldname, start_pos, length)

fieldname: the field to extract data from

start_pos: is the position of the first character you want

to extract. The first character in a field has tart_pos 1

and so on.

length: the number of characters to copy.

Example: Extract 10 characters from the Description

field, starting at the fifth character. MID(Description, 5,

10)

Parenthesis

Inserts a set of parentheses into the formula. You can move

the cursor inside the parenthesis to enter more operations

into the parenthesis. Note the text cursor auto positions

inside the parenthesis.

Right-Pad

Pads stated character onto the end (or rightmost side) of the

field.

Syntax: rpad (‘pad-char’,max-width, fieldname)

pad_char: character to be padded into printed field

max_width: maximum total size of field to print

including padded characters

fieldname: the field to extract data from

Loftware LabelManager Version 10.1.1 User's Guide

285

1 2 ... 280 281 282 283 284 285 286 287 288 289 290 ... 531 532

Comentários a estes Manuais

Sem comentários

AMT Datasouth Fastmark M1 Guia do Utilizador Página 285

Comentários a estes Manuais