1 of 1

Conditioned output

No formatters can be chained after hideBegin, hideEnd, showBegin, showEnd.

By default, condition formatters have a special behavior, the formatter's result is not propagated to the next formatter if the result of the condition is true. This enables test chaining with Dynamic parameters.

Hide and show a part of the document with the following formatters:

hideBegin / hideEnd: hide text block between hideBegin and hideEnd if condition is true.
showBegin / showEnd: show a text block between showBegin and showEnd if condition is true.
ifEQ (value): Matches values that are equal to a specified value.
ifNE (value): Matches all values that are not equal to a specified value.
ifGT (value): Matches values that are greater than a specified value.
ifGTE (value): Matches values that are greater than or equal to a specified value.
ifLT (value): Matches values that are less than a specified value.
ifLTE (value): Matches values that are less than or equal to a specified value.
ifIN (value): Matches any of the values specified in an array or string.
ifNIN (value): Matches none of the values specified in an array or string
ifEM (): Matches empty values, string, arrays or objects.
ifNEM (): Matches not empty values, string, arrays or objects.
and (value): AND operator between two consecutive conditional formatters.
or (value): (default) OR operator between 2 consecutive conditional formatters.
show (message): print a message if a condition is true.
elseShow (message): print a message if a condition is false.

Conditioned output example

Data

{
  "status1" : 1,
  "status2" : 2,
  "status3" : 3
}

one = { d.status1:ifEQ(2):show(two):or(.status1):ifEQ(1):show(one):elseShow(unknown) }

two = { d.status2:ifEQ(2):show(two):or(.status2):ifEQ(1):show(one):elseShow(unknown) }

three = { d.status3:ifEQ(2):show(two):or(.status3):ifEQ(1):show(one):elseShow(unknown) }

one = "one"

two = "two"

three = "unknown"

Drop(element)

Compatibility

Supported file formats: DOCX, ODT, and PDF.

when you use the drop formatter, the tag value is not printed and chained formatters are not executed
to drop a group of elements, use #hidebegin-hideend or #showbegin-showend
use the drop formatter to delete elements from a document. The first argument passed to :drop(argument1) is the element to drop

Use the following arguments to drop an element:

p to drop paragraphs

usage: {d.text:ifEM:drop(p)}
include the tag within a paragraph, and all the elements it comprises are also removed if the condition is validated (external help page)

row to drop table rows

usage: {d.data:ifEM:drop(row)}
include the tag in a table row, and all the elements it comprises are also deleted if the condition is validated (external help page)

Optionally, use nbrRowsToHide to set the number of rows to drop as a second argument {d.data:ifEM:drop(row, nbrRowsToHide)}, such as {d.data:ifEM:drop(row, 3)}, meaning the current and next two rows is removed if the condition is validated.

By default, the formatter :drop(row) hides only the current row.

img to drop pictures

usage: {d.img:ifEM:drop(img)}
include the tag within the image title, description, or alternative text (external help page)

chart to drop charts

usage: {d.dataset:ifEM:drop(chart)}
include the tag within the alternative text of the graphic (external help page)

shape to drop shape (square, circle, arrows, etc.)

usage: {d.dataset:ifEM:drop(chart)}
include the tag within the title, description or alternative text of the shape (external help page)

showBegin()/showEnd()

Shows a text block between showBegin and showEnd if a condition is true.

Use only break lines (shift + Enter) between showBegin and showEnd.

Learn more about why conditional formatters are adding empty lines.

Data

{
  "toBuy" : true
}

Banana{d.toBuy:ifEQ(true):showBegin} Apple Pineapple {d.toBuy:showEnd}grapes

Banana Apple Pineapple grapes

hideBegin()/hideEnd()

Hides a text block between hideBegin and hideEnd if a condition is true.

Use only break lines (shift + Enter) between hideBegin and hideEnd. Learn more about why conditional formatters are adding empty lines.

Data

{
  "toBuy" : true
}

Banana{d.toBuy:ifEQ(true):hideBegin} Apple Pineapple {d.toBuy:hideEnd}grapes

Banana grapes

and( value )

Changes the default operator between conditional formatters.

Example

{d.car:ifEQ('delorean'):and(.speed):ifGT(80):show('TravelInTime'):elseShow('StayHere')} means "if d.car equals 'delorean' AND d.speed is greater than 80, then it prints 'TravelInTime', otherwise it prints 'StayHere'

or( value )

Changes the default operator between conditional formatters.

Example

{d.car:ifEQ('delorean'):or(.speed):ifGT(80):show('TravelInTime'):elseShow('StayHere')} means "if d.car equals 'delorean' OR d.speed is greater than 80, then it prints 'TravelInTime', otherwise it prints 'StayHere'

ifEM( )

Matches empty values, string, arrays or objects (null, undefined, [], {}, ...).

Examples

null:ifEM():show('Result true'):elseShow('Result false') // "Result true"
[]:ifEM():show('Result true'):elseShow('Result false') // "Result true"
{}:ifEM():show('Result true'):elseShow('Result false') // "Result true"
'':ifEM():show('Result true'):elseShow('Result false') // "Result true"
0:ifEM():show('Result true'):elseShow('Result false') // "Result false"
'homer':ifEM():show('Result true'):elseShow('Result false') // "Result false"
[23]:ifEM():show('Result true'):elseShow('Result false') // "Result false"
{'id':3}:ifEM():show('Result true'):elseShow('Result false') // "Result false"

ifNEM( )

Matches not empty values, string, arrays or objects.

Examples

0:ifNEM():show('Result true'):elseShow('Result false') // "Result true"
'homer':ifNEM():show('Result true'):elseShow('Result false') // "Result true"
[23]:ifNEM():show('Result true'):elseShow('Result false') // "Result true"
{'id':3}:ifNEM():show('Result true'):elseShow('Result false') // "Result true"
null:ifNEM():show('Result true'):elseShow('Result false') // "Result false"
[]:ifNEM():show('Result true'):elseShow('Result false') // "Result false"
{}:ifNEM():show('Result true'):elseShow('Result false') // "Result false"
'':ifNEM():show('Result true'):elseShow('Result false') // "Result false"

ifEQ( value )

matches all values that are equal to a specified value
can be combined with other formatters to create conditional content
returns the initial marker
- the state of the condition is not returned

Examples

100:ifEQ(100):show('Result true'):elseShow('Result false') // "Result true"
100:ifEQ(101):show('Result true'):elseShow('Result false') // "Result false"
'homer':ifEQ('homer'):show('Result true'):elseShow('Result false') // "Result true"
'homer':ifEQ('bart'):show('Result true'):elseShow('Result false') // "Result false"
'':ifEQ(''):show('Result true'):elseShow('Result false') // "Result true"
null:ifEQ(100):show('Result true'):elseShow('Result false') // "Result false"
null:ifEQ(null):show('Result true'):elseShow('Result false') // "Result true"
0:ifEQ(100):show('Result true'):elseShow('Result false') // "Result false"

ifNE( value )

matches all values that are not equal to a specified value
can be combined with other formatters to create conditional content
returns the initial marker
- the state of the condition is not returned

Examples

100:ifNE(100):show('Result true'):elseShow('Result false') // "Result false"
100:ifNE(101):show('Result true'):elseShow('Result false') // "Result true"
'homer':ifNE('homer'):show('Result true'):elseShow('Result false') // "Result false"
'homer':ifNE('bart'):show('Result true'):elseShow('Result false') // "Result true"
'':ifNE(''):show('Result true'):elseShow('Result false') // "Result false"
null:ifNE(100):show('Result true'):elseShow('Result false') // "Result true"
null:ifNE(null):show('Result true'):elseShow('Result false') // "Result false"
0:ifNE(100):show('Result true'):elseShow('Result false') // "Result true"

