Hi guys,
My first post.
I wonder if someone can help.
Beech House Dental Practice (for Night Dental), 2 North Road, Ripon, HG4 1HN
The above is a name of diary in the cloud which is downloaded as a csv. In order to report to the NHS commissioners by location city or town I need to extract the text before the last comma and it could be one work or 2.
I have extracted the first comma
Surgery: Trim(Left([Calendar],[First Comma]-1))
Also the last comma which is the Post code but I can't for the life of me figure out how to get the town/City.
Thank you for looking
Wessam