jmireports

Thank you, I will give this a shot and see how it goes. I agree, there may be only a handful of manual changes. That is till they send me a file with about 15,000 entries! Thanks for your quick help, Brian

Thank you for the quick reply... Yes, I have thought of that option too. The issue I have (being a novice with parsing) is how you would position the city, when in fact it could be a different city. For example, 43017 here in Ohio falls into three counties and could be associated with potentially 3 cities. Thus if the city is different on the client record field, how would you know where to stop the extraction of the street address without also potentially pulling in the city too? Say the client record says "Columbus" and the zip code look up says "Dublin".

I have a client who sent me a txt file with data I need to get into Filemaker 11. I can handle pretty much everything but am stuck on the address, which happens to all be in one field. Now getting the zip code and state is not an issue since those are the last two items on the address line, but where I am having issues are the streed address and city. Some cities are one word, some two and even some three. Addresses can begin with a number ( typical) but some don't. And no types of delimiter information in the field such as commas Attached is the file in question. Thank you in advance for any help! Brian foinspct.txt