Skip to content

Instantly share code, notes, and snippets.

@abel-masila

abel-masila/json.json

Last active May 21, 2018 11:23
Show Gist options
  • Save abel-masila/866cec4b54b781e0b1b2c3670ce180d9 to your computer and use it in GitHub Desktop.
Save abel-masila/866cec4b54b781e0b1b2c3670ce180d9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
json.json
[
{
"COVER ISSUE DATE ": "25-Jan-2018",
"IMPORT / EXPORT": "IMPORT",
"POLICY NUMBER": "jub/2018/0298",
"OPEN COVER (YES or NO)": "YES",
"ENDORSEMENT NUMBER": "jub/2018/0298/001",
"ICC CLASS (ICC-A, ICC-B or ICC-C)": "ICC-A",
"INSURED NAME": "Another buyer",
"INSURED EMAIL ADDRESS": "[email protected]",
"INSURED TIN": "999-666-333",
"BROKER / AGENT NAME": "ANOTHER BROKER",
"BROKER / AGENT TIN": "111-222-333",
"CATEGORY OF GOODS [SEE REF - 1]": "Live Animals; Animal Products",
"COUNTRY OF ORIGIN/ EXPORT CODE [SEE REF - 2]": "US",
"CONVEYANCE": "SEA",
"FINANCIER": "exim",
"CURRENCY CODE [SEE REF - 3]": "USD",
"EXCHANGE RATE USED": "2250",
"SUM INSURED - TZS": "1,000,000,000.00",
"PREMIUM CHARGED (VAT Inclusive) - TZS": "100,000.00",
"VAT AT 18% - TZS": "18,000.00",
"UNIT OF MEASURE": "kgs",
"QUANTITY": "25.00",
"COVER START DATE": "25-Jan-2018"
},
{
"COVER ISSUE DATE ": "25-Jan-2018",
"IMPORT / EXPORT": "IMPORT",
"POLICY NUMBER": "303598340",
"OPEN COVER (YES or NO)": "NO",
"ENDORSEMENT NUMBER": "303598340",
"ICC CLASS (ICC-A, ICC-B or ICC-C)": "ICC-B",
"INSURED NAME": "Mwingine",
"INSURED EMAIL ADDRESS": "[email protected]",
"INSURED TIN": "888-555-222",
"BROKER / AGENT NAME": "ANOTHER AGENT",
"BROKER / AGENT TIN": "444-555-666",
"CATEGORY OF GOODS [SEE REF - 1]": "Prepared Foodstuffs Beverages, Spirits, Tobacco",
"COUNTRY OF ORIGIN/ EXPORT CODE [SEE REF - 2]": "TZ",
"CONVEYANCE": "SEA",
"CURRENCY CODE [SEE REF - 3]": "TZS",
"EXCHANGE RATE USED": "1",
"SUM INSURED - TZS": "20,000,000,000.00",
"PREMIUM CHARGED (VAT Inclusive) - TZS": "2,000,000.00",
"VAT AT 18% - TZS": "360,000.00",
"UNIT OF MEASURE": "ltrs",
"QUANTITY": "1,520.00",
"COVER START DATE": "30-Mar-2018"
},
{
"COVER ISSUE DATE ": "25-Jan-2018",
"IMPORT / EXPORT": "EXPORT",
"POLICY NUMBER": "2018-01-23-061",
"OPEN COVER (YES or NO)": "YES",
"ENDORSEMENT NUMBER": "2018-01-23-061-00021",
"ICC CLASS (ICC-A, ICC-B or ICC-C)": "ICC-C",
"INSURED NAME": "Kampuni ltd",
"INSURED EMAIL ADDRESS": "[email protected]",
"INSURED TIN": "777-444-111",
"BROKER / AGENT NAME": "BROKER XYZ",
"BROKER / AGENT TIN": "777-888-999",
"CATEGORY OF GOODS [SEE REF - 1]": "Chemicals And Chemicals Products",
"COUNTRY OF ORIGIN/ EXPORT CODE [SEE REF - 2]": "GB",
"CONVEYANCE": "AIR",
"CURRENCY CODE [SEE REF - 3]": "GBP",
"EXCHANGE RATE USED": "3564",
"SUM INSURED - TZS": "300,000,000.00",
"PREMIUM CHARGED (VAT Inclusive) - TZS": "75,000,000.00",
"VAT AT 18% - TZS": "13,500,000.00",
"UNIT OF MEASURE": "kgs",
"QUANTITY": "25,052.00",
"COVER START DATE": "1-Feb-2018"
}
]
@BransonGitomeh
Copy link

