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

Use Special character in Formula tool

thenewbee
6 - Meteoroid

Hi All,

I need to create a column with special characters in it espectially the double quotes ("). Can any one let me know how to use this can be used in a Formula tool.

I'm looking for some thing like this

 

Thanks in advance

CMM

4 REPLIES 4
Federica_FF
11 - Bolide

You can use the single quotes to quote the double quote.

For example, you want to write the label "AAAA", you have to set the formula tool this way: '"AAAA"'

DultonM
11 - Bolide

Hi thenewbee! If you want to keep the double quotes with your string, just surround with single quotes. Example: if you type '"Hello"' into the formula tool, the field will say "Hello". The reverse is also true!

thenewbee
6 - Meteoroid

Thanks. that made it work

dlesny
8 - Asteroid

 

 

 

Labels