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. |