simple

const data = [
    {
        "COVER ISSUE DATE ": "25-Jan-2018",
        "IMPORT / EXPORT": "IMPORT",
        "POLICY NUMBER": "jub/2018/0298",
        "OPEN COVER (YES or NO)": "YES",
        "ENDORSEMENT NUMBER": "jub/2018/0298/001",
        "ICC CLASS (ICC-A, ICC-B or ICC-C)": "ICC-A",
        "INSURED NAME": "Another buyer",
        "INSURED EMAIL ADDRESS": "[email protected]",
        "INSURED TIN": "999-666-333",
        "BROKER / AGENT NAME": "ANOTHER BROKER",
        "BROKER / AGENT TIN": "111-222-333",
        "CATEGORY OF GOODS  [SEE REF - 1]": "Live Animals; Animal Products",
        "COUNTRY OF ORIGIN/ EXPORT CODE [SEE REF - 2]": "US",
        "CONVEYANCE": "SEA",
        "FINANCIER": "exim",
        "CURRENCY CODE [SEE REF - 3]": "USD",
        "EXCHANGE RATE USED": "2250",
        "SUM INSURED - TZS": "1,000,000,000.00",
        "PREMIUM CHARGED (VAT Inclusive) - TZS": "100,000.00",
        "VAT AT 18% - TZS": "18,000.00",
        "UNIT OF MEASURE": "kgs",
        "QUANTITY": "25.00",
        "COVER START DATE": "25-Jan-2018"
    },
    {
        "COVER ISSUE DATE ": "25-Jan-2018",
        "IMPORT / EXPORT": "IMPORT",
        "POLICY NUMBER": "303598340",
        "OPEN COVER (YES or NO)": "NO",
        "ENDORSEMENT NUMBER": "303598340",
        "ICC CLASS (ICC-A, ICC-B or ICC-C)": "ICC-B",
        "INSURED NAME": "Mwingine",
        "INSURED EMAIL ADDRESS": "[email protected]",
        "INSURED TIN": "888-555-222",
        "BROKER / AGENT NAME": "ANOTHER AGENT",
        "BROKER / AGENT TIN": "444-555-666",
        "CATEGORY OF GOODS  [SEE REF - 1]": "Prepared Foodstuffs Beverages, Spirits, Tobacco",
        "COUNTRY OF ORIGIN/ EXPORT CODE [SEE REF - 2]": "TZ",
        "CONVEYANCE": "SEA",
        "CURRENCY CODE [SEE REF - 3]": "TZS",
        "EXCHANGE RATE USED": "1",
        "SUM INSURED - TZS": "20,000,000,000.00",
        "PREMIUM CHARGED (VAT Inclusive) - TZS": "2,000,000.00",
        "VAT AT 18% - TZS": "360,000.00",
        "UNIT OF MEASURE": "ltrs",
        "QUANTITY": "1,520.00",
        "COVER START DATE": "30-Mar-2018"
    },
    {
        "COVER ISSUE DATE ": "25-Jan-2018",
        "IMPORT / EXPORT": "EXPORT",
        "POLICY NUMBER": "2018-01-23-061",
        "OPEN COVER (YES or NO)": "YES",
        "ENDORSEMENT NUMBER": "2018-01-23-061-00021",
        "ICC CLASS (ICC-A, ICC-B or ICC-C)": "ICC-C",
        "INSURED NAME": "Kampuni ltd",
        "INSURED EMAIL ADDRESS": "[email protected]",
        "INSURED TIN": "777-444-111",
        "BROKER / AGENT NAME": "BROKER XYZ",
        "BROKER / AGENT TIN": "777-888-999",
        "CATEGORY OF GOODS  [SEE REF - 1]": "Chemicals And Chemicals Products",
        "COUNTRY OF ORIGIN/ EXPORT CODE [SEE REF - 2]": "GB",
        "CONVEYANCE": "AIR",
        "CURRENCY CODE [SEE REF - 3]": "GBP",
        "EXCHANGE RATE USED": "3564",
        "SUM INSURED - TZS": "300,000,000.00",
        "PREMIUM CHARGED (VAT Inclusive) - TZS": "75,000,000.00",
        "VAT AT 18% - TZS": "13,500,000.00",
        "UNIT OF MEASURE": "kgs",
        "QUANTITY": "25,052.00",
        "COVER START DATE": "1-Feb-2018"
    }
]

const result = []
data.map(item => {
    const fixed = {}
    const keys = Object.keys(item)
    keys.map(key => {
        fixed[key.toLocaleLowerCase()] = item[key]
    })
    result.push(fixed)
})

console.log(result)

@BransonGitomeh
Copy link

result

[ { 'cover issue date ': '25-Jan-2018',
    'import / export': 'IMPORT',
    'policy number': 'jub/2018/0298',
    'open cover (yes or no)': 'YES',
    'endorsement number': 'jub/2018/0298/001',
    'icc class (icc-a, icc-b or icc-c)': 'ICC-A',
    'insured name': 'Another buyer',
    'insured email address': '[email protected]',
    'insured tin': '999-666-333',
    'broker / agent name': 'ANOTHER BROKER',
    'broker / agent tin': '111-222-333',
    'category of goods  [see ref - 1]': 'Live Animals; Animal Products',
    'country of origin/ export code [see ref - 2]': 'US',
    conveyance: 'SEA',
    financier: 'exim',
    'currency code [see ref - 3]': 'USD',
    'exchange rate used': '2250',
    'sum insured - tzs': '1,000,000,000.00',
    'premium charged (vat inclusive) - tzs': '100,000.00',
    'vat at 18% - tzs': '18,000.00',
    'unit of measure': 'kgs',
    quantity: '25.00',
    'cover start date': '25-Jan-2018' },
  { 'cover issue date ': '25-Jan-2018',
    'import / export': 'IMPORT',
    'policy number': '303598340',
    'open cover (yes or no)': 'NO',
    'endorsement number': '303598340',
    'icc class (icc-a, icc-b or icc-c)': 'ICC-B',
    'insured name': 'Mwingine',
    'insured email address': '[email protected]',
    'insured tin': '888-555-222',
    'broker / agent name': 'ANOTHER AGENT',
    'broker / agent tin': '444-555-666',
    'category of goods  [see ref - 1]': 'Prepared Foodstuffs Beverages, Spirits, Tobacco',
    'country of origin/ export code [see ref - 2]': 'TZ',
    conveyance: 'SEA',
    'currency code [see ref - 3]': 'TZS',
    'exchange rate used': '1',
    'sum insured - tzs': '20,000,000,000.00',
    'premium charged (vat inclusive) - tzs': '2,000,000.00',
    'vat at 18% - tzs': '360,000.00',
    'unit of measure': 'ltrs',
    quantity: '1,520.00',
    'cover start date': '30-Mar-2018' },
  { 'cover issue date ': '25-Jan-2018',
    'import / export': 'EXPORT',
    'policy number': '2018-01-23-061',
    'open cover (yes or no)': 'YES',
    'endorsement number': '2018-01-23-061-00021',
    'icc class (icc-a, icc-b or icc-c)': 'ICC-C',
    'insured name': 'Kampuni ltd',
    'insured email address': '[email protected]',
    'insured tin': '777-444-111',
    'broker / agent name': 'BROKER XYZ',
    'broker / agent tin': '777-888-999',
    'category of goods  [see ref - 1]': 'Chemicals And Chemicals Products',
    'country of origin/ export code [see ref - 2]': 'GB',
    conveyance: 'AIR',
    'currency code [see ref - 3]': 'GBP',
    'exchange rate used': '3564',
    'sum insured - tzs': '300,000,000.00',
    'premium charged (vat inclusive) - tzs': '75,000,000.00',
    'vat at 18% - tzs': '13,500,000.00',
    'unit of measure': 'kgs',
    quantity: '25,052.00',
    'cover start date': '1-Feb-2018' } ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment