Excel: add country codes to a list of languages

Closed job

Recent jobs from category Jobs for students

  • no avatar
    maciej.sienkiewicz
    One Page Website
    Proposed by freelancer
    31
    18d
    Hi, I'm looking for someone to embrace HTML and CSS for my One Page Website. I have a prepared design - no water features. A simple headline, two pictures, with four sentences of text and that's it. The site is not supposed to scroll on a PC and is supposed to be responsive.
  • no avatar
    W pełni ja
    Creating in canva
    Proposed by freelancer
    52
    18d
    I need a person who will also apply already created texts to video on already created template in canva. I am looking for a person who can start doing this on the spot. I have about 90 micro projects to create per month
  • no avatar
    PL Recruitment LTD 34 deals
    Presentation preparation
    Proposed by freelancer
    50
    6d
    I would like to prepare a power point presentation in two languages, Polish and English, on the subject of studying in the UK and our offer. All the information that should be in the presentation after the conclusion of the contract I will send in a message
  • no avatar
    CORVUS IT SP. Z O.O. 6 deals
    SAP BW data warehouse programmer
    Proposed by freelancer
    0
    4d
    I am looking for SAP BW data warehouse programmer to provide services of building, development, maintenance and documentation of information systems. Term of service minimum from July to December 2024. working 8h a day. REQUIREMENTS: - experience in designing complex HD data analysis structures, - Familiarity with SAP BW wholesaler (version 7.4) experience for a minimum of 2 years, - Project experience in the energy market, - experience in programming in ABAP language, - ability to use data mining tools (BEx, Business Objects), - knowledge of design patterns, - Experienced with using JIRA/Confluence environment for project execution, - ability to cooperate in a team - punctuality and reliability in cooperation Information from Useme: bidding is possible only if: - possession of a valid student ID card (for pupils/students up to 26 years of age) - confirmed statement of full-time employment for at least the minimum wage - having a business activity
  • no avatar
    Maciej1018 4 deals
    Presentation preparation
    Proposed by freelancer
    35
    4d
    We are looking for a person who will prepare for us presentations on specific topics for training in Polish. We care about the substantive content, graphically the presentation will be refined by our graphic designers. Our expectations: - substantively correctly prepared presentation on the basis of the materials that we provide and acquired by the preparer, - basic graphic design (directing graphics to prepare good quality graphics and video) - we allow the use of GPT, while we do not allow to download the finished presentation (unfortunately, in our case it will not work!) - the presentation will be part of the training prepared with voiceover, therefore, the text of the presentation is to be developed as spoken text (read by the voiceover) + additional text information We care about the high quality of the prepared materials in connection with this each presentation will be reviewed by a copywriter
  • no avatar
    ERPixel
    Hi all. I need Odoo Full Stack developer for ongoing projects. Duties: - Odoo new modules development - Customization of Odoo standard modules - Integration Odoo and other software - Odoo Themes Development Requirements: - Odoo experience for 4 years is mandatory - Knowledge of Odoo JavaScript is mandatory - Availability for 8 hrs per day, Poland time - English language writing / speaking is preferable. Notification from Useme: submission of offers is only possible if you: - have a valid school or student ID card (students up to the age of 26) - have a signed statement certifying you have an employment contract for at least minimum wage - you are self-employed
Procurence Sp. z o.o.
Procurence Sp. z o.o.
Employer
Job category:
Other
Expected budget:

Negotiable

Published:
Valid until:

Job description

We need to show a country flag next to a language in our system, but we only have the ISO language codes.

We have an Excel file that contains a list of LANGUAGE CODES with languages and for each of the 177 entries we need a corresponding ISO-2 country code to be able to show a COUNTRY FLAG next to the language name.

In case there is no matching flag --> e.g. English-Carribean (not one country) then use xx code instead.

In case the language does not contain a country code, then use the most likely country - eg. en --> gb (to show british flag for english). In case the language is used in multiple countries (like afrikaans) use the largest country/most likely country)

In case there are doubts, you can add comments in a separte colums for us to decide.

e.g.

af Afrikaans ---> za

en-au English - Australia ---> au

en-bz English - Belize --> bz

en-ca English - Canada --> ca

en-cb English - Caribbean --> xx

en-in English - India --> in

You have the list of country codes here:

https://www.iban.com/country-codes

List of language codes:

https://en.wikipedia.org/wiki/List_of_ISO_639-1_codes

The job in figures:

177 languages codes to link to a respective country code and to find the local name of the country