Em Andamento

Sort Addresses

I have 2 files, one known as [url removed, login to view] and the other as Contributor.xls. For [url removed, login to view], I need to re-arrange the addresses based on their respective format as described below: 1. Merge the salute, First Name and Last Name into one column and name it as Add 1. Add 1 cannot be left blank or with only spaces. If empty, shift the content in Add 2 into Add 1. Add 2 can be left blank. 2. Keep the content in Add 2, 3 and 4 unless the number of characters in Add 2 exceeds 100 characters. 3. Combined the City, State and Postal Code and name it as Add 5 and delete the details in the columns for City, State and Postal. Exception to this rule: a. Canada/USA ??" Do not merge the City, State and Postal Code. The City should be placed in Add 5. b. Germany ??" Add 5 should contain the details in the following order: Postal Code, City and State c. UK ??" Keep the postal code as is. Add 5 should contain only City and State. Countries in this category include Great Britain, England, Northern Ireland, Guernsey, Jersey, Isle of Man, Wales, Channel Islands, Scotland d. Japan ??" City, State and Postal Code should be merged and placed in Add 5, and the postal code should continue to remain in the Postal Code Column with 5 digit postal code format. 4. Remove question marks from the addresses. 5. Pick up the Issue number and place in it into the Issue Column. For [url removed, login to view]: 1. Remove all the line breaks in the address column and insert a comma if comma does not exist before the line break. 2. Break up the text into Add 2, 3 and 4 using 100 characters as the limit. Make sure that the word is not broken up into 2 separate columns.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):

a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

windows XP Excel 2002 VBA/Macro

Habilidades: Excel, Microsoft Access, Microsoft Exchange, Powerpoint, Visual Basic para Apps, Word

Ver mais: merge sort explained, hire man, great hire usa, excel powerpoint macro, england hire, coder countries, wales, sort excel, scotland, isle man, work shift vba, excel macro sort, word vba agreement, run powerpoint, word merge excel, sort macro, usa city state, word merged, insert macro excel, excel macro add, excel digit, text line breaks word, excel vba word, remove characters excel, excel macro delete text

Acerca do Empregador:
( 43 comentários ) Singapore, Singapore

ID do Projeto: #3063761

Premiar a:

shikhamehta

See private message.

$25.5 USD em 3 dias
(78 Avaliações)
5.6

19 freelancers estão ofertando em média $33 para este trabalho

schandraram

See private message.

$76.5 USD in 3 dias
(99 Comentários)
6.5
sonarkaushik

See private message.

$58.65 USD in 3 dias
(37 Comentários)
5.4
dpune

See private message.

$21.25 USD in 3 dias
(35 Comentários)
5.1
Lotusdeveloper

See private message.

$29.75 USD in 3 dias
(22 Comentários)
3.9
manojyohannan

See private message.

$25.5 USD in 3 dias
(6 Comentários)
2.8
dzmitrij

See private message.

$25.5 USD in 3 dias
(2 Comentários)
2.3
tatasthuinfotech

See private message.

$29.75 USD in 3 dias
(7 Comentários)
2.2
mselimsl

See private message.

$11.05 USD in 3 dias
(1 Comentário)
0.0
jpcentral

See private message.

$21.25 USD in 3 dias
(1 Comentário)
0.0
shivazmailboxeu

See private message.

$35.7 USD in 3 dias
(0 Comentários)
0.0
inl

See private message.

$39.95 USD in 3 dias
(0 Comentários)
0.0
openlancer7

See private message.

$8.5 USD in 3 dias
(0 Comentários)
0.0
JSPARS

See private message.

$17 USD in 3 dias
(0 Comentários)
0.0
mwillesen

See private message.

$72.25 USD in 3 dias
(0 Comentários)
0.0
wizardul

See private message.

$29.75 USD in 3 dias
(0 Comentários)
0.0
deartec

See private message.

$38.25 USD in 3 dias
(0 Comentários)
1.4
Dexter8

See private message.

$25.5 USD in 3 dias
(0 Comentários)
0.0
virtualhassan

See private message.

$42.5 USD in 3 dias
(0 Comentários)
0.0