Hello all,
I’m trying to parse a .CSV file and store the contents as a float array.I’ve been trying to get this to work for a while now to no avail. My latest attempt is based on this post [JS] How convert a String[] to int[] - Unity Answers
Getting a string array from the file works, but I haven’t found a way to get a float array going.
var TPRead : TextAsset;
var TPReadArr : String[];
var TPRList : List.<float>;
function Start () {
readFile();
}
function readFile() : List.<float> {
TPReadArr = TPRead.text.Split(","[0]);
var TPRList = new List.<float>();
for(var ctt : String in TPReadArr) {
TPRList.Add(float.Parse(ctt));
}
}
That code is getting me the following error
FormatException: Unknown char
System.Double.Parse (System.String s, NumberStyles style, IFormatProvider provider) (at /Users/builduser/buildslave/mono-runtime-and-classlibs/build/mcs/class/corlib/System/Double.cs:209)
System.Single.Parse (System.String s) (at /Users/builduser/buildslave/mono-runtime-and-classlibs/build/mcs/class/corlib/System/Single.cs:183)
CSV Reader.readFile () (at Assets/My Scripts/CSV Reader.js:29)
CSV Reader.Start () (at Assets/My Scripts/CSV Reader.js:20)
Which I don’t understand. The string array shows up full of floats.
Here is the contents of the .CSV just in case.
38.81,40.64,59.3,49.16,41.75,38.56,39.79,52.3,47.38,91.69,53.68,54.28,51.89,49.05,52.98,49.96,55.86,53.28,49.91,50.84,48.25,59.12,52.76,49.76,60.89,48.52,49.41,62.37,57.24,59.25,58.91,72.31,80.13,43.46,73.96,60.4,70.23,82.6,95.4,73.28,61.44,53.98,51.81,48.39,46.43,41.41,41.43,37.73,50.38,47.82,52.55,45.82,49.83,43.86,48.72,46.58,52.21,49.4,128.96,31.24,38.81,37.49,36.67,57.01,63.34,55.77,0,0,0,0,36.25,32.92,39.99,39.63,40.89,37.33,34.79,36.37,36.49,31.88,31.39,31.13,35.95,36.29,32.86,29.22,33.68,34.02,37.46,34.66,36.78,36.97,38.06,39.99,40.23,30.2,0,0,43.11,42.47,39.39,40.47,45.27,41.98,81.81,71.66,76.03,259.72,99.12,0,388.14,33.48,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
610.4,184.39,158.98,125.28,636.25,152.09,139.02,154.1,126.72,123.55,59.61,64.76,75.41,104.64,120.57,409.85,80.55,77.56,74.22,60.55,42.33,99.69,46.3,53.44,38.36,112.15,59.02,126.6,91.12,108.68,110.28,120.65,62.43,79.23,104.83,134.69,127.26,111.24,101,107.4,80.18,117.79,115.42,70.41,140.39,93.39,92.57,63.42,77.99,71.95,60.69,58.65,43.93,43.72,46.69,54.73,42.25,64.56,38.02,45.54,54.99,44.35,42.07,61.45,60.27,42.9,42.29,46.25,45.23,44.37,75.68,77.8,64.19,87.93,71.65,57.34,66.73,62.52,51.48,622.37,195.79,689.68,271.2,233.27,79.32,27.98,28.61,27.14,26.91,28.94,28.89,28.9,27.67,26.17,22.52,25.02,26.31,26.93,19.29,23.7,55.84,32.82,30.65,33.82,30.39,34.95,44.71,29.18,83.55,39.04,38.86,47.45,100.51,88.32,72.26,43.52,149.92,48.08,79.06,43.04,10.49,49.53,49.53,60.64,45.08,36.39,38.36,32.01,30.62,39.41,32.56,33.45,50.76,37.23,33.85,35.97,28.14,29.97,33.37,33.39,37.92,35.4,31.23,30.11,38.84,31.31,32.02,32.3,44.17,33.28,31.26,36.34,31.07,34.4,34.97,37,28.48,26.98,33.77,43,29.47,30.78,30.62,31.43,31.67,32.88,36.14,30.96,30.02,27.29,31.94,28.88,28.83,29.4,29.33,30.59,30.31,28.48,35.23,44.89,36.36,34.92
22.62,19.12,25.06,28,20.82,23.48,21.87,23.98,23.7,87.08,24.68,23.24,19.3,21.49,18.79,21.71,18.78,20.81,17.47,20.88,19.43,25.71,18.79,20.38,26.56,21.99,22.14,23.66,26.58,22.38,19.3,16.41,16.31,20.8,27.86,19.55,18.17,21.14,15.23,22.19,24.25,26.42,27.9,24.25,35.32,29.14,29.55,23.78,28.44,1433.99,616.33,37.35,167.4,35.33,37.78,35.15,26.75,44.43,92.7,259.08,240.44,28.65,87.47,23.46,32.77,22.44,31.27,22.01,70.7,185.85,226.73,201.21,95.28,61.66,27.19,20.57,37.38,22.21,433.69,318.06,131.97,97.69,91.05,76.87,151.69,173.82,141.59,308.27,317.5,497.64,777.7,238.97,155.5,748.81,746.84,458.93,194.25,98,82.14,80.1,47.89,37.78,45.94,32.18,35.93,41.29,46.52,62.11,53.49,53.56,115.12,126.76,51.67,47.06,39.35,38.89,31.7,25.33,46.11,38.72,44.28,41.52,42.45,43.37,44.3,45.22,46.15,47.07,41.33,54.66,87.01,71.6,65.12,60.67,92.17,75.57,70.76,93.42,96.09,120.72,69.11,73.21,76.48,87.95,77.31,70.15,53.23,74.26,107.61,139.21,60.39,75.85,75.26,75.85,77.42,125.19,66.27,70.14,90.7,106.09,74.2,82.06,69.61,66.94,75.2,131.41,185.93,72.29,59.95,63.55,61.15,50.55,56.61,55.73,48.96,58.26,50.51,56.26,51.51,64.47,68.05,52.05
82.1,62.43,80.29,82.53,60.66,52.39,55.21,62.28,71.3,67.53,52.08,56.31,53.41,53.13,185.02,78.78,77.51,75.41,75.13,526.72,107.5,67.09,85.26,127.22,1529.45,107.18,969.14,1234.53,463.12,704.8,1398.48,885.19,1905.76,591.68,621.09,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0