Forum Discussion
Quotation Marks around a [Field] when used as a URL/URL+Ticket# opens up Ticketing Tool Search Page
Question | Hello All, I am using Power Query Editor to check over the data and add a Custom Column that is going to be Type:WebURL. It will be used to open a Ticketing Tool Search Page and insert the ticket number. Thank you for your help as always. E M |
Action | Add Custom Column |
Formula used | "company.website/forms/xxxxxxx = "& [ticket_number] |
Display showed in PowerQ | company.website/forms/xxxx = TICKET0000311 |
Requesting your kind help on | How can you add " " to the ticket number on the Power Query Formula? |
Result expected | company.website/forms/xxxx = "TICKET000031" |
|
|
Hi Anonymous ,
Have you tried the following:
"company.website/forms/xxxxxxx = " & """" & [ticket_number] & """"Pete
2 Replies
- BA_Pete
Super User
Hi Anonymous ,
Have you tried the following:
"company.website/forms/xxxxxxx = " & """" & [ticket_number] & """"Pete
- AnonymousNot applicable
Pete, first Thank you! I tried many ways to add more and take away the "" marks ... but
this was my last try
& "" &"[ticket_number]"&""