Add OR function to a formula

I am given a phrase like this:-

"Circular walk from High Ongar to Fyfield
Meet: High Ongar Church. park along road."

=MID(PDF!$B4,FIND("Meet: ",PDF!$B4)+6,FIND(CHAR(46),PDF!$B4,FIND("Meet: ",PDF!$B4))-FIND("Meet: ",PDF!$B4)-6)

This formula extracts "High Ongar Church" which I require. However sometimes the period after Church is replace by a comma. So I think I need to add the OR function to check for CHAR(44) as well as CHAR(46)

I have tried several ways of adding the OR into this formula without success.

Can any one please advise?

excel

microsoft 365

peiyezhu
Bronze Contributor
Dec 22, 2023
based on
Circular walk from High Ongar to Fyfield
Meet: High Ongar Church. park along road.

what is your expected result string?
- peiyezhu
  Bronze Contributor
  Dec 22, 2023
  
  =WEBSERVICE("https://e.anyoupin.cn/eh3/?preg_match~Meet:\s*(.*?)[\.,]~" & A2 & "~1")
- athegn
  Copper Contributor
  Dec 22, 2023
  High Ongar Church i.e the same as when a period is there but a comma in its place.
  - peiyezhu
    Bronze Contributor
    Dec 22, 2023
    OK.
    Have you tried the webservice formular I provided if your original string in range A2?

Forum Discussion

Add OR function to a formula

Share

Resources