December 5, 200718 yr Hello I have to do a google search from Companies in my filemaker databases to see if they have a web site. In the formating of that search I need to generate a url within filemaker as a script step with all the words in the field with the "+" symbol between them . example "Dinosaur Bar-B-Q Catering" has to be in the url google search as "Dinosaur+Bar-B-Q+Catering" - I can understand how to do this when there are always the same amount of words in the business name but there might only be 1 and up to 6 words in a business. So in the case of one word example "Sugarland" there would be no "+" but many businesses are more than 2 words. It is always different. I am not understanding how to do this,. Thanks if you can help. Dave
December 5, 200718 yr Substitute("Dinosaur Bar-B-Q Catering"; " " ; "+"); e.g: Substitute(YourFieldHere; " " ; "+");
Create an account or sign in to comment