Posted on: 9/15/2014 6:52:16 AM | Views : 357

=IF(SEARCH("";[Relative URL]);("http://i-tec.signin.no"&[Relative URL]);(IF(SEARCH(" ";[Relative URL]);"http://i-tec.signin.no"&REPLACE([Relative URL];SEARCH(" ";[Relative URL]);1;"%20"))))
Hi, I used this formula for my calculated field. But the second part is not working. I need to replace space with %20. if there is no space i dont need the the replacement.
The formula working for individual conditions. 
This works for the space
IF(SEARCH(" ";[Relative URL]);"http://i-tec.signin.no"&REPLACE([Relative URL];SEARCH(" ";[Relative URL]);1;"%20"))
This work for no space.
=IF(SEARCH("";[Relative URL]);"http://i-tec.signin.no"&[Relative URL])
But when I join both of this first conditions works. Pls help me

Go to the complete details ...