In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

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
Top Solution Authors