We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Replacing Control Characters

danieljcroberts
7 - Meteor
‎03-28-2017 02:40 AM

Hi All,

 

I want to do something quite simple but I'm struggling. I have a long text string with SOH (Start of Heading) characters in it. I want to replace this with a '|' character. Any tips?

 

Best Regards,


Dan

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
AdamR_AYX
Alteryx Alumni (Retired)
‎03-28-2017 02:45 AM

I think this formula should do the trick

 

Replace([Field1], CharFromInt(1), "|")

Adam Riley
https://www.linkedin.com/in/adriley/
Reply
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All