String manipulation

FIELDSTR – Display contents of field

578 views June 1, 2018 admin 0

Overview

This Custom Field returns the string contents of a field. It is usually used in conjunction with other Custom Fields.

Syntax

FIELDSTR(FieldName)

Element Description
(FieldName) The field name

Example

1. FIELDSTR(‘Height’) for the table below will return 178, 165, 202, 194.

Height
178
165
202
194

2. CONCAT(‘His height is ‘,FIELDSTR(‘Height’)‘,’ centimetres and his weight is ‘,FIELDSTR(‘Weight’),’ kilograms.’)

Height Weight
178 78
165 70
202 98
194 98

For the values in the above table, the command above incorporating the Custom Fields CONCAT and FIELDSTR will return the following four results:

1. His height is 178 centimetres and his weight is 78 kilograms.

2. His height is 165 centimetres and his weight is 70 kilograms.

1. His height is 202 centimetres and his weight is 98 kilograms.

1. His height is 194 centimetres and his weight is 98 kilograms.

See also

FIELDNAME

FIELDVAL

Was this helpful?