Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

Extracting City Names

More
7 years 1 week ago #3138 by Joe
Extracting City Names was created by Joe
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 to join the conversation.

More
7 years 5 days ago #3144 by FlowHeater-Team
Replied by FlowHeater-Team on topic Extracting City Names
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 to join the conversation.

More
7 years 5 days ago #3148 by Joe
Replied by Joe on topic Extracting City Names
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 to join the conversation.

More
7 years 4 days ago #3152 by FlowHeater-Team
Replied by FlowHeater-Team on topic Extracting City Names
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 to join the conversation.

Time to create page: 0.268 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

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