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