Access Module to convert data from one format to another using concatenation
£10-20 GBP
Pagado a la entrega
Hi there,
Requirement below then requires option to reverse the process.
Module required to convert postcode from list form to condensed short form. So 2 tables.
1. Postcode Gazetter 2015
2. Postcode UK Pricebooks
We need to create the table as a make table query in Postcode UK Pricebooks from the data in Postcode Gazetter 2015. It needs to follow a strict format.
So 79 records for B Postcode which all go into Zone 1 so will display simply as B it will then break with a , and the " " and then display the next alphabetic record which is BB and so on.
When the postcode appears in 2 zones eg. BD it needs to be broken and display the postcode district numbers so BD1-22,97,99, then space then BL. The remainder of BD that cross refers to BD will be in zone 2.
Zone 1 - B, BB, BD1-22,97-99, BL, CH, CV, CW, DE, DN1-12,16-17,21-22,31-35,40-41,55, DY, GL1-4,7,14,
Zone 2 - BD23-24,
Ultimately the table will looks as per Postcode UK Pricebooks but created from a make table query from Postcode Gazetter 2015.
Database attached.
Nº del proyecto: #17857544
Sobre el proyecto
Adjudicado a:
Hello, Greetings!! I have read and understood yours job requirement and very much able do this job. I have more than 5 years of experience in PHP,Various CMS,Various MVC Jquery,MySQL. Some of the prominent pro Más
Hello This should not present a problem in creating the CSV style output in pricebooks from the raw gazetter if the correct initial sort patterns are used on the source table. I can start this for you after lunch Más
7 freelancers están ofertando un promedio de £46 por este trabajo
Hi, It took a few minutes to understand what you mean but now the rules are clear. I would say it would be easy to do with SQL if the postcodes with the same letters always belonged to the same zone. Since it's not Más
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl Más
I am experience SPSS, Minitab. Excel. Presentation, Power pivot table, regression (Trend line) & correlation analysis, statistical test, linear programming, formula creation, graph creation and report writing. You m Más