Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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]
and
"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?
The Ticketing tool needs to have the [ticket_number] between "quotes"

Result expected

company.website/forms/xxxx = "TICKET000031" 

 

 

  • Hi Anonymous ,

     

    Have you tried the following:

    "company.website/forms/xxxxxxx = " & """" & [ticket_number] & """"

     

    Pete

2 Replies

  • Hi Anonymous ,

     

    Have you tried the following:

    "company.website/forms/xxxxxxx = " & """" & [ticket_number] & """"

     

    Pete

    • Anonymous's avatar
      Anonymous
      Not 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]"&""