if with multi condition

[takbb]

hi @alrz , I’m assuming these are string columns. You may also be able to use String Manipulation (Multi Column) :

select only the columns that you want to act on, and use the following expression to replace “x” with “y”:

string(
	1 == length($$CURRENTCOLUMN$$)
	?replace($$CURRENTCOLUMN$$,"x","y")
	:$$CURRENTCOLUMN$$)

see the “conditional expressions” paragraph here for further info:

Fun with String Manipulation's "undocumented features"

For a while now I’ve been using various features of String Manipulation that you won’t generally find documented. I guess therefore, that what I am writing here should be given the caveat “use at your own risk” since it is always possible that in the future, the String Manipulation (and its “(variable)” counterpart node) could be rewritten and the undocumented features would no longer work. However, since it sits on top of java, and these features make use of its close relationship with java, i…

---

Mind you, given the cell length to check for is 1, I think that replacing “x” with “y” could be done as a simple literal replacement, using regexReplace:

regexReplace($$CURRENTCOLUMN$$,"^x$","y")