ifGT( value )

Matches values that are greater than a specified value.

Examples

1234:ifGT(1):show('Result true'):elseShow('Result false') // "Result true"
'50':ifGT('-29'):show('Result true'):elseShow('Result false') // "Result true"
'32q':ifGT('4q2'):show('Result true'):elseShow('Result false') // "Result true"
'1234Hello':ifGT('1'):show('Result true'):elseShow('Result false') // "Result true"
'10':ifGT('8Hello1234'):show('Result true'):elseShow('Result false') // "Result true"
-23:ifGT(19):show('Result true'):elseShow('Result false') // "Result false"
1:ifGT(768):show('Result true'):elseShow('Result false') // "Result false"
0:ifGT(0):show('Result true'):elseShow('Result false') // "Result false"
-2891:ifGT('33Hello'):show('Result true'):elseShow('Result false') // "Result false"

ifGTE( value )

Matches values that are greater than or equal to a specified value.

Examples

50:ifGTE(-29):show('Result true'):elseShow('Result false') // "Result true"
1:ifGTE(1):show('Result true'):elseShow('Result false') // "Result true"
1290:ifGTE(768):show('Result true'):elseShow('Result false') // "Result true"
'1234':ifGTE('1'):show('Result true'):elseShow('Result false') // "Result true"
-23:ifGTE(19):show('Result true'):elseShow('Result false') // "Result false"
1:ifGTE(768):show('Result true'):elseShow('Result false') // "Result false"
'1':ifGTE('1234'):show('Result true'):elseShow('Result false') // "Result false"

ifLT( value )

Matches values that are less than a specified value.

Examples

-23:ifLT(19):show('Result true'):elseShow('Result false') // "Result true"
1:ifLT(768):show('Result true'):elseShow('Result false') // "Result true"
'1':ifLT('1234'):show('Result true'):elseShow('Result false') // "Result true"
'123dsf':ifLT('103123'):show('Result true'):elseShow('Result false') // "Result true"
-1299283:ifLT('-2891feihuwf'):show('Result true'):elseShow('Result false') // "Result true"
50:ifLT(-29):show('Result true'):elseShow('Result false') // "Result false"
0:ifLT(0):show('Result true'):elseShow('Result false') // "Result false"
1290:ifLT(768):show('Result true'):elseShow('Result false') // "Result false"
'1234':ifLT('1'):show('Result true'):elseShow('Result false') // "Result false"

ifLTE( value )

Matches values that are less than or equal to a specified value.

Examples

-23:ifLTE(19):show('Result true'):elseShow('Result false') // "Result true"
1:ifLTE(768):show('Result true'):elseShow('Result false') // "Result true"
5:ifLTE(5):show('Result true'):elseShow('Result false') // "Result true"
'1':ifLTE('1234'):show('Result true'):elseShow('Result false') // "Result true"
1290:ifLTE(768):show('Result true'):elseShow('Result false') // "Result false"
'1234':ifLTE('1'):show('Result true'):elseShow('Result false') // "Result false"

ifIN( value )

Matches any of the values specified in an array or string.

Examples

'car is broken':ifIN('is'):show('Result true'):elseShow('Result false') // "Result true"
[1,2,'toto']:ifIN(2):show('Result true'):elseShow('Result false') // "Result true"
'car is broken':ifIN('are'):show('Result true'):elseShow('Result false') // "Result false"
[1,2,'toto']:ifIN('titi'):show('Result true'):elseShow('Result false') // "Result false"

ifNIN( value )

Matches none of the values specified in an array or string.

Examples

'car is broken':ifNIN('are'):show('Result true'):elseShow('Result false') // "Result true"
[1,2,'toto']:ifNIN('titi'):show('Result true'):elseShow('Result false') // "Result true"
'car is broken':ifNIN('is'):show('Result true'):elseShow('Result false') // "Result false"
[1,2,'toto']:ifNIN(2):show('Result true'):elseShow('Result false') // "Result false"

