hartmut Posted December 5, 2007 Posted December 5, 2007 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
Genx Posted December 5, 2007 Posted December 5, 2007 Substitute("Dinosaur Bar-B-Q Catering"; " " ; "+"); e.g: Substitute(YourFieldHere; " " ; "+");
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now