Last modified by - 3 years ago
162 Views
Less than a minute read

Text Calculators

ThemeBootstrap
Targeted DeviceMedium devices (desktops, 992px and up) users. Collapsed to start, horizontal above breakpoints.
Label PositionTop
Radios and CheckboxesStacked
Element SizeMedium

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?