In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities 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.

Replace " with character. How to reference "

wonka1234
10 - Fireball
‎01-03-2024 08:22 AM

Hi,

 

Say I have the formula -

 

Replace([Name], """, "_")

 

I have a " inside "" .

 

How do I make this work?

Labels:
Reply
0 Likes
2 REPLIES 2
binu_acs
21 - Polaris
‎01-03-2024 08:26 AM

@wonka1234 use single quotes 

 

Replace([Name], '"', "_")

Reply
0 Likes
davidskaife
14 - Magnetar
‎01-03-2024 08:35 AM

Hi @wonka1234 

 

For this specific use case you'll have to replace the """ entirely rather than just the " within the ""

replace([Name],'"""','"_"')

 

Reply
0 Likes
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All