show( message )

prints a message if the condition is true
use with other formatters to print conditional content

Examples

'Carbone.io':show() // "Carbone.io"

elseShow( message )

print a message if the condition is false
use with other formatters to print conditional content

Conditioned output

No formatters can be chained after hideBegin, hideEnd, showBegin, showEnd.

Hide and show a part of the document with the following formatters:

hideBegin / hideEnd: hide text block between hideBegin and hideEnd if condition is true.
showBegin / showEnd: show a text block between showBegin and showEnd if condition is true.
ifEQ (value): Matches values that are equal to a specified value.
ifNE (value): Matches all values that are not equal to a specified value.
ifGT (value): Matches values that are greater than a specified value.
ifGTE (value): Matches values that are greater than or equal to a specified value.
ifLT (value): Matches values that are less than a specified value.
ifLTE (value): Matches values that are less than or equal to a specified value.
ifIN (value): Matches any of the values specified in an array or string.
ifNIN (value): Matches none of the values specified in an array or string
ifEM (): Matches empty values, string, arrays or objects.
ifNEM (): Matches not empty values, string, arrays or objects.
and (value): AND operator between two consecutive conditional formatters.
or (value): (default) OR operator between 2 consecutive conditional formatters.
show (message): print a message if a condition is true.
elseShow (message): print a message if a condition is false.

Conditioned output example

Data

{
  "status1" : 1,
  "status2" : 2,
  "status3" : 3
}

one = { d.status1:ifEQ(2):show(two):or(.status1):ifEQ(1):show(one):elseShow(unknown) }

two = { d.status2:ifEQ(2):show(two):or(.status2):ifEQ(1):show(one):elseShow(unknown) }

three = { d.status3:ifEQ(2):show(two):or(.status3):ifEQ(1):show(one):elseShow(unknown) }

one = "one"

two = "two"

three = "unknown"

Drop(element)

Compatibility

Supported file formats: DOCX, ODT, and PDF.

when you use the drop formatter, the tag value is not printed and chained formatters are not executed
to drop a group of elements, use #hidebegin-hideend or #showbegin-showend
use the drop formatter to delete elements from a document. The first argument passed to :drop(argument1) is the element to drop

Use the following arguments to drop an element:

p to drop paragraphs

usage: {d.text:ifEM:drop(p)}
include the tag within a paragraph, and all the elements it comprises are also removed if the condition is validated (external help page)

row to drop table rows

usage: {d.data:ifEM:drop(row)}
include the tag in a table row, and all the elements it comprises are also deleted if the condition is validated (external help page)

By default, the formatter :drop(row) hides only the current row.

img to drop pictures

usage: {d.img:ifEM:drop(img)}
include the tag within the image title, description, or alternative text (external help page)

chart to drop charts

usage: {d.dataset:ifEM:drop(chart)}
include the tag within the alternative text of the graphic (external help page)

shape to drop shape (square, circle, arrows, etc.)

usage: {d.dataset:ifEM:drop(chart)}
include the tag within the title, description or alternative text of the shape (external help page)

showBegin()/showEnd()

Shows a text block between showBegin and showEnd if a condition is true.

Use only break lines (shift + Enter) between showBegin and showEnd.

Learn more about why conditional formatters are adding empty lines.

Data

{
  "toBuy" : true
}

Banana{d.toBuy:ifEQ(true):showBegin} Apple Pineapple {d.toBuy:showEnd}grapes

Banana Apple Pineapple grapes

hideBegin()/hideEnd()

Hides a text block between hideBegin and hideEnd if a condition is true.

Use only break lines (shift + Enter) between hideBegin and hideEnd. Learn more about why conditional formatters are adding empty lines.

Data

{
  "toBuy" : true
}

Banana{d.toBuy:ifEQ(true):hideBegin} Apple Pineapple {d.toBuy:hideEnd}grapes

