Skip to content

Instantly share code, notes, and snippets.

View devbyray's full-sized avatar
:octocat:
Building cool things!

Dev By Ray devbyray

:octocat:
Building cool things!
View GitHub Profile
function csvToArr(stringValue) {
// Add logic
const formattedString = stringValue.trim().split('\n');
console.log('formattedString: ', formattedString)
}
csvToArr(csvString)
function csvToArr(stringValue) {
// Add logic
const formattedString = stringValue.trim();
}
function csvToArr(stringValue) {
// Add logic
}
const csvString = `
Series_reference,Period,Data_value,Suppressed,STATUS,UNITS,Magnitude,Subject,Group,Series_title_1,Series_title_2,Series_title_3,Series_title_4,Series_title_5
BDCQ.SEA1AA,2011.06,80078,,F,Number,0,Business Data Collection - BDC,Industry by employment variable,Filled jobs,"Agriculture, Forestry and Fishing",Actual,,
BDCQ.SEA1AA,2011.09,78324,,F,Number,0,Business Data Collection - BDC,Industry by employment variable,Filled jobs,"Agriculture, Forestry and Fishing",Actual,,
BDCQ.SEA1AA,2011.12,85850,,F,Number,0,Business Data Collection - BDC,Industry by employment variable,Filled jobs,"Agriculture, Forestry and Fishing",Actual,,
`
const file = csvFileInput.files[0];
const reader = new FileReader();
reader.onload = function (e) {
// Access to content with e.target.result
console.log("content: ", e.target.result);
};
reader.readAsText(file);
form.addEventListener("submit", function (event) {
//logic for when the form is submitted
event.preventDefault();
});
form.addEventListener("submit", function (event) {
//logic for when the form is submitted
});
const form = document.querySelector("#csvForm");
const csvFileInput = document.querySelector("#csvInput");
const textArea = document.querySelector("#csvResult");
body {
font-family: sans-serif;
padding: 1rem;
background: #ccc;
}
form {
display: flex;
flex-direction: column;
gap: 1rem;
margin-bottom: 1rem;
<form id="csvForm">
<input type="file" id="csvInput" accept=".csv" />
<input type="submit" value="Submit" />
</form>
<textarea name="" id="csvResult" cols="30" rows="10"></textarea>