Stringfunctions+ | Formula CLEANSTRING
Description
This formula creates text without special characters for further technical processing.
Formula(s)
PHP
{=CLEANSTRING("Source text";To lowercase;Replace blanks;Replace umlauts;Remove line breaks)}Result
String
Parameters
Parameter | Content | Format | Default value | Explanation |
|---|---|---|---|---|
Source text | Text to be cleaned | String |
| Fixed text or content from other attributes (e.g. via the ATTRVAL formula) can be used as source text. |
To lowercase | TRUE or FALSE | Boolean | TRUE | TRUE: The text is converted to lowercase. |
Replace blanks | TRUE or FALSE | Boolean | TRUE | TRUE: All blanks will be replaced by underscores. Multiple will be converted into one. |
Replace umlauts | TRUE or FALSE | Boolean | TRUE | TRUE: All umlauts will be replaced by their corresponding double notation. |
Remove line breaks | TRUE or FALSE | Boolean | TRUE | TRUE: All line breaks will be removed. |