Loading Info From a CSV File

munkygomoo · Aug 13, 2002

I have a csv file that looks like such :

1010241,400
1010242,200
1010243,300

How do I get JavaScript to read each line of information by itself so it can deal with it properly?

For instance, I want to make it look like this in the end:

data[1] = new dat(1010241,400);
data[2] = new dat(1010242,200);
data[3] = new dat(1010243,300);

Can anyone help me? - JGD -

adam0101 · Aug 13, 2002

In IE you could use an IFRAME. Although, you may need to add code to detect whether the IFRAME is loaded or not.

Code:

/* read the contents of the IFRAME and split into an array on the line break */
rows=document.frames(&quot;iframeName&quot;).document.body.innerHTML.
replace('&lt;XMP&gt;',').replace('&lt;\/XMP&gt;',').split(&quot;\n&quot;);
/*loop through the lines and split each line on the commas, then add to your data array*/
for(row=0;row&lt;rows.length;row++){
  cols=rows[row].split(',')
  data[data.length]=new dat(cols[0],cols[1])
}

munkygomoo · Aug 14, 2002

I tried that, but it didn't work... can I send you the files (an 8.75 kb HTML file, an 885 byte CSS file, and a 101 byte CSV file) and have you look at it? - JGD -

munkygomoo · Aug 15, 2002

Take a look at :

http://jgdees2000.tripod.com/HTML/index.html

for what I'm trying to do

// ***
Also viewable are style.css and databook.csv in the same directory
// *** - JGD -

jemminger · Aug 15, 2002

hi JGD,

the example below will take the chunk of csv text, split it into individual lines, then create dat() objects by splitting each line on the comma. hope this gives you some ideas!

[tt]
<html>
<head>
<title>csv to data</title>

<script name="javascript">
var aData = new Array();

function getData(sArgs) {
var aArgs = sArgs.split(/\s/);

for (idx = 0; idx < aArgs.length; idx++) {
aData[idx] = new dat(aArgs[idx]);
}
}
function dat() {
var a = arguments[0].split(',');
for (inx = 0; inx < a.length; inx++) {
this[inx] = a[inx];
}
}
function showData() {
for (idx = 0; idx < aData.length; idx++) {
sMsg = "";
for (el in aData[idx]) {
sMsg += "aData[" + idx +
"][" + el + "] = " +
aData[idx][el] + "\n";
}
alert(sMsg);
}
}
</script>

<style type="text/css">
</style>

<meta name="author" content="?">
<meta name="keywords" content="?">
<meta name="description" content="?">
</head>

<body onload="">
<form name="" action="" method="">
<textarea name="databook" rows="8" cols="35">A1371001,250,0,150,0,0,200,100,0
A1231002,70,0,130,0,200,0,0,350
A1451003,0,150,0,200,150,0,120,0 </textarea>
<p />
<input type="button" name="" value="getData();" onclick="getData(this.form.databook.value);" />
<p />
<input type="button" name="" value="how many dat() objects?" onclick="alert(aData.length);" />
<p />
<input type="button" name="" value="show dat() objects" onclick="showData();" />
</form>
</body>
</html>
[/tt] =========================================================
if (!succeed) try();
-jeff

Guest_imported · Aug 15, 2002

MS has a way in IE of reading CSV files: Tabular data Control TDC form of Data Source Objects DSO.

If you are interested, it runs only on IE4 and above.

It lets you read a file as if it were a collection to navigate.

Interested? Reply and I will tell more.

http://www.webreference.com/dhtml/column39/4.html

jonathanku · Sep 8, 2005

The TDC stuff looks really good.

Does anyone know if you can access the data in this way?

i.e. it's easy to get a table cell to display the data, but can I read the following data into a JavaScript variable:
datasrc="#tdcStaff"
datafld=FirstName

I need to read the actual data then process each piece of data individually. Is that possible?

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Loading Info From a CSV File

munkygomoo

Programmer

adam0101

Programmer

munkygomoo

Programmer

munkygomoo

Programmer

jemminger

Programmer

Guest_imported

New member

jonathanku

Technical User

Similar threads

Part and Inventory Search

Sponsor