AUTOMATED REPLACE FUNCTION CREATION
Descrição da oferta de emprego
Specifically, I will run this routine on the physical address column of data (not on the Company Name or City or State columns).
In the attached.
lsx file, I would run the routine for all of a Column B.
Here are the 20 specific tasks involved.
1.
If a cell contains the word "Ave" or "Ave.", it should be replaced with "Avenue".
2.
If a cell contains the word "Blvd" or "Blvd.", it should be replaced with "Boulevard".
3.
If a cell contains the word "Ct" or "Ct.", it should be replaced with "Court".
4.
If a cell contains the word "Drive" or "Dr.", it should be replaced with "Drive".
5.
If a cell contains the word "Expwy" or "Expwy." or "Epwy" or Epwy.", it should be replaced with "Expressway".
6.
If a cell contains the word "Hwy" or "Hwy.", it should be replaced with "Highway".
7.
If a cell contains the word "Ln" or "Ln.", it should be replaced with "Lane".
8.
If a cell contains the word "Pkwy" or "Pkwy.", it should be replaced with "Parkway".
9.
If a cell contains the word "Rd" or "Rd.", it should be replaced with "Road".
10.
If a cell contains the word "St" or "St.", it should be replaced with "Street".
11.
If a cell contains the word "1st", it should be replaced with "First".
12.
If a cell contains the word "2nd", it should be replaced with "Second".
13.
If a cell contains the word "3rd", it should be replaced with "Third".
14.
If a cell contains the word "4th", it should be replaced with "Fourth".
15.
If a cell contains the word "5th", it should be replaced with "Fifth".
16.
If a cell contains the word "6th", it should be replaced with "Sixth".
17.
If a cell contains the word "7th", it should be replaced with "Seventh".
18.
If a cell contains the word "8th", it should be replaced with "Eighth".
19.
If a cell contains the word "9th", it should be replaced with "Nineth".
20.
If a cell contains the word "10th", it should be replaced with "Tenth".
NOTE 1.
I do NOT want the routine to find & replace any of the abbreviations, like "St" in the Proper Name of the Ave/Blvd/Ct/etc.
For example, I would NOT want a "123 Strausburg St." address to turn into "123 Streetrausburg Street".
This note would equally apply to "Ave/Ave", "Blvd", "Ct", "Dr", "Expwy", "Epwy", "Hwy", "Pkwy", "Rd".
NOTE 2.
I do NOT want the routine to find-&-replace.
"123 Strausburg St., S.
."/"123 Strausburg St., SW"/"123 Strausburg St.
S.
."/"123 Strausburg St.
SW", with.
"123 Strausburg StreetS.
." or "123 Strausburg StreetSW" In other words, I do not want to lose the appropriate "space/spacebar" between the "Street" and "S.
." (or "SW").
In my experience, it has been too easy to miss this pesky space/spacebar.
NOTE 3.
I would expect to receive the routine to be given to me in such a way that I could paste into my spreadsheet.
NOTE 4.
I would expect that I could add, in the future, additional "street"-like names into the routine, assuming it was intuitive, OR, I would need written-out instructions (if it was not intuitive).
Required skills and experience.
- Proficient in Microsoft Excel - Experience in creating formulas or scripts for automated processes - Attention to detail for accurate data replacement I require this script or formula to be implemented as soon as possible.
Looking forward to your applications! Processamento de Dados Processamento de dados Excel Python Arquitetura de software ID do Projeto.
# Sobre o projeto 30 propostas Aberto para ofertas Projeto remoto Ativo em 6 minutos atrás
Detalhes da oferta
- Indeterminado
- Em todo Portugal
- Indeterminado - Indeterminado
- 20/04/2024
- 19/07/2024
• creation and execution of test scripts in languages such as java, sql, or gherkin... );• cucumber;• manual tests;• creation and maintenance of test cases and test plans for management tool (jira, ado, etc... outros dados de posição responsibilities:• performing moderately complex work in research,......
· apply, design and develop automated testing strategies and build automated testing frameworks... · analyse and verify best automated and manual test approaches and execute acceptance, integration and system testing... · demonstrable experience and skills in designing and implementing performance testing......
Responsibilities of this role include, but are not limited to:• translate bank technical specifications in agency functional specifications and perform the fis• trax configuration for payments, statements, payment status reports;• configure and establish dhots fis trax connectivity: h2h, swift, ebics......
• you will responsible for the creation and maintenance of services and ci/cd pipelines... • you will develop backend applications for aws using java, kotlin or typescript... • knowledge of spring boot, kafka, and maven/gradle... therefore we encourage all individuals to apply! please provide your cv......
We are looking for a project manager with the following requirements: requisitos do trabalho key skills and responsibilities:• english - c1;• candidates should be confident technical project managers with experience of the full software development lifecycle;• knowledge of agile methodology;• experience......
Function as a mechanical engineer, you will be responsible for: technical support on the preparation of proposals with a focus on rotating and static equipment scope of work; perform engineering activities from conceptual, feed, and detail design; develop materials lists, data sheets, specifications......
We are looking for a scrum master with the following requirements: requisitos do trabalho requirements:• minimum of +2 years of experience as a scrum master, agile coach or agile delivery lead;• scrum master certified;• agile principles & agile frameworks (good understanding of scrum, xp, kanban);• agile......
Nous croyons fermement que les individus talentueux sont l'élément crucial de la réussite des organisations... notre client est un partenaire stratégique des entrepreneurs et dirigeants et propose une expertise comptable ainsi qu’un accompagnement fiscal, indispensables à la création et au développement......