Variable Examples

These example calculated attributes are written to use the data defined in the following tables.

For function syntax information on and more detailed use cases, refer to the Variable Functions documentation here.

The examples below assume a setup including these attributes and products:

ATTRIBUTE Type

ID

Name

Text-validated product attribute

TEXT1id

TEXT1

PRODUCTS ID

Name

Parent

TEXT1id

P-family-id

P-family

Product hierarchy root

family value

P1id

P1

P-family-id

p1 value

P2id

P2

P-family-id

p2 value

P3id

P3

P-family-id

p3 value

After creating the data above, copy and paste any of the Value Template text below into the Function Editor, select the object with the defined data, and click the Evaluate button to display the Result.

Value Template

Object

Result

 
{txt:=prodval('TEXT1id'), pos:=find('p3', txt)
} 
if(pos='N/A', 'no P3', replace(txt, pos, 2, '??'))

P3

P2

?? value

no P3

 
{total:=0, 
loop:=iterate(listconcatenate(1,4,8,13), 
'total:=total+item')
} 
concatenate(total)

{any}

26

Concatenate Function with Variables

Consider a calculated attribute that will concatenate two different attribute values, where they style of each should be different. Use character tags in STEP to format (or style) text attributes. Then convert those tags to either paragraph or character tags for the output media. For information on character tags, refer to Tags here.

The example calculated attribute is written to use an object with the attributes defined in the following table.

Attribute>

ProductName

KeyLetter

Mandatory

Yes

No

Character Tag

[PN]

[KL]

The example calculated attributes below use an object with the attribute values defined in the following table.

 

ProductName

KeyLetter

Required Result

Product1(P1)

Acme Widget

A

[KL]A. [PN]Acme Widget

Product2(P2)

Acme Widget

 

[PN]Acme Widget

A calculated attribute can produce the same result with or without variables as demonstrated in the table below.

Value Template With Variables

Value Template Without Variables

 
{pnnokey := concatenate('[PN]',prodval("ProductName")),
pnwkey := concatenate('[KL]',prodval("KeyLetter"),
'. [PN]',prodval("ProductName"))
}
if(exact(prodval("KeyLetter"),''),pnnokey,pnwkey)
 
if(exact(prodval("KeyLetter"),''),
concatenate('[PN]',prodval("ProductName")),
concatenate('[KL]',prodval("KeyLetter"),
'. [PN]',prodval("ProductName")))

Variables

In this example, two variables allow the actual value template (the last line) to be shorter and more legible to the reader:

  • Variable 'pnnokey' calculates the result when no KeyLetter value exists.
  • Variable 'pnwkey' calculates when there is a KeyLetter value.

In both examples, testing for a blank value is achieved by using the EXACT function to compare against two (2) single quote marks (') with no spaces between them.

Find Function with Variables

The example calculated attributes below use an object with the attribute values defined in the following table.

 

ProductName(prodname)

Product1(P1)

ACME-BP-1001 Super XBP

A calculated attribute can produce the same result with or without variables as demonstrated in the table below.

Value Template

Result

Notes

 
{x := find('-BP-', prodval("prodname")), 
y := 'Boardroom Projector Series'
}
if(exact(x,'N/A'),'',replace(prodval("prodname"),x+1,2,y))

ACME-Boardroom Projector Series-1001 Super XBP

The IF function checks if the value of x is 'N/A'

  • If the value is 'N/A' the result is no output, as indicated by the blank value of two single quote marks.
  • If the value is not 'N/A', then the two (2) characters starting at position x+1 (6, in this example), are replaced by the value of y.

Variables

  • Variable 'x' finds the position of the text string that will be replaced using the FIND function. In this example, the position of the text '-BP-' within the 'prodname' attribute value is needed. The function returns the numeric value of the position, in this example, 5 is returned since the first dash is at position 5.
  • Variable 'y' supplies the replacement text string.