I have need to use the open URL command in a script to open info on specific phone numbers

So if I choose the open URL and go to specify,  I select the "phone" Field.  which contains for numbers in the following format.

(333) 444-5555  for example

 

when I paste that type of file in the Address bar of my browser I get right to what I am looking for.

But with the Open URL function I get 

 

www.(333) 444-5555.com which will not open.

 

Is there  a way to drop the www and the .com in the formula so it will just paste in the (333) 444-5555 only?

easiest may just be to use filtervalues(text,"0123456789()-")

Thanks I tried that but it doesn't upload the phone number it just gives the same error. I enclosed a file to show what it does.

phone url.fmp12.zip

Sorry I misunderstood what you were asking.. if I get it right this time... your url  then needs to be formatted like this, if you are using google.

 

https://www.google.com/?gws_rd=ssl#q=(333)+444-5555

Thank you so much . Would it be the same if I used Yahoo for search engine? Yahoo is the search engine I use. That would be the best for me. I am not sure How you formatted it.

I think with yahoo its like

 

http://search.yahoo.com/search?p=333-444-5555

or

http://search.yahoo.com/search?p=3334445555

 

 

results vary slightly you will need to play with the phone format  so you get the results you want.

Thanks a million!

Hi hownow,,

 

I have need to use the open URL 

I have removed two of your posts as being multiple posts.

 

Please do not double and triple post your questions.

 

If you have followup questions on this need, just make a reply to this thread with the additional information and need.

 

Lee

I am sorry I thought I was in a new post. I will redo

Thanks

Is English a second language with you?

 

When posting about the same need, it does NOT require a new topic/tread, so do NOT start a new topic. JUST continue your new question on the subjects by posting a Reply to the Original Post/Topic/Thread.

 

Lee

As a matter of fact it is.

Deutsch