Last modified by - 4 years ago
199 Views
Less than a minute read

Text Calculators

Theme Bootstrap
Targeted Device Medium devices (desktops, 992px and up) users. Collapsed to start, horizontal above breakpoints.
Label Position Top
Radios and Checkboxes Stacked
Element Size Medium

Shows using of Microsoft Excel string functions in WordPress in calculated attribute type of WP App Studio.

The output of these operations can be used in variety use cases including comparisons, data cleansing etc.

WP App Studio Text functions

Formulas used in calculations are below:

CONCATENATE:

CONCATENATE( !#ent_text_string_1#, !#ent_text_string_2#, !#ent_text_string_3#)

LOWER:

LOWER(!#ent_text_string_1#)

PROPER:

PROPER( !#ent_text_string_1#)

PROPER:

PROPER( !#ent_text_string_1#)

LEN:

LEN(!#ent_text_string_1#)

Note: The attribute tags used in the formulas are based on the names you give to your attributes. So your values may be different.

Was this information helpful?