Dynamic data import / export

datenbank

simply more productive
Up to 100,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.
  • Page:
  • 1

TOPIC: Extracting City Names

Extracting City Names 8 months 1 day ago #3138

  • Joe
  • Joe's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 25
I need to extract city names and State names into separate fields for each, from text such as the example below. As you can see, there are sometimes extra commas and city names can be up to 4 words. Can this be done?

JUNCTION, CITY, AR TO AMORY, MS NO TARP $675

FULTON, MS TO GAMALIEL, KY 6FT TARPS $750

UNION, MS TO NEW DOSWELL TOWNSHIP, VA 6FT TARPS $2000

COLLINWOOD,TN TO SOMERSET, KY 8FT TARPS $725

COLLINS, MS TO LA PORTE, IN 6FT TARPS $1675

Please Log in or Create an account to join the conversation.

Extracting City Names 7 months 4 weeks ago #3144

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 275
Hi Joe,

Sorry, I’m not sure what you want to do. Can you post a short example with the expected result from your example please.

Please Log in or Create an account to join the conversation.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Extracting City Names 7 months 4 weeks ago #3148

  • Joe
  • Joe's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 25
I need to return 4 results from each...

JUNCTION, CITY, AR TO AMORY, MS NO TARP $675
Result: "Junction City" "AR" "Armory" "MS"

FULTON, MS TO GAMALIEL, KY 6FT TARPS $750
Result: "Fulton" "MS" "Gamaliel" "KY"

UNION, MS TO NEW DOSWELL TOWNSHIP, VA 6FT TARPS $2000
Result: "Union" "MS" "New Doswell Township" "VA"

COLLINWOOD,TN TO SOMERSET, KY 8FT TARPS $725
Result: "Collinwood" "TN" "Somerset" "KY"

COLLINS, MS TO LA PORTE, IN 6FT TARPS $1675
Result: "Collins" "MS" "La Porte" "IN"

Please Log in or Create an account to join the conversation.

Extracting City Names 7 months 4 weeks ago #3152

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 275
Hi Joe,

I´m afraid that´s not psoible :( Theres no recognizable logic to extract such words.

Please Log in or Create an account to join the conversation.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
  • Page:
  • 1
Moderators: FlowHeater-Team
Time to create page: 0.090 seconds