Banana grapes

and( value )

Changes the default operator between conditional formatters.

Example

Parameters

Description

Type

or( value )

Changes the default operator between conditional formatters.

Example

Parameters

Description

Type

ifEM( )

Matches empty values, string, arrays or objects (null, undefined, [], {}, ...).

Examples

null:ifEM():show('Result true'):elseShow('Result false') // "Result true"
[]:ifEM():show('Result true'):elseShow('Result false') // "Result true"
{}:ifEM():show('Result true'):elseShow('Result false') // "Result true"
'':ifEM():show('Result true'):elseShow('Result false') // "Result true"
0:ifEM():show('Result true'):elseShow('Result false') // "Result false"
'homer':ifEM():show('Result true'):elseShow('Result false') // "Result false"
[23]:ifEM():show('Result true'):elseShow('Result false') // "Result false"
{'id':3}:ifEM():show('Result true'):elseShow('Result false') // "Result false"

ifNEM( )

Matches not empty values, string, arrays or objects.

Examples

0:ifNEM():show('Result true'):elseShow('Result false') // "Result true"
'homer':ifNEM():show('Result true'):elseShow('Result false') // "Result true"
[23]:ifNEM():show('Result true'):elseShow('Result false') // "Result true"
{'id':3}:ifNEM():show('Result true'):elseShow('Result false') // "Result true"
null:ifNEM():show('Result true'):elseShow('Result false') // "Result false"
[]:ifNEM():show('Result true'):elseShow('Result false') // "Result false"
{}:ifNEM():show('Result true'):elseShow('Result false') // "Result false"
'':ifNEM():show('Result true'):elseShow('Result false') // "Result false"

ifEQ( value )

matches all values that are equal to a specified value
can be combined with other formatters to create conditional content
returns the initial marker
- the state of the condition is not returned

Parameters

Description

Type

Examples

100:ifEQ(100):show('Result true'):elseShow('Result false') // "Result true"
100:ifEQ(101):show('Result true'):elseShow('Result false') // "Result false"
'homer':ifEQ('homer'):show('Result true'):elseShow('Result false') // "Result true"
'homer':ifEQ('bart'):show('Result true'):elseShow('Result false') // "Result false"
'':ifEQ(''):show('Result true'):elseShow('Result false') // "Result true"
null:ifEQ(100):show('Result true'):elseShow('Result false') // "Result false"
null:ifEQ(null):show('Result true'):elseShow('Result false') // "Result true"
0:ifEQ(100):show('Result true'):elseShow('Result false') // "Result false"

ifNE( value )

matches all values that are not equal to a specified value
can be combined with other formatters to create conditional content
returns the initial marker
- the state of the condition is not returned

Parameters

Description

Type

Examples

100:ifNE(100):show('Result true'):elseShow('Result false') // "Result false"
100:ifNE(101):show('Result true'):elseShow('Result false') // "Result true"
'homer':ifNE('homer'):show('Result true'):elseShow('Result false') // "Result false"
'homer':ifNE('bart'):show('Result true'):elseShow('Result false') // "Result true"
'':ifNE(''):show('Result true'):elseShow('Result false') // "Result false"
null:ifNE(100):show('Result true'):elseShow('Result false') // "Result true"
null:ifNE(null):show('Result true'):elseShow('Result false') // "Result false"
0:ifNE(100):show('Result true'):elseShow('Result false') // "Result true"

ifGT( value )

Matches values that are greater than a specified value.

Parameters

Description

Type

Examples

