Hello everyone! Here's my problem.
I have three columns: Company, Address, Subcategory
Datasets under 'Address' look like these
'66, ABC Street, Random City, Metro Manila'
'11 Something City, Brgy Parang, 1809 Metro Manila'
'0106, Calan District, Another City, Pangasinan'
How do I extract just City Name (ex: Random City) from the 'Address' column so that my query results are in this format: 'Company', 'City', 'Subcategory'
I'm not really sure how to go about this?
Any help will be greatly appreciated!