Skip to main content
A
Anonymous
September 19, 2008
Question

Inserting + for a space

  • September 19, 2008
  • 2 replies
  • 322 views
Some sites have terrible formatting requirements for pulling feeds. For example, a site I'm trying to pull a feed from requires a plus sign in place of a space. For example, I'm trying to pull a feed based on the keyword (or phrase) Cache La Poudre. The feed makes me request it like this Cache+La+Poudre. Is there a way to take a query result and insert a plus sign wherever there is a space in the string?
    This topic has been closed for replies.

    2 replies

    A
    Anonymous
    September 19, 2008
    Love it when I get answers quickly and see the word "easily".

    Thanks. I just realized I can make my search results a little more refined based on this function.

    Thanks again.
    Miguel-F
    Miguel-F
    Inspiring
    September 19, 2008
    That can be done very easily using the Replace function. Something like:

    Replace("Cache La Poudre"," ","+","All")

    That first parameter can be a variable too. Like:

    Replace(QueryResultField," ","+","All")
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices