CSV Level loading example

CSVReader.cs

// CSVReader.cs
// Last edited 12:32 PM 04/17/2015 by Aaron Freedman


using System.Linq;
using System.Text.RegularExpressions;
using UnityEngine;

/*
	CSVReader by Dock. (24/8/11)
	http://starfruitgames.com
 
	usage: 
	CSVReader.SplitCsvGrid(textString)
 
	returns a 2D string array. 
 
	Drag onto a gameobject for a demo of CSV parsing.
*/
    public class CSVReader : MonoBehaviour
    {
        public TextAsset csvFile;

        public void Start()
        {
            string[,] grid = SplitCsvGrid(csvFile.text);
            Debug.Log("size = " + (1 + grid.GetUpperBound(0)) + "," + (1 + grid.GetUpperBound(1)));

            DebugOutputGrid(grid);
        }

        // outputs the content of a 2D array, useful for checking the importer
        public static void DebugOutputGrid(string[,] grid)
        {
            var textOutput = "";
            for (var y = 0; y < grid.GetUpperBound(1); y++)
            {
                for (var x = 0; x < grid.GetUpperBound(0); x++)
                {
                    textOutput += grid[x, y];
                    textOutput += "|";
                }
                textOutput += "\n";
            }
            Debug.Log(textOutput);
        }

        // splits a CSV file into a 2D string array
        public static string[,] SplitCsvGrid(string csvText)
        {
            string[] lines = csvText.Split("\n"[0]);

            // finds the max width of row
            var width = 0;
            for (var i = 0; i < lines.Length; i++)
            {
                string[] row = SplitCsvLine(lines[i]);
                width = Mathf.Max(width, row.Length);
            }

            // creates new 2D string grid to output to
            string[,] outputGrid = new string[width + 1, lines.Length + 1];
            for (var y = 0; y < lines.Length; y++)
            {
                string[] row = SplitCsvLine(lines[y]);
                for (var x = 0; x < row.Length; x++)
                {
                    outputGrid[x, y] = row[x];

                    // This line was to replace "" with " in my output. 
                    // Include or edit it as you wish.
                    outputGrid[x, y] = outputGrid[x, y].Replace("\"\"", "\"");
                }
            }

            return outputGrid;
        }

        // splits a CSV row 
        public static string[] SplitCsvLine(string line)
        {
            return
                (from Match m in
                    Regex.Matches(line, @"(((?<x>(?=[,\r\n]+))|""(?<x>([^""]|"""")+)""|(?<x>[^,\r\n]+)),?)", RegexOptions.ExplicitCapture)
                 select m.Groups[1].Value).ToArray();
        }
    }

TextGridLevelLoader.cs

public class TextGridLevelLoader : MonoBehavior
{
    public GameObject[] TilePrefab;
    public TextAsset LevelFile;
    
    private void Start()
    {
        var levelArray = CSVReader.SplitCsvGrid(LevelFile.toString());
        BuildLevel(levelArray);
    }
    
    private void BuildLevel(string[,] levelArray)
    {
        for (var x = 0; x < levelArray.Length; x++)
        {
            for (var y = 0; y < levelArray.Length; y++)
            {
                PlaceTile(x, y, levelArray[x,y]);
            }
        }
    }
    
    private void PlaceTile(int x, int y, int value)
    {
        var o = Instantiate(TilePrefab[value], new Vector3(x, y, 0), Quaternion.Identity) as GameObject;
        // whatever other stuff you need to do when placing a tile
    }
}