Code in MSAccess or SQLServer to parse a text string into UK address components
- or -
Post a project like this$
- Posted:
- Proposals: 9
- Remote
- #1761948
- Expired
Senior .NET web developer, AWS, Azure, Linux cloud hosting, Angular development
London
1646092235042702693146594864551189697187613018829791888898
Description
Experience Level: Entry
General information for the business: Data management
Database management system (DBMS): Microsoft Access
Description of requirements/functionality: I have a table of addresses in Microsoft Access. The address string is in one column. I want to break this address string down into UK address components, and for each component to be inserted into the relevant columns in the same table. The components will be e.g. Flat name/number, building, street number, street name. I do not need postcodes to be extracted.
I am looking for a bit of code I can easily run in either MS Access or SQL Server as many times as necessary with different tables. It needs to be easy to use many times on different data.
I have a list of street names that can be used as a lookup.
I attach an example list of addresses.
Specific technologies required: SQL
Extra notes:
Database management system (DBMS): Microsoft Access
Description of requirements/functionality: I have a table of addresses in Microsoft Access. The address string is in one column. I want to break this address string down into UK address components, and for each component to be inserted into the relevant columns in the same table. The components will be e.g. Flat name/number, building, street number, street name. I do not need postcodes to be extracted.
I am looking for a bit of code I can easily run in either MS Access or SQL Server as many times as necessary with different tables. It needs to be easy to use many times on different data.
I have a list of street names that can be used as a lookup.
I attach an example list of addresses.
Specific technologies required: SQL
Extra notes:
Gill H.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
0%
Last project
23 Nov 2017
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hello.
Is there any street with the same name as avenue?
Kind regards. -
Invite me to your project please
530653527084
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies