Thread: Extract States from a String
View Single Post
 
Old 04-26-2018, 04:16 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
In case you get the strings on separate rows for every entry, like
{"licenseexpdate":"","licensenumber":"ysdksnjdk l", "state":"Pennsylvania"}
{"licenseexpdate":"08/12/2020","licensenumber":"lic1235","state":"Florida"}
{"licenseexpdate":"","licensenumber":"gsdgfsef" ," state":"South carolina"}
then this formula will do:
Code:
=MID(A2,FIND("state",A2)+8,FIND("}",A2)-FIND("state",A2)-9)
Reply With Quote