FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Extracting City Names

Extracting City Names 1 year 7 months ago #3138

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 1 year 7 months ago #3144

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.

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.

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 1 year 7 months ago #3148

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 1 year 7 months ago #3152

Hi Joe,

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

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.

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

other Languages

en
GB | US

de
DE | AT | CH

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2018 by FlowHeater GmbH. All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en