turn javascript array into c# array

Hey. I have this javascript file that I'm getting off the web and it consists of basically several large javascript arrays. Since I'm a .net developer I'd like for this array to be accessible through c# so I'm wondering if there are any codeplex contributions or any other methods that I could use to turn the javascript array into a c# array that I could work with from my c# code.

like:

var roomarray = new Array(194);
var modulearray = new Array(2055);
var progarray = new Array(160);
var staffarray = new Array(3040);
var studsetarray = new Array(3221);

 function PopulateFilter(strZoneOrDept, cbxFilter) {
    var deptarray = new Array(111);
    for (var i=0; i<deptarray.length; i++) {
        deptarray[i] = new Array(1);
    }
    deptarray[0] [0] = "a/MPG - Master of Public Governance";
    deptarray[0] [1] = "a/MPG - Master of Public Governance";
    deptarray[1] [0] = "a/MBA_Flex MBA 1";
    deptarray[1] [1] = "a/MBA_Flex MBA 1";
    deptarray[2] [0] = "a/MBA_Flex MBA 2";
    deptarray[2] [1] = "a/MBA_Flex MBA 2";
    deptarray[3] [0] = "a/cand.oecon";
    deptarray[3] [1] = "a/cand.oecon";

and so forth

This is what I'm thinking after overlooking the suggestions:

1. Retrieve the javascript file in my c# code by making an httprequest for it

2. paste it together with some code i made myself

3. from c# call an execute on a javascript function selfmade function that will turn the javascript array into json (with help from json.org/开发者_运维百科json2.js), and output it to a new file

4. retrieve the new file in c# parsing the json with the DataContractJsonSerializer resulting hopefully resulting in a c# array

does it sound doable to you guys?

I'm not in front of a computer with c# right now so I'm not able to fully try this.

What you're going to need to do @Jakob is the following:

1. Write a parser that will download the file and store it in memory.
2. For each section that you want to "parse" into a c# array (for example zonearray), you need to setup bounds to begin searching and end searching the file. Example: We know that zonearray starts building the array the two lines after zonearray[i] = new Array(1); and ends on zonearray.sort().
3. So with these bounds we can then zip through each line between and parse a C# array. This is simple enough I think that you can figure out. You'll need to keep track of sub-index as well remember.
4. Repeat this 2-3 for each array you want to parse (zonearray, roomarray..etc).

If you can't quite figure out how to code the bounds or how to parse the line and dump them into arrays, I might be able to write something tomorrow (even though it's a holiday here in Canada).

EDIT: It should be noted that you can't use some JSON parser for this; you have to write your own. It's not really that difficult to do, you just need to break it into small steps (first figure out how to zip through each line and find the right "bounds").

HTH

EDIT: I just spent ~20 minutes writing this up for you. It should parse the file and load each array into a List<string[]>. I've heavily commented it so you can see what's going on. If you have any questions, don't hesitate to ask. Cheers!

private class SearchBound
{
    public string ArrayName { get; set; }
    public int SubArrayLength { get; set; }
    public string StartBound { get; set; }
    public int StartOffset { get; set; }
    public string EndBound { get; set; }
}

public static void Main(string[] args)
{
    //
    // NOTE: I used FireFox to determine the encoding that was used.
    // 

    List<string> lines = new List<string>();

    // Step 1 - Download the file and dump all the lines of the file to the list.
    var request = WebRequest.Create("http://skema.ku.dk/life1011/js/filter.js");
    using (var response = request.GetResponse())
    using(var stream = response.GetResponseStream())
    using(var reader = new StreamReader(stream, Encoding.GetEncoding("ISO-8859-1")))
    {
        string line = null;

        while ((line = reader.ReadLine()) != null)
        {
            lines.Add(line.Trim());
        }

        Console.WriteLine("Download Complete.");

    }

    var deptArrayBounds = new SearchBound
    {
        ArrayName = "deptarray",                    // The name of the JS array.
        SubArrayLength = 2,                         // In the JS, the sub array is defined as "new Array(X)" and should always be X+1 here.
        StartBound = "deptarray[i] = new Array(1);",// The line that should *start* searching for the array values.
        StartOffset = 1,                            // The StartBound + some number line to start searching the array values.
                                                    // For example: the next line might be a '}' so we'd want to skip that line.
        EndBound = "deptarray.sort();"              // The line to stop searching.
    };

    var zoneArrayBounds = new SearchBound
    {
        ArrayName = "zonearray",
        SubArrayLength = 2,
        StartBound = "zonearray[i] = new Array(1);",
        StartOffset = 1,
        EndBound = "zonearray.sort();"
    };

    var staffArrayBounds = new SearchBound
    {
        ArrayName = "staffarray",
        SubArrayLength = 3,
        StartBound = "staffarray[i] = new Array(2);",
        StartOffset = 1,
        EndBound = "staffarray.sort();"
    };

    List<string[]> deptArray = GetArrayValues(lines, deptArrayBounds);
    List<string[]> zoneArray = GetArrayValues(lines, zoneArrayBounds);
    List<string[]> staffArray = GetArrayValues(lines, staffArrayBounds);
    // ... and so on ...

    // You can then use deptArray, zoneArray etc where you want...

    Console.WriteLine("Depts: " + deptArray.Count);
    Console.WriteLine("Zones: " + zoneArray.Count);
    Console.WriteLine("Staff: " + staffArray.Count);
    Console.ReadKey();

}

