(Die Seite wurde neu angelegt: „=== '''find''' - Find Values / Content === Example... The content of cell "NAME" is searched for the value "bl" and, if it is present there, the value of cell…“)
Example... The content of cell "NAME" is searched for the value "bl" and, if it is present there, the value of cell "ID" changed from "52368" to "52368-black" (return values: 1 = found, 0 = not found). Do '''not''' use the pipe ('''|''') sign and '''not''' the value to be replaced as separator. Otherwise, any character can be defined as the separator. The ID "52368" serves here only as an example:
+
Example... The content of cell "NAME" is searched for the value "bl" and, if it is present there (return values: 1 = found, 0 = not found), the value of cell "TITLE" changed from "One Product" to "[ID]-black". The cell "ID" with the value "52368" serves here only as an example. Do '''not''' use the pipe ('''|''') sign and '''not''' the value to be replaced as separator for the function (find:bl). Otherwise, any character can be defined as the separator:
{IF '[NAME|find:bl]' == '1'}[ID]-black{ENDIF}
{IF '[NAME|find:bl]' == '1'}[ID]-black{ENDIF}
Aktuelle Version vom 20. Januar 2017, 15:11 Uhr
find - Find Values / Content
Example... The content of cell "NAME" is searched for the value "bl" and, if it is present there (return values: 1 = found, 0 = not found), the value of cell "TITLE" changed from "One Product" to "[ID]-black". The cell "ID" with the value "52368" serves here only as an example. Do not use the pipe (|) sign and not the value to be replaced as separator for the function (find:bl). Otherwise, any character can be defined as the separator: