This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.

Learn more
I AGREE
community Data Science Portal alteryx .com community Data Science Portal alteryx .com community
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: 

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

Replace

MKanchwa
6 - Meteoroid
‎10-15-2019 05:02 AM

I want to replace all the "|" with "" (Blanks) by using only one formula which can be applied to all the fields

 

Inputs

clipboard_image_0.png

Output

clipboard_image_2.png

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

benakesh
12 - Quasar
‎10-15-2019 05:09 AM

Hi @MKanchwa ,

Try multi field formula : replace([_CurrentField_],'|','') . Select all required fields for replace in tool configuration.

multi_field.yxmd
Reply
MKanchwa
6 - Meteoroid
‎10-15-2019 09:33 PM

Thanks!!

Reply
0 Likes
Labels