Replace() function not substituting pipe character "|" in SetVariable module

Questions
, ,
1

:bullseye: What is your goal?

I need to convert a space-separated string of numbers (e.g. “1 2 3”) into a pipe-separated string (e.g. “1|2|3”) to use as a regex alternation pattern in a Text Parser module.

:thinking: What is the problem & what have you tried?

In a SetVariable (util:SetVariable2) module, I’m using replace(871.$2; " "; “|”) where 871.$2 contains “1 2 3”. The module returns “1 2 3” unchanged — the pipe character is never substituted. I also tried replace(871.$2; " "; “|”) with quotes, join(split(871.$2; " "); “|”), and putting the replace() directly in the Text Parser pattern field. None of these worked. The replace() works fine with other characters like comma, but not with pipe.

3

Hey there,

this is because in Make, empty space is not " " its {{space}}. You can also select it from the menu under text and binary functions, at the bottom under keywords. So this:

{{replace(871.$2; space; "|")}}

image

4

Many thanks!. it worked