mladd
Programmer
- Apr 12, 2006
- 46
Is it possible to use a SUBSTITUTE() in a component rule? I have not seen any limitations in the doc, but I can't seems to get it to work. Basically, I need to strip a <CR><LF> from an inbound address record and replace it with two spaces.
I have tried a few different variation of the following rule:
and just plain
Does anyone have any ideas as to go about accomplishing this substitution?
Thanks in advance,
Mike
I have tried a few different variation of the following rule:
Code:
IF(FIND("<CR><LF>", $), SUBSTITUTE($,"<CR><LF>", " "), NONE)
Code:
SUBSTITUTE($,"<CR><LF>", " ")
Does anyone have any ideas as to go about accomplishing this substitution?
Thanks in advance,
Mike