How to include speech marks (") in Excel output
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am trying to output a Hyperlink formula into one of the data columns of my Excel output.
Part of this hyperlink formula requires double quotation marks e.g.
"=HYPERLINK("dynamicsnav://vmnavpr01.salgrp.net:7046/DynamicsNAV90/LIVE/runpage?page=9069464&$filter='Entry%20No.'%20IS%20'7%20AND%20'Client%20No.'%20IS%20'CL000004'&mode=Edit","PF001")"
How can I integrate the " in the cell without Alteryx formula tool interpreting it as a break in the constructed text.
My formula used is:
"=Hyperlink(dynamicsnav://vmnavpr01.salgrp.net:7046/DynamicsNAV90/LIVE/runpage?page=9069464&$filter='Entry%20No.'%20IS%20'"
+[Entry No_]+
"%20AND%20'Client%20No.'%20IS%20'"
+[Client No_]+
"'&mode=Edit,PF001)"
which outputs correctly, but I miss the " before dynamics, after Edit.
Thanks in anticipation
Solved! Go to Solution.
- Labels:
- Parse
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @davidlhowes
Basically the idea \ hack on how to do this warp double quotes in single quotes in double quotes.
For this you need split strings into part which has double quotes and part which has part single quotes. Like
" part with single quotes " and ' part with double quotes '
applied on your string would look like
Where yellow highlighted are the markers
Hope this helps 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Enclose the single quotes in double quotes and enclose the single quotes in double quotes so that they are not interpreted by Alteryx.
In your case try this:
'=HYPERLINK("dynamicsnav://vmnavpr01.salgrp.net:7046/DynamicsNAV90/LIVE/runpage?page=9069464&$filter='+"'Entry%20No.'%20IS%20'" + toString([Entry_No]) + "%20AND%20'Client%20No.'%20IS%20'" +tostring([Client_No]) + "&mode=Edit"+'","PF001")'
Attaching zipped workflow for reference.
I hope this shall resolve your issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for your help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help 🙂 @davidlhowes
Cheers and Happy Analyzing 😀
Feel free to reach out if you face any issues 🙂
