Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

I want to write string with both Single and Double quotes in Filter expression editor

VijayAnaparthi
8 - Asteroid

I want to Keep both Single quotes and Double quotes in Filter expression editorString_Quotes_Error.JPG

12 REPLIES 12
VijayAnaparthi
8 - Asteroid

Yes, I understand your point @DataNath, but end user will use that app and he enter that string in textbox not myself, So obviously we cant think that user will enter that string in format that you mentioned above.

 

He will just enter What if i want both 'single quotes' and "double quotes" in a string. 

 

After he entering then same string will replaces 'x' in formula tool. Because of user entered string has single quotes(') that formula tool will throws an error

 

 

DataNath
17 - Castor
17 - Castor

I get that @VijayAnaparthi. Unfortunately, I can't really think of any way to achieve this in the Formula tool. One way I can think to get around this is with the attached app - which uses the find and replace tool - and can mix single and double quotes. If the user doesn't want to replace, they may just need to copy the same text in again:

 

DataNath_0-1656938658561.pngDataNath_1-1656938676913.png

VijayAnaparthi
8 - Asteroid

Thank You so much. It is working.

Labels
Top Solution Authors