1234:ifGT(1):show('Result true'):elseShow('Result false') // "Result true"
'50':ifGT('-29'):show('Result true'):elseShow('Result false') // "Result true"
'32q':ifGT('4q2'):show('Result true'):elseShow('Result false') // "Result true"
'1234Hello':ifGT('1'):show('Result true'):elseShow('Result false') // "Result true"
'10':ifGT('8Hello1234'):show('Result true'):elseShow('Result false') // "Result true"
-23:ifGT(19):show('Result true'):elseShow('Result false') // "Result false"
1:ifGT(768):show('Result true'):elseShow('Result false') // "Result false"
0:ifGT(0):show('Result true'):elseShow('Result false') // "Result false"
-2891:ifGT('33Hello'):show('Result true'):elseShow('Result false') // "Result false"

ifGTE( value )

Matches values that are greater than or equal to a specified value.

Parameters

Description

Type

Examples

50:ifGTE(-29):show('Result true'):elseShow('Result false') // "Result true"
1:ifGTE(1):show('Result true'):elseShow('Result false') // "Result true"
1290:ifGTE(768):show('Result true'):elseShow('Result false') // "Result true"
'1234':ifGTE('1'):show('Result true'):elseShow('Result false') // "Result true"
-23:ifGTE(19):show('Result true'):elseShow('Result false') // "Result false"
1:ifGTE(768):show('Result true'):elseShow('Result false') // "Result false"
'1':ifGTE('1234'):show('Result true'):elseShow('Result false') // "Result false"

ifLT( value )

Matches values that are less than a specified value.

Parameters

Description

Type

Examples

-23:ifLT(19):show('Result true'):elseShow('Result false') // "Result true"
1:ifLT(768):show('Result true'):elseShow('Result false') // "Result true"
'1':ifLT('1234'):show('Result true'):elseShow('Result false') // "Result true"
'123dsf':ifLT('103123'):show('Result true'):elseShow('Result false') // "Result true"
-1299283:ifLT('-2891feihuwf'):show('Result true'):elseShow('Result false') // "Result true"
50:ifLT(-29):show('Result true'):elseShow('Result false') // "Result false"
0:ifLT(0):show('Result true'):elseShow('Result false') // "Result false"
1290:ifLT(768):show('Result true'):elseShow('Result false') // "Result false"
'1234':ifLT('1'):show('Result true'):elseShow('Result false') // "Result false"

ifLTE( value )

Matches values that are less than or equal to a specified value.

Parameters

Description

Type

Examples

-23:ifLTE(19):show('Result true'):elseShow('Result false') // "Result true"
1:ifLTE(768):show('Result true'):elseShow('Result false') // "Result true"
5:ifLTE(5):show('Result true'):elseShow('Result false') // "Result true"
'1':ifLTE('1234'):show('Result true'):elseShow('Result false') // "Result true"
1290:ifLTE(768):show('Result true'):elseShow('Result false') // "Result false"
'1234':ifLTE('1'):show('Result true'):elseShow('Result false') // "Result false"

ifIN( value )

Matches any of the values specified in an array or string.

Parameters

Description

Type

Examples

'car is broken':ifIN('is'):show('Result true'):elseShow('Result false') // "Result true"
[1,2,'toto']:ifIN(2):show('Result true'):elseShow('Result false') // "Result true"
'car is broken':ifIN('are'):show('Result true'):elseShow('Result false') // "Result false"
[1,2,'toto']:ifIN('titi'):show('Result true'):elseShow('Result false') // "Result false"

ifNIN( value )

Matches none of the values specified in an array or string.

Parameters

Description

Type

Examples

'car is broken':ifNIN('are'):show('Result true'):elseShow('Result false') // "Result true"
[1,2,'toto']:ifNIN('titi'):show('Result true'):elseShow('Result false') // "Result true"
'car is broken':ifNIN('is'):show('Result true'):elseShow('Result false') // "Result false"
[1,2,'toto']:ifNIN(2):show('Result true'):elseShow('Result false') // "Result false"

show( message )

prints a message if the condition is true
use with other formatters to print conditional content

Parameters

Description

Type

Examples

'Carbone.io':show() // "Carbone.io"

elseShow( message )

print a message if the condition is false
use with other formatters to print conditional content

Parameters

Description

Type