Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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