Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Replace one character with multiple characters on multiple formula tool

mitogene
5 - Atom

Hi,

when I run ReplaceChar([_CurrentField_], '<', 'is less than: '), it only saves the "i" character and not ''is less than: " word.

Based on the documentation, ReplaceChar can only replace one character. How can I replace one character with multiple characters?

It might be possible with regular expressions but I'm not familiar with that.

 

Thank you

1 REPLY 1
BenMoss
ACE Emeritus
ACE Emeritus
You can just use replace instead of replacechar.

The structure of the syntax is the same.

Ben
Labels