Created
November 7, 2018 06:30
-
-
Save milannankov/a64e04e2a282513d86ba81d36d7a7863 to your computer and use it in GitHub Desktop.
Serverless Backend for Data Transformation (Part 1) - bank-statement-transform.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
const moment = require('moment'); | |
const columnIndices = { | |
"datetime": 0, | |
"amount": 2, | |
"dtkt": 3, | |
"reference": 1, | |
"transactionName": 4, | |
} | |
function transformStatement(bankStatement) { | |
let newLines = bankStatement | |
.split("\n") | |
.slice(1) | |
.filter(line => line != "") | |
.map(line => transformStatementLine(line)); | |
let transformedStatement = createHeader() + newLines.join("\n"); | |
return transformedStatement; | |
} | |
function transformStatementLine(line) { | |
let columns = line.split(","); | |
let dateTime = parseDateTime(columns[columnIndices.datetime]); | |
let debitCredit = columns[columnIndices.dtkt]; | |
let amount = parseFloat(columns[columnIndices.amount]); | |
let amountSigned = debitCredit.toLowerCase() == "d" ? amount * -1.0 : amount; | |
let transactionName = columns[columnIndices.transactionName]; | |
let reference = columns[columnIndices.reference]; | |
let newLine = [ | |
dateTime.format("YYYY-MM-DD"), | |
amountSigned, | |
reference, | |
transactionName | |
].join(","); | |
return newLine; | |
} | |
function parseDateTime(dateTime) { | |
var datePart = dateTime.split(" ")[0]; | |
return moment(datePart, "DD/MM/YYYY"); | |
} | |
function createHeader() { | |
return "date,amount_signed,reference,details\n"; | |
} | |
module.exports = transformStatement; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment