-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathConvertFormat.html
More file actions
91 lines (79 loc) · 2.08 KB
/
ConvertFormat.html
File metadata and controls
91 lines (79 loc) · 2.08 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
<html>
<head>
<script src="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.8.3.min.js"></script>
</head>
<body>
<textarea id="CSVinput" rows="10" cols="20" style="width:500px;"></textarea>
<span id="processCSVinput">Process</span>
</br>
Errors:
<div class="errorArea"></div>
Valid:
<div class="outputArea"></div>
<script type="text/javascript">
$('#processCSVinput').click(function(){
var outputString = "[";
var errorString = "";
var CSVtext = $('#CSVinput').val();
//alert(CSVtext);
var CSVarray = CSVtext.split(/\n/);
for(var i=0; i< CSVarray.length; i++){
if(CSVarray[i]!=",,,,,"){ // Ignore "blank" rows
var tempRow = "[";
var isValid = true;
var rowArray = CSVarray[i].split(',');
if(rowArray.length!=6){
isValid = false;
errorString += "Not enough numbers on row " + i + " : " + CSVarray[i] + "<br\>";
}else{
for(var j=0; j< rowArray.length; j++){
var number = rowArray[j];
if(number.length<1 || !jQuery.isNumeric(number)){
isValid = false;
errorString += "Invalid number '"+number+"' in row "+i+" : " + CSVarray[i] + "<br\>";
}
else{
if(j<5){
if(number>59){
isValid = false;
errorString += "Number '"+number+"' too high in row "+i+" : " + CSVarray[i] + "<br\>";
}
else{
tempRow += number+",";
}
}else{
// Powerball
if(number>39){
isValid = false;
errorString += "Number '"+number+"' too high in row "+i+" : " + CSVarray[i] + "<br\>";
}
else{
tempRow += number;
}
}
}
if(!isValid){
break;
}
}
}
if(isValid){
tempRow += "],";
outputString += tempRow;
}else{
//alert("Error processing: " + CSVarray[i]);
}
}
}
if(outputString.length>5){
outputString = outputString.slice(0, -1); // Remove last comma
outputString += "]";
}else{
outputString = "No values found.";
}
$('.errorArea').html(errorString);
$('.outputArea').html(outputString);
});
</script>
</body>
</html>