Thread: Extract States from a String
View Single Post
 
Old 04-23-2018, 02:14 PM
soldat452002 soldat452002 is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Apr 2018
Location: Los Angeles
Posts: 6
soldat452002 is on a distinguished road
Default Extract States from a String
Hello

I have a database that generates the following string based on a web form selection.

I need to extract the state names only from these strings.

How can I achieve that in Excel? I tried everything


[{"licenseexpdate":"","licensenumber":"ysdksnjdkl", "state":"Pennsylvania"},{"licenseexpdate":"08/12/2020","licensenumber":"lic1235","state":"Florida"} ,{"licenseexpdate":"","licensenumber":"gsdgfsef"," state":"South carolina"}]
Reply With Quote