private static List<string[]> GetArrayValues(List<string> lines, SearchBound bound)
{
    List<string[]> values = new List<string[]>();

    // Get the enumerator for the lines.
    var enumerator = lines.GetEnumerator();

    string line = null;

    // Step 1 - Find the starting bound line.
    while (enumerator.MoveNext() && (line = enumerator.Current) != bound.StartBound)
    {
        // Continue looping until we've found the start bound.
    }

    // Step 2 - Skip to the right offset (maybe skip a line that has a '}' ).
    for (int i = 0; i <= bound.StartOffset; i++)
    {
        enumerator.MoveNext();
    }

    // Step 3 - Read each line of the array.
    while ((line = enumerator.Current) != bound.EndBound)
    {

        string[] subArray = new string[bound.SubArrayLength];

        // Read each sub-array value.
        for (int i = 0; i < bound.SubArrayLength; i++)
        {

            // Matches everything that is between an equal sign then the value 
            // wrapped in quotes ending with a semi-colon.
            var m = Regex.Matches(line, "^(.* = \")(.*)(\";)$");

            // Get the matched value.
            subArray[i] = m[0].Groups[2].Value;

            // Move to the next sub-item if not the last sub-item.
            if (i < bound.SubArrayLength - 1)
            {
                enumerator.MoveNext();
                line = enumerator.Current;
            }
        }

        // Add the sub-array to the list of values.
        values.Add(subArray);

        // Move to the next line.
        if (!enumerator.MoveNext())
        {
            break;
        }
    }

    return values;
}

If I understand your question right, you are asking whether you can execute JavaScript code from C#, and then pass the result (which in your example would be a JavaScript Array object) into C# code.

The answer is: Of course it’s theoretically possible, but you would need to have an actual JavaScript interpreter to execute the JavaScript. You’ll have to find one or write your own, but given that JavaScript is a full-blown programming language, and writing interpreters for such a large and full-featured programming language is quite an undertaking, I suspect that you won’t find a complete ready-made solution, nor will you be able to write one unless your dedication exceeds that of all other die-hard C#-and-JavaScript fans worldwide.

However, with a bit of trickery, you might be able to coerce an existing JavaScript interpreter to do what you want. For obvious reasons, all browsers have such an interpreter, including Internet Explorer, which you can access using the WinForms WebBrowser control. Thus, you could try the following:

• Have your C# code generate an HTML file containing the JavaScript you downloaded plus some JavaScript that turns it into JSON (you appear to have already found something that does this) and outputs it in the browser.
• Open that HTML file in the WebBrowser control, have it execute the JavaScript, and then read the contents of the website back, now that it contains the result of the executed JavaScript.
• Turn the JSON into a C# array using DataContractJsonSerializer as you suggested.

This is a pretty roundabout way to do it, but it is the best I can think of.

I have to wonder, though, why you are retrieving a JavaScript file from the web in the first place. What generates this JavaScript file? Whatever generates it, surely could generate some properly readable stuff instead (e.g. an XML file)? If it is not generated but written by humans, then why is it written in JavaScript instead of XML, CSV, or some other data format? Hopefully with these thoughts you might be able to find a solution that doesn’t require JavaScript trickery like the above.

Easiest solution is to just execute the Javascript function that makes the array. Include there a function that makes it an JSON (http://www.json.org/js.html). After that make a XMLHttpRequest (AJAX) to the server and from there extract the JSON to a custom class.

If I may use jQuery, here's an example of the needed Javascript:

var myJSONText = JSON.stringify(deptarray);
(function($){
    $.ajax({
        type: "POST",
        url: "some.aspx",
        data: myJSONText,
        success: function(msg){
            alert( "Data Saved: " + msg );
        }
    });
})(jQuery);

Only now need some code to rip the JSON string to an C# Array.

EDIT:
After looking around a bit, I found Json.NET: http://json.codeplex.com/
There are also a lot of the same questions on Stackoverflow that ask the same.