Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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