Hello, I'm trying to write an expression function that replaces 2

dylanf over 10 years ago

Hello,

I'm trying to write an expression function that replaces 26 different special characters with their encoded equivalents, but in attempting to use a series of nested substitute() functions to do this, I'm get a stack overflow error within the expression editor. Any advice or help with this would be greatly appreciated.

Thanks,
Dylan...

Discussion posts and replies are publicly visible

0 moritzw over 10 years ago

You could try this using looping functions. Somthing like apply(fn!substitute,merge(replaceMe,replaceWith)) could work....
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 shelzle over 10 years ago

I tried this

=reduce(fn!substitute, "at best coffee", merge({"a", "b", "c"}, {"a#", "b#", "c#"}))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 dylanf over 10 years ago

Thanks very much. I used the reduce() function as described above and this seems to work.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 shelzle over 10 years ago

You are welcome :-)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jorge Sanchez
Appian Employee
over 10 years ago

You may also want to consider deploying the Regex expression plugin, as it will achieve the same with a simple regex expression without the use of looping functions.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel